How do you a password of a user in MSDE
So I forgot the SA password and so I need to login to SQL server as to change the password for the SA account how do I go about doing that?
Answer:
That actually is pretty easy. On the system that has the SQL server login using osql -E.
Then make use of the following stored procedure:
1> sp_password @old = null, @new = 'complexpwd', @loginame ='sa'
2>go;
0 Comments:
Post a Comment
<< Home