question

MusaibPat-5515 avatar image
1 Vote"
MusaibPat-5515 asked VijayvargiaSudipta-6050 commented

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


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

sql-server-general
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi,
I am having the exact same problem with a win 10 machine. I really wonder about if you can find a solution ?
regards,
Nigar.

0 Votes 0 ·

Hi, I'm getting the same issue/. My use case is, I'm calling out a view in Excel & using windows authentication.
Some users are able to connect and get data, while some get this error message.

I'm checking other articles on how to fix this, but not sure exactly where the issue is.

https://www.accessrepairnrecovery.com/blog/fix-error-sql-server-does-not-exist-or-access-denied.

Can someone help.

0 Votes 0 ·
MichaelOlivier-0119 avatar image
0 Votes"
MichaelOlivier-0119 answered

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




5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AmeliaGu-msft avatar image
0 Votes"
AmeliaGu-msft answered DirkHondong commented

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


· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi,

I have no problems to connect to the server via Excel ort etc, but only from the SAS programme giving me exact warning, I am really in need any suggestions,
best,

0 Votes 0 ·
DirkHondong avatar image DirkHondong NigarAydemir-4218 ·

Hi NigarAydemir-4218,

is your SAS programm on the same machine as Excel?
If yes than it is more of a SAS problem.
If no: make a simple connectivity check from there, e.g. configure a odbc connection if your target sql server is accessible at all from the location.

1 Vote 1 ·
OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered

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


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.