Unable to establish the connection Microsoft SQL

Asked By 70 points N/A Posted on -
qa-featured

Hello DBA’s,

When I try to establish the connection Microsoft SQL, I ended up with an error message. It says the server does not exist or access denied. However, to my knowledge server exist and I have an authority to access the server. How do I establish the connection now? Do I need to check the settings? How do I check where I went wrong? Please help. Thanks. 

Microsoft SQL Server Login

Connection failed:

SQL State: ‘01000’

SQL Server Error: 5

[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen

(Connect()).

Connection failed:

SQL State: ‘08001’

SQL Server Error: 17

[Microsoft][ODBC SQL Server Driver][DBNETLIB] SQL Server does not exist or access denied.

SHARE
Answered By 70 points N/A #169891

Unable to establish the connection Microsoft SQL

qa-featured

Such error will pop up if SQL Server is utilizing other protocol except “TCP/IP”.

To resolve this issue, do the followings:

  1. From Start menu, type “Run” >> hit Enter.
  2. Type “Cliconfg.exe” >> press “OK”.
  3. In “SQL Server Client Network Utility” box, open “General” tab.
  4. From the drop down list, click “Default Network Library”.
  5. Move “TCP/IP” to the top of the list.
  6. Uncheck “Force protocol encryption”.
  7. Close “SQL Server Client Network Utility” by pressing “OK”.
  8. Restart “SQL Services”.

If the problem still persists,

  1. Start “Cliconfg.exe”.
  2. Open “General” tab.
  3. Select “TCP/IP” >> click “OK”.

Now your problem is good to go.

Login/Register to Answer

Related Questions