problems connecting to a MS SQL DB - TechRepublic
General discussion
February 3, 2006 at 11:56 AM
james schroer

problems connecting to a MS SQL DB

by james schroer . Updated 20 years, 4 months ago

I’m having some issues connecting to one of our DB servers. It’s confusing both me and our DBAs. I’m trying to use a program that connects to SQL. I’m able to connect using SQL authentication but can’t using Windows Authentication and this is just on my machine it works fine on other machines. The next part is that I can connect fine using a different DB server. I tried to create and ODBC connecton and it will work with SQL Authentication but not with Windows Authentication UNLESS…. I change the setting to “name pipes” Then with that ODBC connection made with name pipes the program works. Any thoughts why it’s not connecting via tcp/ip?

This discussion is locked

All Comments