Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jolifox
Starting Member
1 Post |
 Posted - 2008-07-17 : 12:47:11
|
| 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 |
|
|
dexter.knudson
Constraint Violating Yak Guru
260 Posts |
Posted - 2008-07-17 : 21:30:53
|
| How did you go with this? Is the server setup for windows authentication? Try connecting to the analysis services DB from within Server Management Studio using windows authentication. If this doesn't work, maybe the server isn't configured for it. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-17 : 23:13:48
|
| You need check authentication settings in web service on your organisations report server. |
|
|
|
|
|
|
Analysis Services as data source for Reporting Ser