Sometimes there might be a situation when DBA may forget ‘sa’ password and there is no other way to login to SQL Server, in that situation DBA may reset the ‘sa’ password or add another user with SA rights.
To do this, first Stop SQL Server and then start SQL Server with –m option in startup parameter to start SQL in single user mode.
Then login to Windows with Domain Administrator and use sqlcmd utility to connect to sql server. Once connected, write t-sql commands to reset ‘sa’ password or add another domain user with SA rights. After completion, stop SQL Server, remove –m option from startup parameters and restart sql server.
To reset sa password, use the following script.
C:\Users\Administrator>sqlcmd -E -Ssql2k8
1> alter login sa with password = 'password'
This procedure has been tested with SQL Server 2008, where server was already added to domain.
you may have taken backups on local storage, file servers, NAS, etc. Now a days it is becoming crucial you have backup copies available in...
Replication in SQL Server is one of the features I like the most. I use Replication for many applications including Report Server, Data Ware...
DISCLAIMER: ANONYMOUS ACCESS IS NOT RECOMMENDED as it may give direct access to your report server or report objects to any one who knows th...
Swarndeep Singh is a SQL Server Solutions Specialist with expertise in Performance Turning, Database Designing, Cloud Computing, Databas...