Enable SA account MS SQL server
for a very weird application I required SA account to be active but MS SQL server 2005 has it turned off by default. Probably Microsoft’s safest bet turn off all possible remote access
Looks like a justified move but could be a little annoying.
I couldn’t logon using the command line so thought of installing the MS SQL express management studio. Which allowed me to login as local admin.
After loging-in you can goto the security Tab and change the authentication mode to mixed (SQL and windows).
Change the permissions for user SA to allow logins.
This should now allow you to login as SA.
SA accounts are preferred to be local so please make sure your actions don’t trigger any security lapses
Its suggested that you rather use another account to allow minimal web access to the instance.
Sri :: Dec.21.2008 :: :: No Comments »