November 24, 2009 at 2:48 pm
This error has started cropping up in several of my production servers:
The job failed. Unable to determine if the owner (AMERICAS\$svcpnbsqlprod001) of job UDMaintenancePlan.DBA-Trans Log Backup for All User Databases has server access (reason: Could not obtain information about Windows NT group/user 'AMERICAS\$svcpnbsqlprod001', error code 0x5. [SQLSTATE 42000] (Error 15404)).
This is our production service account which is used for the Logon Account for both the Database Engine and Agent services. It has Local Server SysAdmin privileges on the box, and SysAdmin privileges on the SQL instance, and it is not locked out at the Active Directory level. I've been researching this error and have found several forum messages describing the issue in different contexts, but I haven't come across any solutions yet.
Has anyone encountered this problem and found a viable solution?
Senior SQL Server DBA
November 24, 2009 at 4:16 pm
We had this crop up for us a few months back. We removed the machines and then readded the machine to AD and the issue was resolved.
Seeing the forums on this, and I see that there seems to be different fixes for different people. I didn't see what worked for us listed so maybe it will work for you as well.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply