July 17, 2008 at 10:52 am
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
July 20, 2008 at 2:00 am
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
October 9, 2008 at 5:26 pm
Hey,
Did you ever find a solution? I have the same problem now.
Good Shooting.
Justin
November 10, 2008 at 1:46 pm
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.
November 11, 2008 at 2:16 am
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
November 11, 2008 at 6:46 am
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
November 13, 2008 at 4:49 pm
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
February 19, 2009 at 9:17 pm
Did you find the solution? I have the very same problem, any help will be very appreciated.
Best regards.
Rogelio
June 12, 2015 at 2:53 am
Please refer the below link
http://gopika-lasitha.blogspot.com/2011/09/non-windows-user-credentials-were.html
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply