Re: problem with a DTS "Analysis Services Processing Task"
- From: andrea favero <andreafavero@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 3 Mar 2006 07:51:29 -0800
"Darren Gosbell" wrote:
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.
Yes, I use integrated security and user account has permission to access the
data source.
Thanks
--.
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"
- Prev by Date: Deployment of Analysis Services 2005 database
- Next by Date: Re: How do I get the browser's MDX query in AS 2005??
- Previous by thread: Deployment of Analysis Services 2005 database
- Next by thread: Re: How to create Pivot table(Drill in/out) in MS SQL Reporting
- Index(es):
Relevant Pages
|
