Post reply

server access cannot be determined

  • September 8, 2009 at 3:10 pm

    #156188

    Hi,

    A job assigned to run an SSIS package fails returning the following error message:

    Unable to determine if the owner (yourGroup\yourUserID) of job yourJobName has server access (reason: Could not obtain information about Windows NT

    group/user '\yourUserName', error code 0x5. [SQLSTATE 42000] (Error 15404)).

    Any help is appreciated,

    Mike

  • September 8, 2009 at 3:23 pm

    #1050817

    make sure you have proxy account to run this job. if not then the account under which agent is running should have admin access on sql. ssis are seperate services so you have to make sure to grant proper priviliges in DCOM for DTS

    :crazy: :alien:

    Umar Iqbal

  • September 8, 2009 at 3:31 pm

    #1050822

    Hi Mike,

    The SQL Server agent must have sufficient privileges to access the SSIS package. Make sure that the service under which the SQL Server Agent runs has sufficient privileges to access the SSIS package. Or you can also create a proxy account to overcome this problem.

    Thank You,

    Best Regards,

    SQLBuddy

Viewing 3 posts - 1 through 2 (of 2 total)

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