March 11, 2013 at 12:36 pm
4044 - SA account can be unlocked by rebooting server with trace flag. If sa (or sso_role) password is lost, add this to your RUN_serverfile. This will generate new password when server started.
http://www.sqlservercentral.com/articles/trace+flags/70131/
http://social.technet.microsoft.com/wiki/contents/articles/13105.trace-flags-in-sql-server.aspx
I've seen this trace flag listed on a couple web sites but cannot get it to work. I've tried adding it as a startup parameter in configuration manager. SQL starts but there's no output and I can find the RUN_server file anywhere. All the searching I've done points to Sybase (it is also a Sybase trace flag).
I was just interested to test it out. It could be handy when users install a local instance and forget their password.
Has anyone else implemented this successfully?
Thanks
-Jeff
Jeff Gogel
March 11, 2013 at 4:30 pm
There's easier ways to get back into an instance that you've locked out. Start SQL in single user and any local admin is sysadmin, no traceflags required.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply