Post reply

permissions on a DTS "Analysis Services Processing Task"

  • February 16, 2006 at 5:22 am

    #170694

    Hi, I've a problem with a DTS "Analysis Services Processing Task".

    I've a Server "A" with SQLSERVER 2000 sp3a and Analysis Services only connectivity, and an SQLServer Agent Proxy Account "SQLOper" with "users" privilege.

    I've a Server "B" with Analysis Services and a user "SQLOper" with "OLAP Administrators" privilege.

    I've created on Server "A" a job that execute a DTS "Analysis Services Processing Task" on FoodMart database on Server "B".

    The job run under Proxy Account privilege but It fails with this error message:

    " Error:

    Cannot open database ''.  It may not be a database that your application recognizes, or the file may be corrupt.

       Error source:  DSO

       Help file: 

       Help context:  1000440"

    The database name don't appear ( Cannot open database '' ), which is the cause?

    Which are the privileges necessary to my Proxy Account?

    If Proxy Account have "Administrators" privilege the job works fine, but for security reason I don't want to assign this privilege.

    Any help will be appreciated.

    Thanks

  • February 18, 2006 at 11:35 pm

    #621903

    Hello,

    The proxy user account needs to be associated with the group of "OLAP Administrators" on the target server. (This is less priviliged than Administrator group).

    Regards,

    Isaac

  • February 23, 2006 at 7:37 am

    #622926

    The proxy user account is already assigned to "OALP Administrator" role.

    Thanks

  • March 3, 2006 at 2:48 am

    #624551

    anyone to help me ????

     

    Thanks

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

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