RSExecutionLog_Update.dts fails for named SQL Instance

Hi:
I am running SRS on a named instance of SQL. When I attempt to run this DTS
package, it fails on the five update steps with the error message "Cannot
open database requested in login 'ReportServer'. Login fails."
How can I point it to the non-default instance of SQL.
Thanks in advance.
Bruce.Have you tried changing the server name in the RSExecutionLog_Update.ini
file? I have never used the package with a non-default instance of SQL
server, but I assume it should work when you make the appropriate edits in
the above ini file.
Charles Kangai, MCT, MCDBA
"bwschiek@.hotmail.com" wrote:
> Hi:
> I am running SRS on a named instance of SQL. When I attempt to run this DTS
> package, it fails on the five update steps with the error message "Cannot
> open database requested in login 'ReportServer'. Login fails."
> How can I point it to the non-default instance of SQL.
> Thanks in advance.
> Bruce.|||Hi Charles:
It worked! I changed the server setting for both the source and destination
from (local) to ServerName\SQLInstanceName and the DTS package executed as
intented!
Thanks for the quick and accurate reply!
Bruce.
"Charles Kangai" wrote:
> Have you tried changing the server name in the RSExecutionLog_Update.ini
> file? I have never used the package with a non-default instance of SQL
> server, but I assume it should work when you make the appropriate edits in
> the above ini file.
> Charles Kangai, MCT, MCDBA
> "bwschiek@.hotmail.com" wrote:
> > Hi:
> >
> > I am running SRS on a named instance of SQL. When I attempt to run this DTS
> > package, it fails on the five update steps with the error message "Cannot
> > open database requested in login 'ReportServer'. Login fails."
> >
> > How can I point it to the non-default instance of SQL.
> >
> > Thanks in advance.
> >
> > Bruce.

RS Integration with SharePoint 3.0 - Query with userid parameter

When integrating SQL Reporting Services 2005 with Sharepoint Services 3.0, and you have a SRS report that runs over a view with the UserID as a parameter (to filter the records the user has access to), will the SharePoint ReportViewer passover the UserID to RS and RS to SQL?

Sharepoint security with Reporting Services stops at Item level or does it impersontate down to SQL? Should authenticating be Integrated or SQL ? Should the userid in SQL be exact match with Sharepoint? Or are they mapped somewhere?

Thank You!!

Hi,

actually these are two different questions:

it depends how you implemented the authentication. If reports are called by Sharepoint, it is possible to use the information of the Windows Identity to authenticate against the SQL Server. As you are using a UserId approach and not the actual identity at the SQL Server level you could also use SQL Server authentication to run the query of the report. So the following options could be available:

[Report (UserId) -- IIS (Windows Integrated Authentication)] -- SQL Server (SQL Server Authentication with static credentials)

[Report (UserId) -- IIS (Windows Integrated Authentication)] -- SQL Server (Windows Authentication)

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de