Belly Pain More Condition_symptoms

Enable the SA account on SQL Server 2005

These days I formatted the laptop and I had to rebuild the development environment than usual. Between 1000 and popped up a version of SQL Server 2005 Express that comes with the Framework. NET and Visual Studio. The only problem is that the database, as configured, is only applicable to a minimum but, with some registry tweaks, you can turn it into a real db utilities and being able to create their own database.

First of all, you must install Microsoft SQL Server Management Studio Express that is nothing more than a simple graphical interface that will handle MSSQL server.

Now, let's go to the registry, try the key "HKEY_LOCAL_MACHINE \\ SOFTWARE \\ Microsoft \\ Microsoft SQL Server \\ MSSQL.1 \\ MSSQLServer" value "LoginMode" and impostiamolo from 1 (Windows Integrated Authentication) to 2 (Authentication mixed).

At this point, and execute SQL SMSE colleghiamoci to the server via Windows integrated authentication impersonating a user with elevated rights. If you have Vista, you run the application as an administrator!

From there we execute this simple query:

   alter login sa enable; 
  alter  login  sa   with   password =   'nuova_password'  ; 

Finally, restart the instance of SQL Server database and you can log on as SA. Of course, being the "sa" account for SQL Server the equivalent of linux "root", you should use this only for the user management tasks to the db engine (create or attach new db, create new users with limited access, etc.) and use for normal users limited work on the database.

NOTE: The license is not violated in any way. The same result would be obtained BEFORE installing SQL Server 2005 Express and then. NET Framework.