While trying to connect to a database at work I encountered a few hurdles. There were a few moving parts that had to come together in order for me to finally run a single query on the database tables.
Those parts were:
- The database was a SQL Server instance
- The SQL Server was on-premise
- Authentication was done via Active Directory using Domain Credentials
- I’d be connecting to the SQL Server from my laptop running macOS
Once my Active Directory account was granted access to the database I encountered my first roadblock when trying to configure a connection to the database…