July 31, 2013 at 4:08 am
Hi Experts,
We lost SQL Server sa password and our windows authentication is not allowing us to login .
How can i connect to server now?
July 31, 2013 at 4:59 am
Troubleshooting: Connecting to SQL Server When System Administrators Are Locked Out
Joie Andrew
"Since 1982"
July 31, 2013 at 6:36 am
Thanks for the reply.
I am local admin but still getting login failed error
July 31, 2013 at 6:37 am
Able to connect using
NET START MSSQLSERVER /f /T3608
July 31, 2013 at 6:41 am
Glad that you were able to connect. Just a warning though don't leave it running with the /f switch. That puts SQL Server into single-user mode, so other connections will get rejected.
Even if you are a local system admin you can be locked out of SQL if the BUILTIN\Administrators group was taken out of the sysadmins server role. The article I posted is how to work around that if your login does not have access, regardless of whether you are a sysadmin or not.
Joie Andrew
"Since 1982"
July 31, 2013 at 9:21 am
Thanks alot Joie
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply