By Armand Niculescu on October 18, 2006
http://www.richnetapps.com/forgot_or_lost_sql_server_sa_password_1/
Here’s a neat thing to remember if you’re using MSSQL:
To change the “sa” password, login to your computer using an administrator account. Open your SQL Server and log in using Windows Authentication. Open a new query window and type in the following command:
SP_PASSWORD @NEW = 'new_password', @loginame = 'sa'
After that go to section Security –> Logins –> double click “sa” or choose properties. Go to “Status” and check to see if “Login:” is enabled. If not, enable it.
http://www.richnetapps.com/forgot_or_lost_sql_server_sa_password_1/
Here’s a neat thing to remember if you’re using MSSQL:
To change the “sa” password, login to your computer using an administrator account. Open your SQL Server and log in using Windows Authentication. Open a new query window and type in the following command:
SP_PASSWORD @NEW = 'new_password', @loginame = 'sa'
After that go to section Security –> Logins –> double click “sa” or choose properties. Go to “Status” and check to see if “Login:” is enabled. If not, enable it.
扫一扫
3994
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
