Scenario :
I have install SQL Server 2005 or Later versions automatically two logins are created 'sa' and 'BUILTIN\Administrators'. By following security best practices I have removed BUILTIN\Administrators login and I have forgot my 'sa' password. How can I handle this scenario.
Solution:
No need to reinstall SQL Server
We can reset 'sa' password by running the server in single user mode.
Steps :
1. Ask windows team to add windows account into administrator role.
2. Stop SQL Server Instance and start it in singe user mode for ex if instance name is test
Go to command prompt
net stop MSSQL$Test
net start MSSQL$Test /m
3.Now open SQL Server Management Studio .
4.Connect using windows authentication mode , connection will be successed.
5.Reset 'sa' password or create new login if you want.
6.Restart server in multi-user mode.
7.Now connect using 'sa' and with new password.
I have install SQL Server 2005 or Later versions automatically two logins are created 'sa' and 'BUILTIN\Administrators'. By following security best practices I have removed BUILTIN\Administrators login and I have forgot my 'sa' password. How can I handle this scenario.
Solution:
No need to reinstall SQL Server
We can reset 'sa' password by running the server in single user mode.
Steps :
1. Ask windows team to add windows account into administrator role.
2. Stop SQL Server Instance and start it in singe user mode for ex if instance name is test
Go to command prompt
net stop MSSQL$Test
net start MSSQL$Test /m
3.Now open SQL Server Management Studio .
4.Connect using windows authentication mode , connection will be successed.
5.Reset 'sa' password or create new login if you want.
6.Restart server in multi-user mode.
7.Now connect using 'sa' and with new password.
No comments:
Post a Comment