Re: problem with a DTS "Analysis Services Processing Task"
- From: Darren Gosbell <jam@xxxxxxxxxxxxxxxxx>
- Date: Sat, 18 Feb 2006 16:27:21 +1100
From server "A", are you able to connect to and process the database onServer '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@xxxxxxxxxxxxx>,
andreafavero@xxxxxxxxxxxxxxxxxxxxxxxxx says...
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
- Follow-Ups:
- Re: problem with a DTS "Analysis Services Processing Task"
- From: andrea favero
- Re: problem with a DTS "Analysis Services Processing Task"
- Prev by Date: Re: Connect from SQL2005 Mgt Studio to SQL 2000 Analysis server
- Next by Date: Re: Best way to process an AS2005 cube from Excel
- Previous by thread: Re: Standard vs. Enterprise edition and Analysis Services
- Next by thread: Re: problem with a DTS "Analysis Services Processing Task"
- Index(es):
Relevant Pages
|
