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.
Senior Engineer Jessie
Comments