Re: problem with a DTS "Analysis Services Processing Task"
- From: Darren Gosbell <jam@xxxxxxxxxxxxxxxxx>
- Date: Fri, 24 Feb 2006 21:10:48 +1100
YES, I've processed "FoodMart" form server "A" with Analysis Manager. OK!!
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@xxxxxxxxxxxxx>,
andreafavero@xxxxxxxxxxxxxxxxxxxxxxxxx says...
"Darren Gosbell" wrote:
From server "A", are you able to connect to and process the database on
Server 'B" using Analysis Manager?
YES, I've processed "FoodMart" form server "A" with Analysis Manager. OK!!
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.
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.
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)
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
--
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"
.
- References:
- Re: problem with a DTS "Analysis Services Processing Task"
- From: Darren Gosbell
- 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: SSAS 2005 and Proclarity Professional 6.0
- Next by Date: Re: Sripting the cube
- Previous by thread: Re: problem with a DTS "Analysis Services Processing Task"
- Next by thread: Re: Best way to process an AS2005 cube from Excel
- Index(es):
Relevant Pages
|
