General discussion

Locked

problems connecting to a MS SQL DB

By James Schroer ·
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 conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by BFilmFan In reply to problems connecting to a ...

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.

Collapse -

by James Schroer In reply to

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.

Collapse -

by ergdemirel In reply to problems connecting to a ...

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!!

Collapse -

by James Schroer In reply to

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.

Collapse -

by James Schroer In reply to problems connecting to a ...

This question was closed by the author

Back to Networks Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums