SQL Server add sysadmin role

SQL Server add sysadmin role

Source:

• https://serverfault.com/questions/53645/don-t-have-permission-to-access-sql-server-express-2008

Shut down SQL Server from services

net stop MSSQL$SQLEXPRESS

Open cmd-window (as admin) and run single-user mode as local admin with this command

"C:\Program Files\Microsoft SQL Server\MSSQL11.SQLEXPRESS\MSSQL\Binn\sqlservr.exe" -m -s SQLEXPRESS

Other cmd-window (as admin):

sqlcmd -S .\SQLEXPRESS

Add your user to the 'sysadmin' group:

 sp_addsrvrolemember 'DOMAIN\user1', 'sysadmin'
 GO
 quit

Ctrl+C the single-user mode from the first cmd window to kill SQL Server.

Start services:

net start MSSQL$SQLEXPRESS

Log into Management Studio and the user you created should be listed under logins with the credential of "sysadmin."