October 27, 2010 at 6:25 am
i had sceduled backup maintenance plan but it is getting failed when i see the error it shows the owner of the job does not have server access but under security - > both public and sysadmin is checked for the user. Kindly let me know what should i do to give access for the owner
October 27, 2010 at 6:49 am
Can you please post the complete error message?
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
October 27, 2010 at 7:21 am
Plese look into the msg below
Message
The job failed. The owner (domainame) of job Complete Backup.Subplan_1 does not have server access.
October 27, 2010 at 8:00 am
If the Login "domainname" has System Admin privileges on the instance as stated earlier, then the issue has to be outside of SQL Server. Do you see any error messages in System Event Log at that time, where this server is unable to connect to the Active Directory or something related?
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
October 27, 2010 at 8:11 am
when i run the job there is no error getting generated in event viewer but the domainname\user has sysadmin as server role under security
October 27, 2010 at 11:13 am
Is this a new maintenance plan or one that worked and now fails? If the later of the two, has there been any issues with the DNS server?
You may try to Stop | Start SQL Server Agent to reestablish
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply