August 22, 2013 at 7:58 am
I recently moved the location of the tempdb databases to another drive from the C: to F: following BOL step by step. After restarting the SQL service my backups would not work giving the following error:
The job failed. Unable to determine if the owner (DC\gchappell) of job Backup-bbbbbbbbb-Full has server access (reason: Could not obtain information about Windows NT group/user 'DC\gchappell', error code 0x6e. [SQLSTATE 42000] (Error 15404)).
Before the move of tempdb and restart of services everything completed no problem. Has anyone else encountered anything like this? It appears the restart may have wiped out my permissions.
Any help is appreciated.
August 22, 2013 at 4:17 pm
Judging from the error message, the service account for SQL Agent has problem accessing the AD to validate the user. 0x63 = 110, and NET HELPMSG 110 says:
The system cannot open the device or file specified.
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
August 22, 2013 at 4:22 pm
I doubt those two events are related. Sounds like something has happened to your account in AD (maybe recreated) so it no longer matches to the SID SQL holds for it.
Change the owner of the job to sa.
---------------------------------------------------------------------
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply