SQL Server Performance

Log in or Sign up

Reports using cubes

Discussion in 'SQL Server 2005 Analysis Services' started by gaurpoonam, Sep 13, 2007.

gaurpoonam New Member

Hi,
I have created a report using cube and has deployed it on different server. In reports Manager when I am trying to view the report it shows' Cannot create a connection to data source'. I have supplied the servername and cubename in the connection properties and can view it from business intelligence studio.
Can anybody please help.
Thanks,

gaurpoonam, Sep 13, 2007

#2
Cristiano Leite New Member

You deployed your report in another server than SSAS is installed. Probably the user is trying to view report don't have permissions to you cube.

Cristiano Leite, Sep 13, 2007

#3
satya Moderator

You might need to add on the Reporting Services server this remote server as a linked server. Also if you're running Kerberos, verify your delegation: http://www.microsoft.com/technet/prodtechnol/windowsserver2003/technologies/security/tkerbdel.mspx
Also http://msdn2.microsoft.com/en-us/library/ms156468.aspx fyi on the fixing the error.

satya, Sep 13, 2007

#4

(You must log in or sign up to reply here.)

Share This Page