DBNETLIB SQL SERVER DOES NOT EXIST or ACCESS DENIED

I have a VB Application which uses SQL Server 2000. From many years this application is running in network for as many as 15 users.

Suddennly two days back two PC's on Network Started giving this message

DBNETLIB: SQL SERVER DOES NOT EXISTS or ACCESS DENIED.

Tried to reinstall SQL connecivity on the respective PC's, tried IP Address for connecting server with default port 1433.

It started working for once but later it again start giving the same error message.

Can anybody help me to find out the solution, i am in big problem.

Thanks a lot.
atuldevAsked:
Who is Participating?
 
Raja Jegan RConnect With a Mentor SQL Server DBA & ArchitectCommented:
Check for the following:

* Whether SQL Server service is up and running
* Windows Firewall blocking your port 1433 or any other application blocking it.
* Network connectivity issues ( most probable)
* Browser service is up and running if you have multiple instances in the machine.

Try doing this from command prompt in your client machine

telnet serverip 1433

This should open up a blank window all times ( during times you receive that error too) else you have definitely network and/or windows Firewall issues.
0
 
atuldevAuthor Commented:
if it is related to Network or Windows Firewall, how it can be resolved?
0
 
Raja Jegan RConnect With a Mentor SQL Server DBA & ArchitectCommented:
You need to exclude sqlserv.exe and exclude TCP port 1433 and UDP port 1434 from Windows Firewall( if it is Firewall issue).

If it is network connectivity related issue, you need to contact your Network Administrator to resolve those issues.
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
angelIII,

Since I have answered the questions appropriately, I would recommend

Split between http:\\a31253412 and http:\\31275683
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.