- Stop SQLExpress service
- Run Command Prompt with administrator rights
- Find your install folder, for example
C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS\MSSQL\Binn - Start SQL Express in single-user mode:
sqlservr.exe -sSQLEXPRESS -m”SQLCMD” -c
- Open another Command Prompt window (with administrator rights) and connect to the running instance of SQL Express:
SQLCMD -S .\SQLEXPRESS
- Run three commands, modifying the first as appropriate for your user to grant them the desired role:
sp_addsrvrolemember 'DOMAIN\user', 'sysadmin' go quit
- Go back to the running instance and kill it with Control-C
- Start SQLExpress service
- The user specified above should now have sysadmin Server Role
Add sysadmin role to a user in Microsoft SQL Express
Reply