<h2>Connect to SQL Server when administrator user is deleted and SA user is disabled</h2>
1. Stop the SQL Server and SQL Server Agent services in Services.msc.
Go to Start –> Run –> services.msc
Stop the SQL Server and SQL Server Agent Service.
2. Open a command prompt window.
Go to Start –> Run –> cmd and press the ‘OK’ button
change directory to SQL Server’s Binn directory as shown below.
C:\MSSQL2008\MSSQLSERVER\MSSQL\Binn>
3. Start the SQL Server in single user mode (sqlservr -m)
C:\MSSQL2008\MSSQLSERVER\MSSQL\Binn> sqlservr -m
wait for 5 minutes
4. Connected with window system administrator.
START –> RUN –> cmd
C:\> sqlcmd -E
-E option is used as trusted connection
5. Create login with sysadmin privileges :
create logins mssql with password=’mssql’;
go
exec sp_addsrvrolemember [mssql],[sysadmin]
go
6. Start SQL Server Management Studio and connect with new created logins.
7. Test permission with following command:
sp_helpsrvrolemember sysadmin