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.

M Dallag
M Dallag used Ask the Experts™
on
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.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Distinguished Expert 2017
Commented:
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.
Most Valuable Expert 2012
Distinguished Expert 2018

Commented:
We need more information.

I assume SQL Server?

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

Has it ever worked?

What versions?

Commented:
A lot more information is needed. Can other machines connect successfully to the database. What if any error messages are you getting?
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
Awarded 2009
Distinguished Expert 2018

Commented:
>> 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.
Apurva BhandariLinux/Cloud/DB/DevOps

Commented:
Check with telnet to IP and PORT. If it is working then there is no issue to connect to DB.

Author

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

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial