Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Nov 27, 2012 08:30 AM by Slewey
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.
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:
Nov 27, 2012 01:31 AM|LINK
This connects only integration services ... with that I could not do anything!
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.