locked
Unable to determine if the owner (x.x.x.x\Administrator) of job x.y has server access. RRS feed

  • Question

  • Hello,

    Please help me with following case,

    SQL Server 2008 Web Edition

    SQL Server Service running as -> Local System
    SQL Server Agent Service running as -> Local System

    Login as Administrator on SQL Server with Windows AUTH mode.

    Create maintenance plan called - Backup.

    Just wanted to take one database backup so select Backup Database Task.

    - User predefine -> Local Server Connection
    - Select database which I want to backup
    - Select default backup file path.

    Save plan.

    Get T-SQL and try to run under query analyzer, all working fine.. No error.

    Now I am trying to execute Maintenance Plan and I am getting following error,

    Unable to determine if the owner (x-x-x-x\Administrator) of job Backup.DB Backup has server access (reason: Could not obtain information about Windows NT group/user 'x-x-x-x\Administrator', error code 0x534. [SQLSTATE 42000] (Error 15404)).

    Please let me know what could be the reason?

    Thanks,
    BV

    Friday, March 11, 2011 3:53 PM

Answers

  • Hi,

    I would recommned you drop your lcoal administrator account in SQL Server (<server_instance> ->  Security ->  Logins) and recreate/add it to see if that works.

    Please let me know if that helps.


    Best Regards,
    Chunsong Feng

    Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    Tuesday, March 15, 2011 9:37 AM
  • Hi,

    Please refer to the Pradeep Adiga's Post that will help you to fix the issue. He has described the same type of issue in his post, as well with work arounds by updating the entry in msdb..sysdtspackages90


    Thanks & Regards, Pramilarani.R
    Tuesday, March 15, 2011 9:50 AM

All replies

  • Who is the owner of the job  ? Are you employing any proxy account for this SSIS maint plan execution ? Does that windows account have a login in SQL server and what level of access is given ? 

    Can you run this command and post the output here xp_logininfo 'xx\administrator'


    Thanks, Leks
    Friday, March 11, 2011 8:02 PM
  • I login as Windows Administrator in Windows 2008 server.

    I created plan under Windows Auth under same Admin a/c. So owner of the job is also same a/c.

     

    No proxy account. That windows a/c has admin rights and it can login to sql server.

    If I try to run xp_logininfo then I get,

     

    Msg 15404, Level 16, State 11, Procedure xp_logininfo, Line 62

    Could not obtain information about Windows NT group/user 'x-x-x-x\Administrator', error code 0x534.


    Please help me.

    Thanks,
    BV

    Friday, March 11, 2011 9:27 PM
  • It seems like there is some issue in your account that you are trying to use , can you check the AD using dsa.msc to check if that account exists in your domain ? What collation is used for SQL server ? I have seen cases where one of SQL collation settings needs the domain logins to be entered as the same cases in SQL server (upper and lower) as it is registered in the domain .

    Thanks, Leks
    Friday, March 11, 2011 9:55 PM
  • This server is not part of AD, it's a standalone web server.

    Server Collation is - SQL_Latin1_General_CP1_CI_AS

    Please suggest...

     

    Friday, March 11, 2011 10:10 PM
  • I just checked both server collation and database collation is same.

     

    Friday, March 11, 2011 10:18 PM
  • Hi,

    I would recommned you drop your lcoal administrator account in SQL Server (<server_instance> ->  Security ->  Logins) and recreate/add it to see if that works.

    Please let me know if that helps.


    Best Regards,
    Chunsong Feng

    Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    Tuesday, March 15, 2011 9:37 AM
  • Hi,

    Please refer to the Pradeep Adiga's Post that will help you to fix the issue. He has described the same type of issue in his post, as well with work arounds by updating the entry in msdb..sysdtspackages90


    Thanks & Regards, Pramilarani.R
    Tuesday, March 15, 2011 9:50 AM
  • Alex I am having the same issue and I've tried running the query on Pradeep's page but I receive the error below

    Msg 208, Level 16, State 1, Line 1
    Invalid object name 'msdb..sysdtspackages90'.


    Thursday, September 4, 2014 1:51 AM
  • Hi,

    Change the owner of the sqlagent Job for the maintenance plan to sa and Keep it.

    Job is running successful then. sqlserver got problems if you try to work with maintenance plans with some sort of low priviledge usage...

    mathias rühn

    • Proposed as answer by Mathias Rühn Wednesday, October 21, 2015 7:46 AM
    Wednesday, October 21, 2015 7:46 AM