Monthly Archives: April 2022

Add sysadmin role to a user in Microsoft SQL Express

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 … Continue reading

Posted in Uncategorized | Leave a comment