Post reply

SQL 2005 Maintenance Plan failed

  • October 13, 2008 at 4:19 pm

    #194445

    I am new to SQL 2005. I just downloaded adventureworks database and trying to create a maintenance plan.. It fails and gives me this error:

    The job failed. Unable to determine if the owner (domain\user) of job AdventureWorks Daily Backup has server access (reason: Could not obtain information about Windows NT group/user 'domain\user', error code 0x5. [SQLSTATE 42000] (Error 15404) The statement has been terminated. [SQLSTATE 01000] (Error 3621)).

    Does anybody know what this means.. Can you please help?

  • October 14, 2008 at 12:32 am

    #884420

    You're using domain acct,and SQL Server will need to contact the domain controller to validate the acct. Check with the IT team if you have sufficient access and privileges .

    >> Try using SQL Logins / User (SA) which have sysadmin role and also access the database.

    >> Try to add the domain account to the local admin group of the local box where you have the SQL Server installed.

    "More Green More Oxygen !! Plant a tree today"

  • October 15, 2008 at 1:41 am

    #885059

    Try using local windows account for SQL Server agent and other services. If that solves the problem then later you may trouble shoot the domain account permission and connectivity issues.

    DBDigger Microsoft Data Platform Consultancy.

  • October 17, 2008 at 1:55 pm

    #886648

    Hi,

    I am sure security is the main cause in your case.Up to my knowledge you need to have Integration services to be installed to get ur maintanence plan works properly.

  • October 19, 2008 at 2:25 am

    #886849

    open the job properties and set the owner to sa

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply