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
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: Thursday, November 20, 2014 12:36 AM
Points: 65, Visits: 205

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: Today @ 9:26 AM
Points: 41,287, Visits: 37,879
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