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.CreateReport() with overwrite set to true fails to update report description

When calling the RS SOAP API's CreateReport method, it doesn't seem like the report description is updated, unless I first delete the report and then recreate it.

Here's what my call looks like -
Warning[] warnings = rs.CreateReport(reportName, "/" + folder, true, buffer, null);

Is this a known issue?

Try

Dim descprop As New [Property]
desc.Name = "Description"
desc.Value = "Now is the time for all good men to come to the aid of their country."

rs.CreateReport(reportName, "/" + folder, true, buffer, desc);

Note, this is Visual Basic, you will need to convert it to your language C#

Ham

|||

Hello Arjun B,

I'm having the same problem as you described in your post.

Were you able to find a solution? If so, what were you able to do?

Thanks!

|||lmttag - try hammer's suggestion. worked for me!|||

Thanks for the reply. I tried the suggestion. However, it still didn't work.

Here's the situation... We have a report that has been deployed to production a few weeks ago. Since then the report has changed slightly; two parameters have changed--one parameter went from not being marked internal to being marked internal and the other parameter's default value changed (just a simple string change).

Now we want to programmatically deploy the updated report to production and overwrite the existing report. However, when we try this, the parameters, as shown through Report Manger, have not changed. They're the same as the original deployment. And, there is no error/exception thrown that might be causing the problem.

Here's the code snippet:

System.Byte[] definition = null;
ReportingService2005.Warning[] warnings = null;
ReportingService2005.Property property = new ReportingService2005.Property();
property.Name = "Description";
property.Value = "Updated Report Description";
ReportingService2005.Property[] properties = new ReportingService2005.Property[1];
properties[0] = property;

string name = (string)dr["Name"]; // Variable that holds the name
string file = (string)dr["FullName"]; // Variable that holds the file

System.IO.FileStream stream = System.IO.File.OpenRead(file);
definition = new System.Byte[stream.Length];
stream.Read(definition, 0, (int)stream.Length);
stream.Close();

//warnings = rs.CreateReport(name, parent, true, definition, null);
warnings = rs.CreateReport(name, parent, true, definition, properties);

Any help is greatly appreciated. Thanks!

|||

Sorry for so many post, but does it have to be the Description property? We have descriptions built into the reports, and, if we change the description property in code to get the CreateReport() method to work, then we'll lose the correct description for the report. And, we would rather not hard-code descriptions in our application that is trying to overwrite the report.

Thanks again.

rs.CreateReport() with overwrite set to true fails to update report description

When calling the RS SOAP API's CreateReport method, it doesn't seem like the report description is updated, unless I first delete the report and then recreate it.

Here's what my call looks like -
Warning[] warnings = rs.CreateReport(reportName, "/" + folder, true, buffer, null);

Is this a known issue?

Try

Dim descprop As New [Property]
desc.Name = "Description"
desc.Value = "Now is the time for all good men to come to the aid of their country."

rs.CreateReport(reportName, "/" + folder, true, buffer, desc);

Note, this is Visual Basic, you will need to convert it to your language C#

Ham

|||

Hello Arjun B,

I'm having the same problem as you described in your post.

Were you able to find a solution? If so, what were you able to do?

Thanks!

|||lmttag - try hammer's suggestion. worked for me!|||

Thanks for the reply. I tried the suggestion. However, it still didn't work.

Here's the situation... We have a report that has been deployed to production a few weeks ago. Since then the report has changed slightly; two parameters have changed--one parameter went from not being marked internal to being marked internal and the other parameter's default value changed (just a simple string change).

Now we want to programmatically deploy the updated report to production and overwrite the existing report. However, when we try this, the parameters, as shown through Report Manger, have not changed. They're the same as the original deployment. And, there is no error/exception thrown that might be causing the problem.

Here's the code snippet:

System.Byte[] definition = null;
ReportingService2005.Warning[] warnings = null;
ReportingService2005.Property property = new ReportingService2005.Property();
property.Name = "Description";
property.Value = "Updated Report Description";
ReportingService2005.Property[] properties = new ReportingService2005.Property[1];
properties[0] = property;

string name = (string)dr["Name"]; // Variable that holds the name
string file = (string)dr["FullName"]; // Variable that holds the file

System.IO.FileStream stream = System.IO.File.OpenRead(file);
definition = new System.Byte[stream.Length];
stream.Read(definition, 0, (int)stream.Length);
stream.Close();

