Knowledgebase
(28)Applications (16)DNS (23)Domains (9)Downloads (61)eMail (5)File Transfer Protocol (144)Flash Tutorials (18)General (11)IIS (4)Migrations (30)MSSQL Server (10)MySQL Server (74)Plesk Panel (2)Security and Hack (9)SEO (3)Server Settings (10)Services (3)SSL Certificates (9)Your Account
SEARCH
Knowledgebase
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
Posted by on 18 August 2012 02:36 AM

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.

(5 vote(s))
Helpful
Not helpful
Comments (0)
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).