Unable to establish the connection Microsoft SQL

Asked By Ray L Brown 70 points N/A Posted on - 05/26/2014

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.

• Status: Open
• Question Views: 796
• Answer Count: 1
• Vote Up 2 Vote Down

• Answer Accepted: No
• Question Category: MySQL Server

Answered By points N/A #169891

Unable to establish the connection Microsoft SQL

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.

About

Questions
0

Answers
6

Best Answers
31531

• Vote Up 0 Vote Down

• Posted on - 05/26/2014
• Question Category: MySQL Server