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 Execution Log and SQL 2005

Hello All,
SQL 2000 Reporting Services came with a DTS package that could be configured
to collect data daily on Report Execution. The results were then stored in a
RSExecutionLog database. Is this functionality still supported in 2005
Reporting Services?Well, for RS 2005 it is not a DTS package, it is a Integration Services
package. I was trying to get this working and I did not have Integration
Services installed (which requires reinstalling all service packs). So I
delayed until I had some time to install it.
Bruce Loehle-Conger
"EFrayer@.community.nospam"
<EFrayercommunitynospam@.discussions.microsoft.com> wrote in message
news:9F060287-4EAF-4FBD-9DA8-A1192674999E@.microsoft.com...
> Hello All,
> SQL 2000 Reporting Services came with a DTS package that could be
> configured
> to collect data daily on Report Execution. The results were then stored
> in a
> RSExecutionLog database. Is this functionality still supported in 2005
> Reporting Services?|||Can I get a little more information on how to do this? Where can I find this
Integration Services package that you are taking about?
"Bruce L-C [MVP]" wrote:
> Well, for RS 2005 it is not a DTS package, it is a Integration Services
> package. I was trying to get this working and I did not have Integration
> Services installed (which requires reinstalling all service packs). So I
> delayed until I had some time to install it.
> Bruce Loehle-Conger
> "EFrayer@.community.nospam"
> <EFrayercommunitynospam@.discussions.microsoft.com> wrote in message
> news:9F060287-4EAF-4FBD-9DA8-A1192674999E@.microsoft.com...
> > Hello All,
> > SQL 2000 Reporting Services came with a DTS package that could be
> > configured
> > to collect data daily on Report Execution. The results were then stored
> > in a
> > RSExecutionLog database. Is this functionality still supported in 2005
> > Reporting Services?
>
>