Report Offensive Message

Re:How do i Enable the 'sa' Login in SQL Server 2005
Hi Hardik,

Its very simple,

Launch SQL Server Management Studio Express and login using windows authentication.

Now right click on your server instance and under the Security properties choose SQL Server and Windows Mode.

Now Restart the instance, you can now login using your SA Login

Final note:
Always try to use Windows Authentication as it is considered a best practice.

Kind Regards
Anil Mahadev
Senior SQL Server DBA
http://anilm001.myfreewebs.net
Posted by anilm001@...
28th Feb 2009