a machine is not connecting to the SQL database. We suspected that it could be due to privilege or drivers, but neither solved the issue.

a machine is not connecting to the SQL database. We suspected that it could be due to privilege or drivers, but neither solved the issue.
Mohammed DallagPetroleum ConsultantAsked:
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.

arnoldCommented:
What is the setup?
Can the machine ping the db server?
Check IPs, netmask path.

Are there other system connecting, or is it the first?
If first, check the SQL server configuration to make sure it is configured for TCP/ip
Mist Windows servers have Windows hire wall, Foun,e check the SQL service, port 1433 commonly is allowed on the incoming side of advanced firewall settings.

Confirm the server network is in the correct connection type, commonly domain, or work/private and not public.
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
slightwv (䄆 Netminder) Commented:
We need more information.

I assume SQL Server?

What error or message or ??? are you getting?

Has it ever worked?

What versions?
0
Matt BowlerDB team leadCommented:
A lot more information is needed. Can other machines connect successfully to the database. What if any error messages are you getting?
0
Powerful Yet Easy-to-Use Network Monitoring

Identify excessive bandwidth utilization or unexpected application traffic with SolarWinds Bandwidth Analyzer Pack.

Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
>> a machine is not connecting to the SQL database.

As other experts already requested, we would need more details as below:
1. Are you able to ping the SQL database server from that machine. If not, what is the error you are receiving.
2. Does the login you use to connect to SQL Database from other machines also not working on that specific problematic machine.

>> We suspected that it could be due to privilege or drivers, but neither solved the issue.

If it is privilege, then that login shouldn't work from other machines as well.
Ideally, drivers won't play a role on these kind of errors.
If that particular machine can't access with this login or any other login, then check for firewall or any network related things that prevent this machine from connecting to SQL Server machine.
0
Apurva BhandariLinux/Cloud/DB/DevOpsCommented:
Check with telnet to IP and PORT. If it is working then there is no issue to connect to DB.
0
Mohammed DallagPetroleum ConsultantAuthor Commented:
Arnold,

Thank you so much.

We found out that one port was blocked and it was the one that SQL connected to.

Regards,

Dallag
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
SQL

From novice to tech pro — start learning today.