February 17, 2011 at 12:14 am
hi
i have a problem
about 3 months ago till now sometimes change sa password automatically and i can not open my some software that related to sql
i dont know how is happen and who do this in my network in my company
thanks a lot
PLEASE guide me
Best Regards
O.MOLLAZADEH
* mailto: mollazadeh@niroutrans.com
February 17, 2011 at 1:08 am
Hi
Do you have access to the Management Studio? If you do, you can reset it by going to Security -> Logins
then right click properties on the sa account and change the password.
Just another thing, I hope you are not using the sa account to connect via your applications? Rather create a login with only the necessary permissions to use in your applications.
February 17, 2011 at 1:11 am
is your sql server windows authentication or mixed mode authentication?
If mixed mode then you can login with some windows account which is configured with sa permission and then reset the password for sa account. And this time when you resetting the password, make sure you not selecting 'enforce password expiration' and 'user must change password at next login' ( if you not wish to)
----------
Ashish
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply