November 17, 2005 at 1:19 am
Has anyone had any success with setting up a linked server or MSOLAP oledb connection to SQL2005 Analysis Services.
If I run this from SQL I get the following error:
select * from openquery(wrypgpvmw06AS, '
SELECT
[Measures].[Sales] ON 0 FROM [Sales]
WHERE
([Date].[Year Periods].[Year].&[2005].&[2005-P02],
[Products].[ProductMPGHierarchy].[Product Origin Group].&[CV]
)')
------------------------------->
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "MSOLAP" for linked server "wrypgpvmw06AS" reported an error. Access denied.
Msg 7350, Level 16, State 2, Line 1
Cannot get the column information from OLE DB provider "MSOLAP" for linked server "wrypgpvmw06AS".
I am running on the server itself as an administrator, and this is both the SQL server and the Analysis Services server, using the RTM version of 2005.
November 18, 2005 at 11:30 am
What options do you have set for Security?
Be Made Without Using a Security Context is the default, so if you did not change it, this may be the cause of your issue.
November 28, 2005 at 6:59 am
Thats a good point. I should have mentioned I used "Use the security context of the current user"
Has anyone actually got this to work?
November 29, 2005 at 1:09 am
I tried tracing as cliffb suggested.
Several steps were executed on analysis services, including serialising the output. The trace recorded error=1 on the final step and also success=1, but no meaningful error messages that I could see.
I did notice that if I log on to the server interactively *as the service account*, the everthing works OK. This is not an acceptable solution, though.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply