Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

'sa' password getting reset Expand / Collapse
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, May 20, 2016 5:49 AM
Points: 74, Visits: 222

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



Group: General Forum Members
Last Login: Saturday, December 3, 2016 5:18 AM
Points: 45,619, Visits: 44,147
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, MVP, M.Sc (Comp Sci)
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