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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
atuldevAuthor Commented:
if it is related to Network or Windows Firewall, how it can be resolved?
0
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
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 & Architect, EE Solution GuideCommented:
angelIII,

Since I have answered the questions appropriately, I would recommend

Split between http:\\a31253412 and http:\\31275683
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.