Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Reporting Services: Read Data from SSAS and SQL Server in One Dataset Expand / Collapse
Author
Message
Posted Wednesday, September 17, 2008 12:44 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, December 2, 2011 12:11 AM
Points: 125, Visits: 77
Comments posted to this topic are about the item Reporting Services: Read Data from SSAS and SQL Server in One Dataset
Post #570765
Posted Wednesday, September 17, 2008 6:32 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, March 18, 2012 8:22 PM
Points: 1, Visits: 36
Great work, Martin!
Post #570942
Posted Wednesday, September 17, 2008 7:23 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, October 7, 2014 7:31 AM
Points: 553, Visits: 666
Thanks for providing some examples of things that didn't work and why, particularly the part about issues when you went from your local server to a production server. I wish I had a dollar for every time something worked great locally and then fell apart in production. I have spent countless hours trying to chase these down only to find out that I just needed to check the right box. Your explanation will save a lot of people like me many hours of research.

I also liked how you worked in some excellent points with regard to the proper way to use a table variable versus a temp table versus a "real" table.

Great article.


"Beliefs" get in the way of learning.
Post #570982
Posted Sunday, September 21, 2008 11:20 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, October 16, 2014 4:46 AM
Points: 5,406, Visits: 1,400
Great article....


Post #573248
Posted Monday, October 6, 2008 1:51 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, January 22, 2014 9:48 AM
Points: 202, Visits: 3,531
After more research I am editing my post

This is actually looking to be more like a double hop authentication issue than anykind of 64bit incompatiability.

This example is great one and solves several challenges that I am facing.

I am having one technical problem when implementing the Linked Server. It appears that there is a problem with the 64-bit version of the Microsoft OLE DB Provider for Analysis Services 9.0 provider when you attempt to query the linked server from a 32 bit instance like a client machine. I can successfully run queries from a 64bit machine but a 32 bit results in an error.


Has anyone experienced this similar behavior and hopefully found a solution?
Post #581345
Posted Friday, October 17, 2008 1:25 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, December 2, 2011 12:11 AM
Points: 125, Visits: 77
Hi Ben,

how did you configure the Security tab of the Linked Server Properties?

I attached a screen shot where I erased the login names.
In the red area you can assign a remote user (that is the user who logs on to Analysis Services) to a local user (the login used for the SQL Server database).

In the blue area you can use a standard login for SSAS. I would only use this for testing purposes because that would mean that everybody, who can connect to SQL Server database, can connect to SSAS as well.

In both cases you have to specify the Windows account (as Domain\Username), which should log on to SSAS, in the remote user/login-field.

For your problem, I would try the "blue" thing. If you can connect to SSAS, you know your problem is security-related.

I hope this was of any help.

Take care,
Martin


  Post Attachments 
linked_Cube.JPG (16 views, 51.79 KB)
Post #587943
Posted Wednesday, October 22, 2008 7:39 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, January 22, 2014 9:48 AM
Points: 202, Visits: 3,531
I had it configured with the radio button set to "Be made using the login's current security context" but after setting it to "Be made using this security context" the connection succeeded. After digging into the issue it looks like I have underlying configuration problems with Kerberos and SPN's that I need to work on.

Thanks
Post #589805
Posted Thursday, June 11, 2009 5:07 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, October 7, 2014 1:44 AM
Points: 995, Visits: 2,574
Hi Martin,

As i posted here Problem with linked server,
I have problem with the linked server, it work fine but from time to time I get this error
"Cannot create an instance of OLE DB provider "MSOLAP" for linked server "SALES_CUBE". (Microsoft SQL Server, Error: 7302)"
restarting the SQL fix the problem' but this times i have to restart SQL on a daily base.

Any advice?
Kupy
Post #732914
Posted Friday, July 17, 2009 12:11 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, January 20, 2011 12:35 AM
Points: 2, Visits: 20
Hi all,

I am also facing similar issue when i move the linked server script from Developement enciroment to uat it creates linked server . When i tyrto test the connection it says ""Cannot create an instance of OLE DB provider "MSOLAP" for linked server Cube".Please helpme with the same is it a security issue
Post #754633
Posted Tuesday, April 26, 2011 9:33 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, June 20, 2011 9:06 AM
Points: 2, Visits: 12
This article is excellent.

Thank you so much,

Ronaldlee
Post #1098731
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse