Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

'sa' password getting reset Expand / Collapse
Author
Message
Posted Friday, June 21, 2013 3:23 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, July 18, 2014 5:07 AM
Points: 65, Visits: 203
Hi,

I have sql 2k8 R2 working OK. from last few days my 'sa' password is getting re-set automatically. i know it is not possible but it is happening to me.

then i have to login with window authn. and reset password almost every day.
Even i have formatted a server and scanned with anti-virus too. Even though problem is there.


pls help.
Post #1466101
Posted Friday, June 21, 2013 3:35 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 2:13 PM
Points: 39,866, Visits: 36,208
Create a trace (or look in the default trace) for security events. I can't remember offhand which event it is, Books Online will have details.

p.s. Why are you using the sa login? That login should be disabled.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1466103
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse