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 a 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
    CODE

    • 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
    CODE
  3. Save the file.
  4. Run the mssql.bat file you have created for the changes to come into effect.