NEED ANSWER FAST (about sa password now blank)
-
Can someone please explain to me how you can have a password on the sa account and then it goes blank???
I installed SQL Server on a 2003Server on a cluster environment. Then I installed SP3. I put a sa password when I did the install. Now that the auditors are here it is showing the sa password as blank???
To my knowledge no one has re-insalled SQL. How could this happen.
Is there somewhere other than the event viewer or SQL logs I can look to
to see what happened and when?
I need answers so it does not happen again.
Thanks for any help you can give.
-
If Enterprise Manager is not set to ask for the password whenever it connects then all you have to do to reset the SA password is start EM and edit the server properties.
How do you know that someone hasn't fired off EM and done precisely that?
If EM has to request a password in order to connect then the gremlins cannot change your password.
-
check your sqlserver logs. If sa-password has been altered, it records a line in the sqlserver errorlog.
Don't get confused with windows authentication !
If you login using windows authentication, there is no need to supply a password ! If your windows user is then member of local windows administrators, and you didn't revoke builtin\administrators from sqlserver, you'll have sa-authorities ! (or when you nt-account has been added to the sysadms sqlservergroup).
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply