How can I persist user credentials?

Hi,
I'm using SSRS 2005 on SQL Server 2000. I have 8 reports for a particular
user. Each report has its own data source. The way our security is set up,
I have to use the following configuration in the data source property sheet
for each report: Data Source=ServerName;Integrated Security=SSPI;Initial
Catalog=databaseName. Credentials stored securely in the report server. Use
as Windows credentials when connecting to the data source. I don't want the
user to have to enter their windows user name and password for each of the 8
reports. Does anyone know of a way to enter the credentials for the first
report and have them persist for the rest of the reports?
Thanks,
Jeff
--
Thanks,
JeffOn May 17, 6:07 pm, Jeff Stroope
<JeffStro...@.discussions.microsoft.com> wrote:
> Hi,
> I'm using SSRS 2005 on SQL Server 2000. I have 8 reports for a particular
> user. Each report has its own data source. The way our security is set up,
> I have to use the following configuration in the data source property sheet
> for each report: Data Source=ServerName;Integrated Security=SSPI;Initial
> Catalog=databaseName. Credentials stored securely in the report server. Use
> as Windows credentials when connecting to the data source. I don't want the
> user to have to enter their windows user name and password for each of the 8
> reports. Does anyone know of a way to enter the credentials for the first
> report and have them persist for the rest of the reports?
> Thanks,
> Jeff
> --
> Thanks,
> Jeff
This article might be helpful:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_ref_soapapi_service_lz_3d7q.asp?frame=true
Also, you should look into the Reporting Services configuration files
(usually located at: C:\Program Files\Microsoft SQL Server\MSSQL.
2\Reporting Services\ReportServer): web.config and
rsreportserver.config. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Thanks Enrique, I'll give it a look.
--
Thanks,
Jeff
"EMartinez" wrote:
> On May 17, 6:07 pm, Jeff Stroope
> <JeffStro...@.discussions.microsoft.com> wrote:
> > Hi,
> >
> > I'm using SSRS 2005 on SQL Server 2000. I have 8 reports for a particular
> > user. Each report has its own data source. The way our security is set up,
> > I have to use the following configuration in the data source property sheet
> > for each report: Data Source=ServerName;Integrated Security=SSPI;Initial
> > Catalog=databaseName. Credentials stored securely in the report server. Use
> > as Windows credentials when connecting to the data source. I don't want the
> > user to have to enter their windows user name and password for each of the 8
> > reports. Does anyone know of a way to enter the credentials for the first
> > report and have them persist for the rest of the reports?
> >
> > Thanks,
> >
> > Jeff
> > --
> > Thanks,
> >
> > Jeff
> This article might be helpful:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_ref_soapapi_service_lz_3d7q.asp?frame=true
> Also, you should look into the Reporting Services configuration files
> (usually located at: C:\Program Files\Microsoft SQL Server\MSSQL.
> 2\Reporting Services\ReportServer): web.config and
> rsreportserver.config. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>