//warnings = rs.CreateReport(name, parent, true, definition, null);
warnings = rs.CreateReport(name, parent, true, definition, properties);

Any help is greatly appreciated. Thanks!

|||

Sorry for so many post, but does it have to be the Description property? We have descriptions built into the reports, and, if we change the description property in code to get the CreateReport() method to work, then we'll lose the correct description for the report. And, we would rather not hard-code descriptions in our application that is trying to overwrite the report.

Thanks again.

RS service pack 2 installation failed

Hi all,
I tried to install Reporting services service pack 2 on our production
server but it failed before doing any update.
environnement is windows 2000 & framework dotnet 1.1 service pack 1
the same package was successfull on the developpement server - supposed to
be the same environnement.
The logfile shows an error 1635 and it seem to be linked to a file
sp1patch.msp
I could not find anything usefull on the net
Thanks in advance for any help
because we are using in our report one of the feature that cannot work
without the service pack 2.
herefater the log trace :
-----
=== Verbose logging started: 10/28/2005 19:05:40 Build type: SHIP UNICODE
3.01.4000.2435 Calling process:
e:\6704fbb7257fc7f7594ebb9e1cf255b8\sp2setup.exe === MSI (c) (94:58) [19:05:40:481]: Resetting cached policy values
MSI (c) (94:58) [19:05:40:481]: Machine policy value 'Debug' is 0
MSI (c) (94:58) [19:05:40:481]: ******* RunEngine:
******* Product: {33FE9EED-1976-4A51-A7AF-332D9BBB9400}
******* Action:
******* CommandLine: **********
MSI (c) (94:58) [19:05:40:481]: Client-side and UI is none or basic: Running
entire install on the server.
MSI (c) (94:58) [19:05:40:481]: Grabbed execution mutex.
MSI (c) (94:58) [19:05:40:590]: Cloaking enabled.
MSI (c) (94:58) [19:05:40:590]: Attempting to enable all disabled priveleges
before calling Install on Server
MSI (c) (94:58) [19:05:40:621]: Incrementing counter to disable shutdown.
Counter after increment: 0
MSI (s) (A8:0C) [19:05:40:668]: Grabbed execution mutex.
MSI (s) (A8:E0) [19:05:40:668]: Resetting cached policy values
MSI (s) (A8:E0) [19:05:40:668]: Machine policy value 'Debug' is 0
MSI (s) (A8:E0) [19:05:40:668]: ******* RunEngine:
******* Product: {33FE9EED-1976-4A51-A7AF-332D9BBB9400}
******* Action:
******* CommandLine: **********
MSI (s) (A8:E0) [19:05:40:668]: Machine policy value 'DisableUserInstalls'
is 0
MSI (s) (A8:E0) [19:05:40:684]: Warning: Local cached package
'C:\W2TP\Installer\ba2813.msi' is missing.
MSI (s) (A8:E0) [19:05:40:684]: User policy value 'SearchOrder' is 'nmu'
MSI (s) (A8:E0) [19:05:40:684]: User policy value 'DisableMedia' is 0
MSI (s) (A8:E0) [19:05:40:684]: Machine policy value 'AllowLockdownMedia' is 0
MSI (s) (A8:E0) [19:05:40:684]: SOURCEMGMT: Media enabled only if package is
safe.
MSI (s) (A8:E0) [19:05:40:684]: SOURCEMGMT: Looking for sourcelist for
product {33FE9EED-1976-4A51-A7AF-332D9BBB9400}
MSI (s) (A8:E0) [19:05:40:684]: SOURCEMGMT: Adding
{33FE9EED-1976-4A51-A7AF-332D9BBB9400}; to potential sourcelist list
(pcode;disk;relpath).
MSI (s) (A8:E0) [19:05:40:684]: SOURCEMGMT: Now checking product
{33FE9EED-1976-4A51-A7AF-332D9BBB9400}
MSI (s) (A8:E0) [19:05:40:684]: SOURCEMGMT: Media is enabled for product.
MSI (s) (A8:E0) [19:05:40:684]: SOURCEMGMT: Attempting to use LastUsedSource
from source list.
MSI (s) (A8:E0) [19:05:40:684]: SOURCEMGMT: Trying source
D:\Reporting_Services_Install\REPORTING_SERVICES-ENT\Setup\.
MSI (s) (A8:E0) [19:05:40:856]: Entering
CMsiConfigurationManager::SetLastUsedSource.
MSI (s) (A8:E0) [19:05:40:856]: Specifed source is already in a list.
MSI (s) (A8:E0) [19:05:40:856]: User policy value 'SearchOrder' is 'nmu'
MSI (s) (A8:E0) [19:05:40:856]: Machine policy value 'DisableBrowse' is 0
MSI (s) (A8:E0) [19:05:40:856]: Machine policy value 'AllowLockdownBrowse'
is 0
MSI (s) (A8:E0) [19:05:40:856]: Adding new sources is allowed.
MSI (s) (A8:E0) [19:05:40:856]: Set LastUsedSource to:
D:\Reporting_Services_Install\REPORTING_SERVICES-ENT\Setup\.
MSI (s) (A8:E0) [19:05:40:856]: Set LastUsedType to: n.
MSI (s) (A8:E0) [19:05:40:856]: Set LastUsedIndex to: 1.
MSI (s) (A8:E0) [19:05:40:871]: SOURCEMGMT: Resolved source to:
'D:\Reporting_Services_Install\REPORTING_SERVICES-ENT\Setup\'
MSI (s) (A8:E0) [19:05:40:918]: File will have security applied from OpCode.
MSI (s) (A8:E0) [19:05:41:215]: End dialog not enabled
MSI (s) (A8:E0) [19:05:41:215]: Original package ==>
D:\Reporting_Services_Install\REPORTING_SERVICES-ENT\Setup\RSRUN.MSI
MSI (s) (A8:E0) [19:05:41:215]: Package we're running from ==>
C:\W2TP\Installer\cbc12.msi
MSI (s) (A8:E0) [19:05:41:418]: APPCOMPAT: looking for appcompat database
entry with ProductCode '{33FE9EED-1976-4A51-A7AF-332D9BBB9400}'.
MSI (s) (A8:E0) [19:05:41:418]: APPCOMPAT: no matching ProductCode found in
database.
MSI (s) (A8:E0) [19:05:41:418]: MSCOREE not loaded loading copy from system32
MSI (s) (A8:E0) [19:05:41:512]: Opening existing patch
'C:\W2TP\Installer\ba290c.msp'.
MSI (s) (A8:E0) [19:05:41:512]: Note: 1: 2203 2:
C:\W2TP\Installer\ba290c.msp 3: -2147287038
MSI (s) (A8:E0) [19:05:41:512]: Couldn't find local patch
'C:\W2TP\Installer\ba290c.msp'. Looking for it at its source.
MSI (s) (A8:E0) [19:05:41:512]: Resolving Patch source.
MSI (s) (A8:E0) [19:05:41:512]: User policy value 'SearchOrder' is 'nmu'
MSI (s) (A8:E0) [19:05:41:512]: SOURCEMGMT: Media enabled only if package is
safe.
MSI (s) (A8:E0) [19:05:41:512]: SOURCEMGMT: Looking for sourcelist for
product {813A147C-2328-4439-9D40-1486308CB952}
MSI (s) (A8:E0) [19:05:41:512]: SOURCEMGMT: Adding
{813A147C-2328-4439-9D40-1486308CB952}; to potential sourcelist list
(pcode;disk;relpath).
MSI (s) (A8:E0) [19:05:41:512]: SOURCEMGMT: Now checking product
{813A147C-2328-4439-9D40-1486308CB952}
MSI (s) (A8:E0) [19:05:41:512]: SOURCEMGMT: Media is enabled for product.
MSI (s) (A8:E0) [19:05:41:512]: SOURCEMGMT: Attempting to use LastUsedSource
from source list.
MSI (s) (A8:E0) [19:05:41:512]: SOURCEMGMT: Processing net source list.
MSI (s) (A8:E0) [19:05:41:527]: SOURCEMGMT: Trying source
e:\3d0526d9dd77e601344dcc338f4f\.
MSI (s) (A8:E0) [19:05:41:527]: Note: 1: 2203 2:
e:\3d0526d9dd77e601344dcc338f4f\sp1patch.msp 3: -2147287037
MSI (s) (A8:E0) [19:05:41:527]: SOURCEMGMT: Source is invalid due to
missing/inaccessible package.
MSI (s) (A8:E0) [19:05:41:527]: Note: 1: 1706 2: -2147483647 3: sp1patch.msp
MSI (s) (A8:E0) [19:05:41:527]: SOURCEMGMT: Processing media source list.
MSI (s) (A8:E0) [19:05:42:652]: SOURCEMGMT: Resolved source to: 'sp1patch.msp'
MSI (s) (A8:E0) [19:06:49:199]: Note: 1: 1314 2: sp1patch.msp
MSI (s) (A8:E0) [19:06:49:199]: Unable to create a temp copy of patch
'sp1patch.msp'.
This patch package could not be opened. Verify that the patch package
exists and that you can access it, or contact the application vendor to
verify that this is a valid Windows Installer patch package.
D:\Reporting_Services_Install\REPORTING_SERVICES-ENT\Setup\RSRUN.MSI
MSI (s) (A8:E0) [19:06:49:215]: Note: 1: 1708
MSI (s) (A8:E0) [19:06:49:215]: Note: 1: 2729
MSI (s) (A8:E0) [19:06:49:309]: Note: 1: 2729
MSI (s) (A8:E0) [19:06:49:324]: Product: Microsoft SQL Server 2000 Reporting
Services Enterprise Edition -- Installation failed.
MSI (s) (A8:E0) [19:06:49:340]: MainEngineThread is returning 1635
MSI (c) (94:58) [19:06:49:356]: Decrementing counter to disable shutdown. If
counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (94:58) [19:06:49:356]: MainEngineThread is returning 1635
=== Verbose logging stopped: 10/28/2005 19:06:49 ===Hello all
I am still without solution for my trouble describe here after.
Is there any additional inforamtion that could be require to identify the
trouble
Thanks if anyone can help about it
Dominique
"dominique deboise" wrote:
> Hi all,
> I tried to install Reporting services service pack 2 on our production
> server but it failed before doing any update.
> environnement is windows 2000 & framework dotnet 1.1 service pack 1
> the same package was successfull on the developpement server - supposed to
> be the same environnement.
>
> The logfile shows an error 1635 and it seem to be linked to a file
> sp1patch.msp
> I could not find anything usefull on the net
> Thanks in advance for any help
> because we are using in our report one of the feature that cannot work
> without the service pack 2.
>
> herefater the log trace :
> -----
> === Verbose logging started: 10/28/2005 19:05:40 Build type: SHIP UNICODE
> 3.01.4000.2435 Calling process:
> e:\6704fbb7257fc7f7594ebb9e1cf255b8\sp2setup.exe ===> MSI (c) (94:58) [19:05:40:481]: Resetting cached policy values
> MSI (c) (94:58) [19:05:40:481]: Machine policy value 'Debug' is 0
> MSI (c) (94:58) [19:05:40:481]: ******* RunEngine:
> ******* Product: {33FE9EED-1976-4A51-A7AF-332D9BBB9400}
> ******* Action:
> ******* CommandLine: **********
> MSI (c) (94:58) [19:05:40:481]: Client-side and UI is none or basic: Running
> entire install on the server.
> MSI (c) (94:58) [19:05:40:481]: Grabbed execution mutex.
> MSI (c) (94:58) [19:05:40:590]: Cloaking enabled.
> MSI (c) (94:58) [19:05:40:590]: Attempting to enable all disabled priveleges
> before calling Install on Server
> MSI (c) (94:58) [19:05:40:621]: Incrementing counter to disable shutdown.
> Counter after increment: 0
> MSI (s) (A8:0C) [19:05:40:668]: Grabbed execution mutex.
> MSI (s) (A8:E0) [19:05:40:668]: Resetting cached policy values
> MSI (s) (A8:E0) [19:05:40:668]: Machine policy value 'Debug' is 0
> MSI (s) (A8:E0) [19:05:40:668]: ******* RunEngine:
> ******* Product: {33FE9EED-1976-4A51-A7AF-332D9BBB9400}
> ******* Action:
> ******* CommandLine: **********
> MSI (s) (A8:E0) [19:05:40:668]: Machine policy value 'DisableUserInstalls'
> is 0
> MSI (s) (A8:E0) [19:05:40:684]: Warning: Local cached package
> 'C:\W2TP\Installer\ba2813.msi' is missing.
> MSI (s) (A8:E0) [19:05:40:684]: User policy value 'SearchOrder' is 'nmu'
> MSI (s) (A8:E0) [19:05:40:684]: User policy value 'DisableMedia' is 0
> MSI (s) (A8:E0) [19:05:40:684]: Machine policy value 'AllowLockdownMedia' is 0
> MSI (s) (A8:E0) [19:05:40:684]: SOURCEMGMT: Media enabled only if package is
> safe.
> MSI (s) (A8:E0) [19:05:40:684]: SOURCEMGMT: Looking for sourcelist for
> product {33FE9EED-1976-4A51-A7AF-332D9BBB9400}
> MSI (s) (A8:E0) [19:05:40:684]: SOURCEMGMT: Adding
> {33FE9EED-1976-4A51-A7AF-332D9BBB9400}; to potential sourcelist list
> (pcode;disk;relpath).
> MSI (s) (A8:E0) [19:05:40:684]: SOURCEMGMT: Now checking product
> {33FE9EED-1976-4A51-A7AF-332D9BBB9400}
> MSI (s) (A8:E0) [19:05:40:684]: SOURCEMGMT: Media is enabled for product.
> MSI (s) (A8:E0) [19:05:40:684]: SOURCEMGMT: Attempting to use LastUsedSource
> from source list.
> MSI (s) (A8:E0) [19:05:40:684]: SOURCEMGMT: Trying source
> D:\Reporting_Services_Install\REPORTING_SERVICES-ENT\Setup\.
> MSI (s) (A8:E0) [19:05:40:856]: Entering
> CMsiConfigurationManager::SetLastUsedSource.
> MSI (s) (A8:E0) [19:05:40:856]: Specifed source is already in a list.
> MSI (s) (A8:E0) [19:05:40:856]: User policy value 'SearchOrder' is 'nmu'
> MSI (s) (A8:E0) [19:05:40:856]: Machine policy value 'DisableBrowse' is 0
> MSI (s) (A8:E0) [19:05:40:856]: Machine policy value 'AllowLockdownBrowse'
> is 0
> MSI (s) (A8:E0) [19:05:40:856]: Adding new sources is allowed.
> MSI (s) (A8:E0) [19:05:40:856]: Set LastUsedSource to:
> D:\Reporting_Services_Install\REPORTING_SERVICES-ENT\Setup\.
> MSI (s) (A8:E0) [19:05:40:856]: Set LastUsedType to: n.
> MSI (s) (A8:E0) [19:05:40:856]: Set LastUsedIndex to: 1.
> MSI (s) (A8:E0) [19:05:40:871]: SOURCEMGMT: Resolved source to:
> 'D:\Reporting_Services_Install\REPORTING_SERVICES-ENT\Setup\'
> MSI (s) (A8:E0) [19:05:40:918]: File will have security applied from OpCode.
> MSI (s) (A8:E0) [19:05:41:215]: End dialog not enabled
> MSI (s) (A8:E0) [19:05:41:215]: Original package ==>
> D:\Reporting_Services_Install\REPORTING_SERVICES-ENT\Setup\RSRUN.MSI
> MSI (s) (A8:E0) [19:05:41:215]: Package we're running from ==>
> C:\W2TP\Installer\cbc12.msi
> MSI (s) (A8:E0) [19:05:41:418]: APPCOMPAT: looking for appcompat database
> entry with ProductCode '{33FE9EED-1976-4A51-A7AF-332D9BBB9400}'.
> MSI (s) (A8:E0) [19:05:41:418]: APPCOMPAT: no matching ProductCode found in
> database.
> MSI (s) (A8:E0) [19:05:41:418]: MSCOREE not loaded loading copy from system32
> MSI (s) (A8:E0) [19:05:41:512]: Opening existing patch
> 'C:\W2TP\Installer\ba290c.msp'.
> MSI (s) (A8:E0) [19:05:41:512]: Note: 1: 2203 2:
> C:\W2TP\Installer\ba290c.msp 3: -2147287038
> MSI (s) (A8:E0) [19:05:41:512]: Couldn't find local patch
> 'C:\W2TP\Installer\ba290c.msp'. Looking for it at its source.
> MSI (s) (A8:E0) [19:05:41:512]: Resolving Patch source.
> MSI (s) (A8:E0) [19:05:41:512]: User policy value 'SearchOrder' is 'nmu'
> MSI (s) (A8:E0) [19:05:41:512]: SOURCEMGMT: Media enabled only if package is
> safe.
> MSI (s) (A8:E0) [19:05:41:512]: SOURCEMGMT: Looking for sourcelist for
> product {813A147C-2328-4439-9D40-1486308CB952}
> MSI (s) (A8:E0) [19:05:41:512]: SOURCEMGMT: Adding
> {813A147C-2328-4439-9D40-1486308CB952}; to potential sourcelist list
> (pcode;disk;relpath).
> MSI (s) (A8:E0) [19:05:41:512]: SOURCEMGMT: Now checking product
> {813A147C-2328-4439-9D40-1486308CB952}
> MSI (s) (A8:E0) [19:05:41:512]: SOURCEMGMT: Media is enabled for product.
> MSI (s) (A8:E0) [19:05:41:512]: SOURCEMGMT: Attempting to use LastUsedSource
> from source list.
> MSI (s) (A8:E0) [19:05:41:512]: SOURCEMGMT: Processing net source list.
> MSI (s) (A8:E0) [19:05:41:527]: SOURCEMGMT: Trying source
> e:\3d0526d9dd77e601344dcc338f4f\.
> MSI (s) (A8:E0) [19:05:41:527]: Note: 1: 2203 2:
> e:\3d0526d9dd77e601344dcc338f4f\sp1patch.msp 3: -2147287037
> MSI (s) (A8:E0) [19:05:41:527]: SOURCEMGMT: Source is invalid due to
> missing/inaccessible package.
> MSI (s) (A8:E0) [19:05:41:527]: Note: 1: 1706 2: -2147483647 3: sp1patch.msp
> MSI (s) (A8:E0) [19:05:41:527]: SOURCEMGMT: Processing media source list.
> MSI (s) (A8:E0) [19:05:42:652]: SOURCEMGMT: Resolved source to: 'sp1patch.msp'
> MSI (s) (A8:E0) [19:06:49:199]: Note: 1: 1314 2: sp1patch.msp
> MSI (s) (A8:E0) [19:06:49:199]: Unable to create a temp copy of patch
> 'sp1patch.msp'.
> This patch package could not be opened. Verify that the patch package
> exists and that you can access it, or contact the application vendor to
> verify that this is a valid Windows Installer patch package.
> D:\Reporting_Services_Install\REPORTING_SERVICES-ENT\Setup\RSRUN.MSI
> MSI (s) (A8:E0) [19:06:49:215]: Note: 1: 1708
> MSI (s) (A8:E0) [19:06:49:215]: Note: 1: 2729
> MSI (s) (A8:E0) [19:06:49:309]: Note: 1: 2729
> MSI (s) (A8:E0) [19:06:49:324]: Product: Microsoft SQL Server 2000 Reporting
> Services Enterprise Edition -- Installation failed.
> MSI (s) (A8:E0) [19:06:49:340]: MainEngineThread is returning 1635
> MSI (c) (94:58) [19:06:49:356]: Decrementing counter to disable shutdown. If
> counter >= 0, shutdown will be denied. Counter after decrement: -1
> MSI (c) (94:58) [19:06:49:356]: MainEngineThread is returning 1635
> === Verbose logging stopped: 10/28/2005 19:06:49 ===>

