Networks

Ask something
Discussion Locked

problems connecting to a MS SQL DB

0 helpful
5 replies

by james schroer 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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?

5 replies

by bfilmfan

Which version of SQL is that server on which you are having an issue?

Before SQL 2000, you could only have one version of SQL on a server (see http://msdn2.microsoft.com/en-us/library/ms165724.aspx)

What error messages are showing on the SQL server and the workstation involved?

Ensure that remote connection via TCP/IP in the Remote properties in the SQL Server Service configuration window for both the SQL Server Engine and Also Analysis services is enabled.

by james schroer

Actually found out that my Norton IDS (Intruder Detection System) Files were corrupt. In the log it said that my machine was trying to attach the DB server. Once I repaired the file it worked fine.

by ergdemirel

I think it's about your settings. If you set sql server connection type windows authentication when you installed, you can't connect it via sql authentication since you not define any sql server authenticated user. But don't worry, you can fix it. Select your sql server properties from enterprise manager.Chechk authentication type! if it's only windows auth.,change it to both windows and sql server auth. type. Create your user and try to connect again. If you already did this one. Download and install sql server and windows latest service packs!

Good Luck!!

by james schroer

Actually found out that my Norton IDS (Intruder Detection System) Files were corrupt. In the log it said that my machine was trying to attach the DB server. Once I repaired the file it worked fine.

This discussion is closed to new replies.