Knowledgebase: MSSQL Server
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
Posted by 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.

(337 vote(s))
Not helpful

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