Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Changing authentication mode

Author  Topic 

krisrajz
Starting Member

19 Posts

Posted - 2012-11-27 : 00:53:44
I have MS SQL 2008 SP1 running on Windows 7 SP1 Professional.

Recently I have changed authentication of MS SQL to Windows NT. After changing the authentication mode I could not connect and getting the message connection failed for the user <user>. I tried as admin user as well. Connecting SQL using -m connects only integration service and SQL Database Engine. Any fix would be appreciated.

Thank you

Regards
Raj
   

- Advertisement -