Reporting Services Data Source and Windows Integrated Security to

Hi,
I need to query SSAS Cube from Reporting Services with a Data Source which
use Windows Integrated Security, but I can't do this.
I've installed Reporting Services on a Win2k3 Server (machine A).
Reporting Services is configured to run with Network Service Identity.
The security is to be Windows Integrated, and so I've done.
Reporting Services uses a Windows Integrated Data Source to connect to SQL
Server Analys Services.
I've installed SQL Server 2005 on another Win2k3 (machine B).
The account used to run SQL Server 2005 and the Analysys Services is a
Domain Account.
Both servers are in the same Domain.
I use the windows integrated security to access the main page of Reporting
Services.
When I click on my report I receives an error.
The Reporting Services fails passing the correct credential to the Data
Source, which is configured to run as Windows Integrated Security.
With Windows Integrated security I am able to filter data on SSAS Cube, and
this is mandatory.
How I can force Reporting services to pass the Windows Integrated Credential?
Do I have to use Kerberos? If yes, How can I do this?
Thanks,
Pietro.Just go to cube and right click for properties and on the datsource select
the default radio button. It should work.
Amarnath
"Pietro" wrote:
> Hi,
> I need to query SSAS Cube from Reporting Services with a Data Source which
> use Windows Integrated Security, but I can't do this.
> I've installed Reporting Services on a Win2k3 Server (machine A).
> Reporting Services is configured to run with Network Service Identity.
> The security is to be Windows Integrated, and so I've done.
> Reporting Services uses a Windows Integrated Data Source to connect to SQL
> Server Analys Services.
> I've installed SQL Server 2005 on another Win2k3 (machine B).
> The account used to run SQL Server 2005 and the Analysys Services is a
> Domain Account.
> Both servers are in the same Domain.
> I use the windows integrated security to access the main page of Reporting
> Services.
> When I click on my report I receives an error.
> The Reporting Services fails passing the correct credential to the Data
> Source, which is configured to run as Windows Integrated Security.
> With Windows Integrated security I am able to filter data on SSAS Cube, and
> this is mandatory.
> How I can force Reporting services to pass the Windows Integrated Credential?
> Do I have to use Kerberos? If yes, How can I do this?
> Thanks,
> Pietro.
>
>|||Hi, Amarnath
Your suggestion doesn't work.
I've cheched the data source and cube connection on the Cube SSAS. Both are
checked as "default".
When the Reporting Services and SQL Cube are on the same server, then there
are NO errors.
When Reporting Services and the SSAS Cube are into different machines, then
the integrated authentication fails.
Pietro.
"Amarnath" wrote:
> Just go to cube and right click for properties and on the datsource select
> the default radio button. It should work.
> Amarnath
> "Pietro" wrote:
> > Hi,
> > I need to query SSAS Cube from Reporting Services with a Data Source which
> > use Windows Integrated Security, but I can't do this.
> >
> > I've installed Reporting Services on a Win2k3 Server (machine A).
> > Reporting Services is configured to run with Network Service Identity.
> > The security is to be Windows Integrated, and so I've done.
> >
> > Reporting Services uses a Windows Integrated Data Source to connect to SQL
> > Server Analys Services.
> >
> > I've installed SQL Server 2005 on another Win2k3 (machine B).
> > The account used to run SQL Server 2005 and the Analysys Services is a
> > Domain Account.
> >
> > Both servers are in the same Domain.
> >
> > I use the windows integrated security to access the main page of Reporting
> > Services.
> >
> > When I click on my report I receives an error.
> > The Reporting Services fails passing the correct credential to the Data
> > Source, which is configured to run as Windows Integrated Security.
> >
> > With Windows Integrated security I am able to filter data on SSAS Cube, and
> > this is mandatory.
> >
> > How I can force Reporting services to pass the Windows Integrated Credential?
> > Do I have to use Kerberos? If yes, How can I do this?
> >
> > Thanks,
> > Pietro.
> >
> >
> >
> >|||When you select the data source using datasource designer, have you tested
the connection and is it connecting ? try when the server is different and
"test the connection" and see whether it is connecting...
Amarnath
"Pietro" wrote:
> Hi, Amarnath
> Your suggestion doesn't work.
> I've cheched the data source and cube connection on the Cube SSAS. Both are
> checked as "default".
> When the Reporting Services and SQL Cube are on the same server, then there
> are NO errors.
> When Reporting Services and the SSAS Cube are into different machines, then
> the integrated authentication fails.
> Pietro.
>
> "Amarnath" wrote:
> > Just go to cube and right click for properties and on the datsource select
> > the default radio button. It should work.
> >
> > Amarnath
> >
> > "Pietro" wrote:
> >
> > > Hi,
> > > I need to query SSAS Cube from Reporting Services with a Data Source which
> > > use Windows Integrated Security, but I can't do this.
> > >
> > > I've installed Reporting Services on a Win2k3 Server (machine A).
> > > Reporting Services is configured to run with Network Service Identity.
> > > The security is to be Windows Integrated, and so I've done.
> > >
> > > Reporting Services uses a Windows Integrated Data Source to connect to SQL
> > > Server Analys Services.
> > >
> > > I've installed SQL Server 2005 on another Win2k3 (machine B).
> > > The account used to run SQL Server 2005 and the Analysys Services is a
> > > Domain Account.
> > >
> > > Both servers are in the same Domain.
> > >
> > > I use the windows integrated security to access the main page of Reporting
> > > Services.
> > >
> > > When I click on my report I receives an error.
> > > The Reporting Services fails passing the correct credential to the Data
> > > Source, which is configured to run as Windows Integrated Security.
> > >
> > > With Windows Integrated security I am able to filter data on SSAS Cube, and
> > > this is mandatory.
> > >
> > > How I can force Reporting services to pass the Windows Integrated Credential?
> > > Do I have to use Kerberos? If yes, How can I do this?
> > >
> > > Thanks,
> > > Pietro.
> > >
> > >
> > >
> > >