I was able to resolve the CREATE CONNECTION with the Microsoft documentation.
https://learn.microsoft.com/en-us/azure/databricks/query-federation/sql-server
The user account you use to test the connection must have read/write permissions in the database. Also add your Databricks instance with read/write permissions.