After I change authentication mode and restart MS SQL Server, I could not connect using Windows Authentication and getting the message Login failed for user <user>. Please let me know how to enable SQL Authentication again?!
I am running MS SQL 2008 on Windows 7 SP1.
Regards,
Raj
Remember to click Mark as Answer on the post that helps to others.
You can start SQL Server in Single-User mode by adding '-m' as start-up parameter. By doing so, any member of the computer's local Administrators group can then connect to the instance of SQL Server as a member of the sysadmin fixed server role.
Maybe I misunderstood. But I assumed you can't connect at all anymore due to the authentication change.
If so, you can use the single-user mode, as posted before, connect to Management Studio and enable SQL authentication again.
krisrajz
Participant
1845 Points
541 Posts
Windows Authentication:Login failed for user <user>
Nov 23, 2012 03:39 PM|LINK
After I change authentication mode and restart MS SQL Server, I could not connect using Windows Authentication and getting the message Login failed for user <user>. Please let me know how to enable SQL Authentication again?!
I am running MS SQL 2008 on Windows 7 SP1.
Raj
Remember to click Mark as Answer on the post that helps to others.
Slewey
Participant
1080 Points
154 Posts
Re: Windows Authentication:Login failed for user <user>
Nov 25, 2012 11:31 AM|LINK
You can start SQL Server in Single-User mode by adding '-m' as start-up parameter. By doing so, any member of the computer's local Administrators group can then connect to the instance of SQL Server as a member of the sysadmin fixed server role.
Please see the following references on how to do that:
http://msdn.microsoft.com/en-us/library/ms188236%28v=sql.105%29.aspx
http://msdn.microsoft.com/en-us/library/dd207004%28v=sql.105%29.aspx
krisrajz
Participant
1845 Points
541 Posts
Re: Windows Authentication:Login failed for user <user>
Nov 27, 2012 01:31 AM|LINK
This connects only integration services ... with that I could not do anything!
Raj
Remember to click Mark as Answer on the post that helps to others.
Slewey
Participant
1080 Points
154 Posts
Re: Windows Authentication:Login failed for user <user>
Nov 27, 2012 08:30 AM|LINK
Maybe I misunderstood. But I assumed you can't connect at all anymore due to the authentication change.
If so, you can use the single-user mode, as posted before, connect to Management Studio and enable SQL authentication again.