You may be trying to access this site from a secured browser on the server. Please enable scripts and reload this page.
Turn on more accessible mode
Turn off more accessible mode
Skip Ribbon Commands
Skip to main content
Turn off Animations
Turn on Animations
Sign In
Use SHIFT+ENTER to open the menu (new window).
To navigate through the Ribbon, use standard browser navigation keys. To skip between groups, use Ctrl+LEFT or Ctrl+RIGHT. To jump to the first Ribbon tab use Ctrl+[. To jump to the last selected command use Ctrl+]. To activate a command, use Enter.
Browse
Tab 1 of 3.
Page
Tab 2 of 3.
Publish
Tab 3 of 3.
Home
Add sysadmin role to SQL manually
It looks like your browser does not have JavaScript enabled. Please turn on JavaScript and try again.
Updated Pages
Fix Corrupted System Tray Notification Icons
Bypass WSUS to install Windows features
Home
Add sysadmin role to SQL manually
Caller ID, YAC, XBMC and Asterisk
Pictures
Wiki Pages
All KB Articles
Search Knowledge Base
Site Contents
Add sysadmin role to SQL manually
Open SQL Server Configuration Manager
Stop all SQL Server Services
Open a command prompt and change directories into the SQL instance path\MSSQL\Binn
Start SQL by typing: sqlservr.exe -m
Open a second command prompt and change directories into SQL Tools\Binn
Connect to SQL by typing sqlcmd.exe -S (IP Address of Instance) -E
Type: exec sp_addsrvrolemember @loginame='DOMAIN\user',@rolename='sysadmin'
Type: go
Type: exit
Switch to the SQL instance and press Ctrl-C to stop the instance
Restart all services and connect with SQL Management Studio