SQL Server

Troubleshooting and turning on SQL Server Authentication mode

2 doors side by side. Left door is red. Right door is yellow.

Scenario Anyone who has ever connected to a remote system before has invariably encountered authentication or connection issues. Unfortunatly, due to the security implications of connecting to remote systems, the error message returned is not always helpful. For instance, I came across the message below when trying to connect to a remote SQL Server instance …