Monday, March 12, 2012

Failed Connected to Sql 2005 Enterprise Edition

Hi,

We have a Sql 2005 server. It was setup by out network administrators who do not know much about sql server. It's running on Mixed Mode (Sql Server & Windows Authentication Mode). I have been able to connect to it use Integrated Security. However, I have not been able to connect to it using an username and a password. I have tried with sql accounts and windows accounts. Out of frustration, I used sql administrator account and windows domain administrator accounts. I also tried using the account the sql server is running on. But each and every time, I failed and received the following error message:

Login failed for user '<<User Name>>'. The user is not associated with a trusted SQL Server connection.

I have also changed my connection string many times, but it doesn't matter. And I have been able to connect to our Sql 2000 servers successfully.

Please help!!

Pak

The error message indicates that you are only using WIndows authentication. After switching to Mixed Auth., did you restart the service ? do have eventually have multiple instances on the machine and you are connecting to the wrong database ?

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

its looks like still in Windows Authentication. Check that first. ALso if it is a named instance of sql server 2005 you need to start SQL browser Server or Mention the Port in connection string

Check this.

http://madhuottapalam.blogspot.com/2007/01/sql-browser-service-in-sql-2005.html

|||

Jens and Madhu:


Thanks for your help. You are 100% correct. It turned out that one of our developers change the authentication mode to mix mode without restarting SQL server.

Pak

No comments:

Post a Comment