Knowledgebase
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
Posted by Sean Syed on 23 February 2013 05:06 PM

If you get the following error, while trying to access MS-SQL server,

"Error: Test connection to the database server has failed because of network problems:
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied."

Follow the steps mentioned below.

1. Login to the server >> Start >> All Programs >> Microsoft SQL Server >> Configuration Tools >> SQL Server Configuration Manager >> SQL Server Network Configuration >> Protocols for MSSQLSERVER >> right click “TCP/IP” and select “Enable”.

2. Start >> Run >> type “services.msc” >> Restart SQL service.

Now you can access MS-SQL server.

(268 vote(s))
Helpful
Not helpful

Comments (4)
NicolasP
20 September 2013 12:12 AM
Awesome! Thank you!
gani
13 October 2013 05:09 AM
awesome buddy
Ram
16 March 2014 02:36 PM
Thaarmaar... :)
Gilfanz
14 May 2014 11:35 PM
Commentum thaarmaar!!!
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please enter the text you see in the image into the textbox below (we use this to prevent automated submissions).