rs script utility and vbScript

Hi,
I've modified PublishSampleReports.rss and it is working fine to deploy
reports, set data sources and update parameters. However, there is one
thing I can't seem to get working...
I'm trying to read the list of report names to be deployed from a text
file. To do so I was using the following bit of vbScript...
Dim objFSO
Set objFSO =3D CreateObject("Scripting.FileSystemObject")
and trying to use this to connect to the text file to read the report
names. But it tells me that it doesn't recognise CreateObject()
Is this because the .rss file doesn't use vbScript? Or am I just doing
something worng?
Any help would be greatly appreciated...
Thanks
Gear=F3idoops, I think I may have discovered my mistake - the rss script is
written in vb.net, not vbScript. Take 2...

RS App tier vs. SQL DB tier, mixing cumulative updates

Does anyone know if it is possible or if any issues will be seen by
updating our RS app tier to a different SQL SP2 cumulative update
level than our SQL DB tier? A higher cumulative update obviously.
Currently our AppTier is SSRS 2005 SP2 and our DB tier is SQL 2005
SP2.
Thanks,
KelI don't see any issue at all. You can have the metadata/object cache on SQL
2000. If RS doesn't care if the database is 2000 it sure wouldn't care if it
a slightly different SQL 2005.
I ran for 6 months with RS 2005 using SQL 2000 so I know this works.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<kelkoenig@.gmail.com> wrote in message
news:5349c98e-88d6-4347-b209-338c246b7597@.e23g2000prf.googlegroups.com...
> Does anyone know if it is possible or if any issues will be seen by
> updating our RS app tier to a different SQL SP2 cumulative update
> level than our SQL DB tier? A higher cumulative update obviously.
> Currently our AppTier is SSRS 2005 SP2 and our DB tier is SQL 2005
> SP2.
> Thanks,
> Kel