Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2003
    Posts
    3

    Unanswered: DTS cube processing from a non sa account

    We are running a DTS package from a non-sa owned job and I am getting the following message:

    A problem occurred while attempting to logon as the Windows user 'SQLAgentCmdExec': The parameter is incorrect.

    When I set the Sql Agent proxy account to an windows administrator on the sql server it works fine.

    However when the Sql Agent proxy account is not administrator I get the above error.

    Please note that the Analysis Services is located on a different machine.



    Thanks

    Lior

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Grant admin privileges to the SQLAgent service account, which is required to carry on such tasks and to overcome this issue.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Jul 2003
    Posts
    3
    Originally posted by Satya
    Grant admin privileges to the SQLAgent service account, which is required to carry on such tasks and to overcome this issue.
    Do you mean that the sqlagent stratup account should be windows sys admin?

    Can I do it with less power priviliges?

    Thanks

    Lior

  4. #4
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    You can do it, but you may have issues again if any of the jobs have to deal with admin tasks.

    Its always better and recommended to keep SQL service accounts with Admin privileges on the box.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  5. #5
    Join Date
    Jul 2003
    Posts
    3
    Originally posted by Satya
    You can do it, but you may have issues again if any of the jobs have to deal with admin tasks.

    Its always better and recommended to keep SQL service accounts with Admin privileges on the box.
    Hi,

    Thanks again for your help.

    Do you know what permissions are required for sql server to run cube processing that resides on a different machine.

    Lior

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •