Owner of the job is 'sa'. The step failed. Then I checked the Server Logs. SQL Server is terminating this process.. I use 'sa' to login in the Registration Properties.
I also tried to registered with both 'local' and 'servername', always got this error message. Hi Trevor That would rule out permissions for the account. Do you know what type of backup the maintenance plan is doing? Have you tried dropping the plan and creating a new one?
John Bell wrote: Hi Trevor That would rule out permissions for the account. Yes, that didn't help. I got the client to reboot their server in the end, this seemed to have cured the problem. Thanks for the advice. This discussion thread is closed Start new discussion.
Similar topics. NET Framework. Exception Login failed for user ' null '. Microsoft SQL Server. Failed to Start Monitoring Directory Changes. Asked by:. Archived Forums. SQL Server Express.
Sign in to vote. I would like to backup my SQL database using built-in tool sqlmaint. But after I hit Enter in command line I receive help content which probably means that I have error in my syntax. Please advice. Thursday, November 19, AM. Shabeer M. I have changed my job profile from being a project leader to DBA. You could say am an aspiring DBA. I am facing the same problem. I have a query regarding this. Could this be a security issue as Ray had mentioned earlier?
The job is backing up the user databases. I have checked whatever has already been mentioned above. This user does not have the specific databases added into its list of database access. Will this be a problem? Carl Federl. If so, you will encounter a lot of problems. Change the accounts using Enterprise Manager, restart the computer, then change the accounts again, restart and finally retry the maintenance plans.
A Plockyn. My vote goes to the job cleanup. If Tivoli or Windows Backup is hitting a file when your job tries to delete it I think you can get the You must be logged in to reply to this topic. Login to reply. Post reply.
0コメント