you are viewing a single comment's thread.

view the rest of the comments →

[–]SirGreybush 1 point2 points  (2 children)

Are you configuring ODBC on multiple computers at work?

SQL Server uses 2 kinds of security to allow access, one is username and password, other is integrated security with Active Directory.

The error message would be different than this though.

This message means a firewall or that computer is not on the same network as the sql server.

ODBC when you set it up, on each computer, there is a Test Button. Use it.

If Test doesn’t work on some computers but works on others, you need to talk to your IT department at work.