Error "[DBNETLIB][ConnectionOpen(Connect()).] SQL server does not exist or access denied"

Question

Hi,

We are getting an error "[DBNETLIB][ConnectionOpen(Connect()).] SQL server does not exist or access denied" for few users on accessing ERP application and most of the users are able to access application without any issue. We have enabled TCP/IP and namepipes but still we are facing the same issue. I'm new to SQL.

Your help will be highly appreciated to resolve this issue.

Thanks in advance.

Regards,
Musaib

Answer 1

Is there may be a Firewall running on the client machine, blocking the access?
=> Configure a Windows Firewall for Database Engine Access

Otherwise see MS Support: Solving Connectivity errors to SQL Server

Answer 2

Hi MusaiPat-5515,

Are you using the default instance? Are the instance listening on port 1433?
If the SQL Server instance is a default instance and listen on port 1433, please ensure an exception is added to TCP port 1433 in the Windows firewall. If the default instance is listening on a non-standard port, Please refer to this article which might help.
If the SQL Server instance is a named instance and listen on dynamic port, please make sure SQL browser service is indeed started and UDP port 1434 is not blocked on the firewall between the client and the server. If you cannot do either of them, you should switch your SQL Server instance to use a static port and add static port to firewall exclusion list.
In addition, please check if there are incorrect alias on the client machine.

Best Regards,
Amelia

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread

Answer 3

Hi

I have found a simple solution for the error on my side

1. Check server and work station date and time. They should be the same.
2. Check network modum and wifi router date and time. Should be same as Server and Workstation.

If any of the network hardware or computers are out of sync with date and time sql will give [DBNETLIB] relatred errors

Answer 4

Hi,

 

To whom may concern, you should also verify your sql connection string for errors. For example if you have the server or instance name misspelled, the system gives you this error.

 

Regards,

 

Nuno

Answer 5

It asked me if I would like to debug it , from there I was able to figure out that it was a wrong connection string in one of my local sites running in the IIS. I just stopped that website or I could've updated the correct db ip address.