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

From server "A", are you able to connect to and process the database on
Server 'B" using Analysis Manager?

Where is your Olap Repository located?

If it is in the default MS Access based repository, your SQLOper user
should be able to access the hidden \\ServerB\MSOlapRepository$ share.
Try typing the name of this share in to the address bar in Windows
Explorer while logged onto Server "A" as SQLOper and you should get a
list of files.

If you repository is in a SQL database (especially if that database is
not stored on Server "B"), check that the SQLOper user has access to
this database. If the SQL Repository is on the same server as the AS
database the permissions will map through the local Olap Administrators
group. If a SQL base repository is stored on a different server you will
need to map the permissions manually. (I usually set up a domain group
for OLAP Admins)

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <E0B5EBB4-0DD9-43B4-8667-DA5E6EDDE5A8 (AT) microsoft (DOT) com>,
andreafavero (AT) discussions (DOT) microsoft.com says...

"Darren Gosbell" wrote:

YES, I've processed "FoodMart" form server "A" with Analysis Manager. OK!!

Yes, my repository is located in the default MS Access based repository and
SQLOper have access to hidden \\ServerB\MSOlapRepository$
SQLOper users on server A and B have "OLAP Administrators" role and same
password.

User SQLOper have dbo privilege in ALL databases.
IMHO, my job don't recognize database name and write "Cannot open databse '
' "
Where my job read database name to connect OLAP?
Thanks

I originally suspected you may have had issues connecting with the
repository from a remote machine, but if you can process a database on
Server A from Server B, then this is not the issue.

The next most likely issue is with the data source connection for the
database that you are trying to process.

Are you using a fixed username and password or integrated security? If
you are using integrated security you will need to check that the
MsSQLServerOlapService is running under a user account which has
permission to access the data source.

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <FE557884-5148-400D-A9CD-FD838B969996 (AT) microsoft (DOT) com>,
andreafavero (AT) discussions (DOT) microsoft.com says...

"Darren Gosbell" wrote:

Yes, I use integrated security and user account has permission to access the
data source.
Thanks