Skip to main content

How can I configure Microsoft SQL server settings?

  • Updated
We moved this page to our Documentation Portal. You can find the latest updates here.

Question

I need to add built-in/administrator permissions for MS SQL. How can I configure Microsoft SQL server settings?

Answer

To enable admin permissions in MS SQL:

  1. Log in as an admin.
  2. Create new mssql.bat file and paste the following information:

    • If you are using a paid licensed version:

      net stop MSSQLSERVER
reg add "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQLServer\Parameters" /v "SQLArg3" /t REG_SZ /d "-mSQLCMD" /f
net start MSSQLSERVER
sqlcmd -S. -Q "CREATE LOGIN [BUILTIN\Administrators] FROM WINDOWS WITH DEFAULT_DATABASE=  [master], DEFAULT_LANGUAGE=[us_english]"
sqlcmd -S. -Q "EXEC master..sp_addsrvrolemember @loginame = N'BUILTIN\Administrators', @rolename = N'sysadmin'"
net stop MSSQLSERVER
reg delete "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQLServer\Parameters" /v "SQLArg3" /f
net start MSSQLSERVER

    • If you are using an  Express Edition:

      net stop MSSQL$SQLEXPRESS
reg add "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQLServer\Parameters" /v "SQLArg3" /t REG_SZ /d "-mSQLCMD" /f
net start MSSQL$SQLEXPRESS
sqlcmd -S.\SQLEXPRESS -Q "CREATE LOGIN [BUILTIN\Administrators] FROM WINDOWS WITH DEFAULT_DATABASE=  [master], DEFAULT_LANGUAGE=[us_english]"
sqlcmd -S.\SQLEXPRESS -Q "EXEC master..sp_addsrvrolemember @loginame = N'BUILTIN\Administrators', @rolename = N'sysadmin'"
net stop MSSQL$SQLEXPRESS
reg delete "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQLServer\Parameters" /v "SQLArg3" /f
net start MSSQL$SQLEXPRESS
  3. Save the file.
  4. Run the mssql.bat file you have just created for the changes to come into effect.