Problem running an Reporting Services Report that has an Analysis Services data source

Question

Problem running an Reporting Services Report that has an Analysis Services data source

jolifox-651452

Old Hand

Points: 300
More actions
July 17, 2008 at 10:52 am

#189709

Hi,
I have created a Reporting Services report which has an Analysis Services data source.
The data source is using Windows Authenticated Security.
The report works fine when I deploy it to my local Report Server, but when I deploy it to the organisations report server I get the following error:
An error has occurred during report processing.
Cannot create a connection to data source 'BIOLAP_DailyModels'.
Non-Windows user credentials were supplied for a non-http connection to Analysis Services. The Microsoft SQL Server Analysis Services data extension requires Windows Integrated Security unless connecting via http or https.
Any Ideas????
Thx

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

RGP SSCarpal Tunnel Points: 4381 More actions · Answer 1

jolifox (7/17/2008)
Hi,
I have created a Reporting Services report which has an Analysis Services data source.
The data source is using Windows Authenticated Security.
The report works fine when I deploy it to my local Report Server, but when I deploy it to the organisations report server I get the following error:
An error has occurred during report processing.
Cannot create a connection to data source 'BIOLAP_DailyModels'.
Non-Windows user credentials were supplied for a non-http connection to Analysis Services. The Microsoft SQL Server Analysis Services data extension requires Windows Integrated Security unless connecting via http or https.
Any Ideas????
Thx

Hi, It looks like the authentication provided doesnt match. Can you check with what authenticatin method you are connecting to the data source? from the organisations report server

Justin Stephens-249674 SSC Veteran Points: 234 More actions · Answer 2

Hey,

Did you ever find a solution? I have the same problem now.

Good Shooting.

Justin

sbae-936125 Valued Member Points: 69 More actions · Answer 3

Make sure that if you are using "credentials stored securely in the report server option" that you have the "use as windows credentials when connecting to the source" checked.

jolifox-651452 Old Hand Points: 300 More actions · Answer 4

Hi,

Thanks for this,

The problem with this is that the user has to enter the username and password each time they run the report.

Is there any other way around this???

Cheers,

James

denglishbi SSCrazy Eights Points: 8831 More actions · Answer 5

If you are using SSAS security and want to pass the user's credentials to a SSAS instance that is not on the same server as the Report Server you will need to have Kerberos setup so that you can pass the security token to the SSAS server. I am assuming this is your current situation and you are running into a cross server permission issue and since Kerberos is most likely not setup then the credentials being passed are anonymous and you should see this if you run a trace with Profiler against the SSAS server.

Refer to this forum posting and the link to Moshas's instructions for setting up Kerberos with SSAS - SSAS 2005 with Kerberos/Delegation

----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com

Justin Stephens-249674 SSC Veteran Points: 234 More actions · Answer 6

Hi,

Thanks for all the posts.

My problem is this ...

We have Reporting Services on an NLB Cluster (2 Servers) and Analysis Services on a Failover Cluster (2 Nodes). We have enabled Kerberos in the Failover Cluster Configuration and created SPNs for the Service Account running Reporting Services and IIS. Also, we have created SPNs for the Service Account running Analysis Services. Lastly, we have set the Service Accounts and Servers to be Trusted For Delegation.

Because we need to set security in Analysis Services, we need to insure that Windows Authentication is passed through from Reporting Services to Analysis Services. In the Data Source on the Reporting Services site, we checked "Connect using: Windows Integrated Security".

We are still seeing the message that "No credentials are available in the Security Package."

If we change the Data Source in Reporting Services to use Credentials stored on this Server for the Service Account running Reporting Services and check "Impersonate the authenicated user ...", we get another message that a Non-Windows user credentials were supplied ...".

If we change the Data Source in Reporting Services to use Credentials stored on this Server for the Service Account and check "use windows credentials when connecting to the Data Source", we can view the Report, but the user security is not applied. The users have access to the vault.

Has anyone setup Kerberos in this type of Environment? What is the Correct Configuration?

Thanks,

Justin

RM-219939 SSC Enthusiast Points: 117 More actions · Answer 7

Did you find the solution? I have the very same problem, any help will be very appreciated.

Best regards.

Rogelio

gopika.lasitha SSC Rookie Points: 45 More actions · Answer 8

Please refer the below link

http://gopika-lasitha.blogspot.com/2011/09/non-windows-user-credentials-were.html