I am getting this error when trying to connect to a SQL DB on only one PC

[DBNETLIB][ConnectionOpen (connect().]SQL Server does not exist or access denied.
 I set the firewall inbound rules for TCP and UDP on port 1433-1434
The ODBC settings "System DSN" client configuration is set for TCP/IP only.
I am not sure why this is the only PC not able to connect to the database but i cant find the reason for it.

Thank you for your time.
mspencer100Asked:
Who is Participating?
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.

QlemoBatchelor, Developer and EE Topic AdvisorCommented:
Are you using ODBC?
Can you ping the server from that PC by name and IP?
The inbound connections in the local firewall on this PC does not matter. All connections are initiated by the client, and hence outgoing.
0
mspencer100Author Commented:
Yes i can ping by name and by IP. I also have the same port for outgoing. Yes the APP tech cant seem to figure out why its not connecting either and he has settings in the ODBC admin tool.
0
Deepak ChauhanSQL Server DBACommented:
Did you try connecting by IP. Is name is successfully resolved?
0
pcelbaCommented:
The rule No. 1 says: If something is wrong with 1 PC out of many then reinstall this one PC. It is the most cost effective solution.

Of course, if you have time to play with various settings,  inspect the firewall, search and update registry, check DLL versions, read event logs, and finally replace some hardware parts to avoid HW problems then nothing against it.

Does the problem happen for all users logging on the problematic PC?
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
Vitor MontalvãoMSSQL Senior EngineerCommented:
Did you test the connection from the ODBC?
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
Microsoft SQL Server 2005

From novice to tech pro — start learning today.

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.