Fix: Microsoft SQL Server Error 6 11001

While trying to access a Microsoft SQL server instance, you may receive the following error trying to connect.

Microsoft SQL Server Login

Connection Failed:

SQLState: ‘01000’

SQL Server Error: 11001

[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (Connect()).

Connection failed:

SQLState: ‘08001’

SQL Server Error: 6

[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Specified

SQL server not found.

Ensure your SQL DSN instances are correctly pointing in your Windows Server. There may be an incorrect DNS reference configured.