Connect SQL SERVER instance when there is no logins working.
Sometimes we may miss password or logins not working to connect sql server in this case follow the below steps to connect the instance.
1. Stop the instance.
2. Open CMD in Adminstator mode- Root to SQL Server bin folder with -m which will start the sql server in single user mode.
3. Open another CMD in adminstrator mode- Run the script to set the new login or create login .
4. Exit both CMD and start the instance.
No comments:
Post a Comment