RDL Database Location

I am now supporting a previously installed copy of RS 2000.
RS was installed on ServerA which the users access via browser to
render the reports. The RDLs however are located in a SQL DB
on ServerB.
After much searching around I finally found the RDL server\DB but this
was after having no luck trying to determine this from the RS config
installed on ServerA. I checked the registry and all the config files under
the \Program Files\Microsoft SQL Server folder. Where is the RDL
server info maintained?
Thanks and Happy New Year to All!!Use WMI. There is an example here
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSUIREF/htm/f1_rsc_help_v1_3ddc.asp?frame=true
--
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
"Mike Harbinger" <MikeH@.Cybervillage.net> wrote in message
news:uj74zY0DGHA.3916@.TK2MSFTNGP10.phx.gbl...
>I am now supporting a previously installed copy of RS 2000.
> RS was installed on ServerA which the users access via browser to
> render the reports. The RDLs however are located in a SQL DB
> on ServerB.
> After much searching around I finally found the RDL server\DB but this
> was after having no luck trying to determine this from the RS config
> installed on ServerA. I checked the registry and all the config files
> under
> the \Program Files\Microsoft SQL Server folder. Where is the RDL
> server info maintained?
> Thanks and Happy New Year to All!!
>
>|||I don't see any reference to this any any of the items discussed?
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:O$iSKI7DGHA.620@.TK2MSFTNGP11.phx.gbl...
> Use WMI. There is an example here
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSUIREF/htm/f1_rsc_help_v1_3ddc.asp?frame=true
> --
> HTH,
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
>
> "Mike Harbinger" <MikeH@.Cybervillage.net> wrote in message
> news:uj74zY0DGHA.3916@.TK2MSFTNGP10.phx.gbl...
>>I am now supporting a previously installed copy of RS 2000.
>> RS was installed on ServerA which the users access via browser to
>> render the reports. The RDLs however are located in a SQL DB
>> on ServerB.
>> After much searching around I finally found the RDL server\DB but this
>> was after having no luck trying to determine this from the RS config
>> installed on ServerA. I checked the registry and all the config files
>> under
>> the \Program Files\Microsoft SQL Server folder. Where is the RDL
>> server info maintained?
>> Thanks and Happy New Year to All!!
>>
>|||If you compile and run the code sample you'll see one of the properties
returned from the MSReportServer_ConfigurationSetting instance is the
DatabaseServerName which is what I believe you were asking about? A cut down
version for that specific property is below
string servername = "servername"; // change this to your RS servername
string WmiNamespace = @."\\" + servername +
@."\root\Microsoft\SqlServer\ReportingServices\v8";
string WmiRSClass = @."\\" + servername +
@."\root\Microsoft\SqlServer\ReportingServices\v8:MSReportServer_ConfigurationSetting";
ManagementClass serverClass;
ManagementScope scope;
scope = new ManagementScope(WmiNamespace);
scope.Connect();
serverClass = new ManagementClass(WmiRSClass);
serverClass.Get();
if (serverClass == null)
throw new Exception("No class found");
ManagementObjectCollection instances = serverClass.GetInstances();
foreach(ManagementObject instance in instances)
{
Console.Out.WriteLine("Instance Detected");
PropertyDataCollection instProps = instance.Properties;
foreach(PropertyData prop in instProps)
{
if(prop.Name == "DatabaseServerName")
{
string name = prop.Name;
object val = prop.Value;
Console.Out.Write("Property Name: " + name);
if (val != null)
Console.Out.WriteLine(" Value: " + val.ToString());
else
Console.Out.WriteLine(" Value: <null>");
}
}
}
Console.WriteLine("");
Console.WriteLine("Press any key to exit....");
Console.ReadLine();
--
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
"Mike Harbinger" <MikeH@.Cybervillage.net> wrote in message
news:%23weMuK8DGHA.1976@.TK2MSFTNGP10.phx.gbl...
>I don't see any reference to this any any of the items discussed?
>
> "Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
> news:O$iSKI7DGHA.620@.TK2MSFTNGP11.phx.gbl...
>> Use WMI. There is an example here
>> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSUIREF/htm/f1_rsc_help_v1_3ddc.asp?frame=true
>> --
>> HTH,
>> Jasper Smith (SQL Server MVP)
>> http://www.sqldbatips.com
>>
>> "Mike Harbinger" <MikeH@.Cybervillage.net> wrote in message
>> news:uj74zY0DGHA.3916@.TK2MSFTNGP10.phx.gbl...
>>I am now supporting a previously installed copy of RS 2000.
>> RS was installed on ServerA which the users access via browser to
>> render the reports. The RDLs however are located in a SQL DB
>> on ServerB.
>> After much searching around I finally found the RDL server\DB but this
>> was after having no luck trying to determine this from the RS config
>> installed on ServerA. I checked the registry and all the config files
>> under
>> the \Program Files\Microsoft SQL Server folder. Where is the RDL
>> server info maintained?
>> Thanks and Happy New Year to All!!
>>
>>
>|||Thanks Jasper, but I an not a .NET programmer. I assumed that this was
exposed at a higher level either in the the GUI tools, config files or
registry. If not, could I impose on you as to how I might go about compiling
this?
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:uB7ZEG9DGHA.128@.TK2MSFTNGP10.phx.gbl...
> If you compile and run the code sample you'll see one of the properties
> returned from the MSReportServer_ConfigurationSetting instance is the
> DatabaseServerName which is what I believe you were asking about? A cut
> down version for that specific property is below
> string servername = "servername"; // change this to your RS servername
> string WmiNamespace = @."\\" + servername +
> @."\root\Microsoft\SqlServer\ReportingServices\v8";
> string WmiRSClass = @."\\" + servername +
> @."\root\Microsoft\SqlServer\ReportingServices\v8:MSReportServer_ConfigurationSetting";
> ManagementClass serverClass;
> ManagementScope scope;
> scope = new ManagementScope(WmiNamespace);
> scope.Connect();
> serverClass = new ManagementClass(WmiRSClass);
> serverClass.Get();
> if (serverClass == null)
> throw new Exception("No class found");
> ManagementObjectCollection instances = serverClass.GetInstances();
> foreach(ManagementObject instance in instances)
> {
> Console.Out.WriteLine("Instance Detected");
> PropertyDataCollection instProps = instance.Properties;
> foreach(PropertyData prop in instProps)
> {
> if(prop.Name == "DatabaseServerName")
> {
> string name = prop.Name;
> object val = prop.Value;
> Console.Out.Write("Property Name: " + name);
> if (val != null)
> Console.Out.WriteLine(" Value: " + val.ToString());
> else
> Console.Out.WriteLine(" Value: <null>");
> }
> }
> }
> Console.WriteLine("");
> Console.WriteLine("Press any key to exit....");
> Console.ReadLine();
> --
> HTH,
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
>
> "Mike Harbinger" <MikeH@.Cybervillage.net> wrote in message
> news:%23weMuK8DGHA.1976@.TK2MSFTNGP10.phx.gbl...
>>I don't see any reference to this any any of the items discussed?
>>
>> "Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
>> news:O$iSKI7DGHA.620@.TK2MSFTNGP11.phx.gbl...
>> Use WMI. There is an example here
>> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSUIREF/htm/f1_rsc_help_v1_3ddc.asp?frame=true
>> --
>> HTH,
>> Jasper Smith (SQL Server MVP)
>> http://www.sqldbatips.com
>>
>> "Mike Harbinger" <MikeH@.Cybervillage.net> wrote in message
>> news:uj74zY0DGHA.3916@.TK2MSFTNGP10.phx.gbl...
>>I am now supporting a previously installed copy of RS 2000.
>> RS was installed on ServerA which the users access via browser to
>> render the reports. The RDLs however are located in a SQL DB
>> on ServerB.
>> After much searching around I finally found the RDL server\DB but this
>> was after having no luck trying to determine this from the RS config
>> installed on ServerA. I checked the registry and all the config files
>> under
>> the \Program Files\Microsoft SQL Server folder. Where is the RDL
>> server info maintained?
>> Thanks and Happy New Year to All!!
>>
>>
>>
>|||Hi Mike,
I have uploaded a sample project to
http://www.sqldbatips.com/samples/code/RSWMIConfig.zip
If you have Visual Studio 2003 installed just open the project, fill in the
servername and press F5 to run it. If you don't have it installed then just
grab the RSWMIConfig.exe out of the \bin\Debug folder. Open a command prompt
to the folder where the exe is and run it supplying the servername as an
argument e.g.
C:\>RSWMIConfig.exe servername
--
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
"Mike Harbinger" <MikeH@.Cybervillage.net> wrote in message
news:ukyqFr$DGHA.3820@.TK2MSFTNGP12.phx.gbl...
> Thanks Jasper, but I an not a .NET programmer. I assumed that this was
> exposed at a higher level either in the the GUI tools, config files or
> registry. If not, could I impose on you as to how I might go about
> compiling this?
> "Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
> news:uB7ZEG9DGHA.128@.TK2MSFTNGP10.phx.gbl...
>> If you compile and run the code sample you'll see one of the properties
>> returned from the MSReportServer_ConfigurationSetting instance is the
>> DatabaseServerName which is what I believe you were asking about? A cut
>> down version for that specific property is below
>> string servername = "servername"; // change this to your RS servername
>> string WmiNamespace = @."\\" + servername +
>> @."\root\Microsoft\SqlServer\ReportingServices\v8";
>> string WmiRSClass = @."\\" + servername +
>> @."\root\Microsoft\SqlServer\ReportingServices\v8:MSReportServer_ConfigurationSetting";
>> ManagementClass serverClass;
>> ManagementScope scope;
>> scope = new ManagementScope(WmiNamespace);
>> scope.Connect();
>> serverClass = new ManagementClass(WmiRSClass);
>> serverClass.Get();
>> if (serverClass == null)
>> throw new Exception("No class found");
>> ManagementObjectCollection instances = serverClass.GetInstances();
>> foreach(ManagementObject instance in instances)
>> {
>> Console.Out.WriteLine("Instance Detected");
>> PropertyDataCollection instProps = instance.Properties;
>> foreach(PropertyData prop in instProps)
>> {
>> if(prop.Name == "DatabaseServerName")
>> {
>> string name = prop.Name;
>> object val = prop.Value;
>> Console.Out.Write("Property Name: " + name);
>> if (val != null)
>> Console.Out.WriteLine(" Value: " + val.ToString());
>> else
>> Console.Out.WriteLine(" Value: <null>");
>> }
>> }
>> }
>> Console.WriteLine("");
>> Console.WriteLine("Press any key to exit....");
>> Console.ReadLine();
>> --
>> HTH,
>> Jasper Smith (SQL Server MVP)
>> http://www.sqldbatips.com
>>
>> "Mike Harbinger" <MikeH@.Cybervillage.net> wrote in message
>> news:%23weMuK8DGHA.1976@.TK2MSFTNGP10.phx.gbl...
>>I don't see any reference to this any any of the items discussed?
>>
>> "Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
>> news:O$iSKI7DGHA.620@.TK2MSFTNGP11.phx.gbl...
>> Use WMI. There is an example here
>> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSUIREF/htm/f1_rsc_help_v1_3ddc.asp?frame=true
>> --
>> HTH,
>> Jasper Smith (SQL Server MVP)
>> http://www.sqldbatips.com
>>
>> "Mike Harbinger" <MikeH@.Cybervillage.net> wrote in message
>> news:uj74zY0DGHA.3916@.TK2MSFTNGP10.phx.gbl...
>>I am now supporting a previously installed copy of RS 2000.
>> RS was installed on ServerA which the users access via browser to
>> render the reports. The RDLs however are located in a SQL DB
>> on ServerB.
>> After much searching around I finally found the RDL server\DB but this
>> was after having no luck trying to determine this from the RS config
>> installed on ServerA. I checked the registry and all the config files
>> under
>> the \Program Files\Microsoft SQL Server folder. Where is the RDL
>> server info maintained?
>> Thanks and Happy New Year to All!!
>>
>>
>>
>>
>|||Jasper
Thanks for your help on this but I cannot find
RSWMIConfig.exe anywhere on the machine
hosting RS report manager nor on my machine
which has Visual Studio .Net 2003 installed.
I do have RSConfig.exe but it does not handle that
argument.
Mike
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:OiiOBkJEGHA.2648@.TK2MSFTNGP11.phx.gbl...
> Hi Mike,
> I have uploaded a sample project to
> http://www.sqldbatips.com/samples/code/RSWMIConfig.zip
> If you have Visual Studio 2003 installed just open the project, fill in
> the servername and press F5 to run it. If you don't have it installed then
> just grab the RSWMIConfig.exe out of the \bin\Debug folder. Open a command
> prompt to the folder where the exe is and run it supplying the servername
> as an argument e.g.
> C:\>RSWMIConfig.exe servername
> --
> HTH,
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
>
> "Mike Harbinger" <MikeH@.Cybervillage.net> wrote in message
> news:ukyqFr$DGHA.3820@.TK2MSFTNGP12.phx.gbl...
>> Thanks Jasper, but I an not a .NET programmer. I assumed that this was
>> exposed at a higher level either in the the GUI tools, config files or
>> registry. If not, could I impose on you as to how I might go about
>> compiling this?
>> "Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
>> news:uB7ZEG9DGHA.128@.TK2MSFTNGP10.phx.gbl...
>> If you compile and run the code sample you'll see one of the properties
>> returned from the MSReportServer_ConfigurationSetting instance is the
>> DatabaseServerName which is what I believe you were asking about? A cut
>> down version for that specific property is below
>> string servername = "servername"; // change this to your RS servername
>> string WmiNamespace = @."\\" + servername +
>> @."\root\Microsoft\SqlServer\ReportingServices\v8";
>> string WmiRSClass = @."\\" + servername +
>> @."\root\Microsoft\SqlServer\ReportingServices\v8:MSReportServer_ConfigurationSetting";
>> ManagementClass serverClass;
>> ManagementScope scope;
>> scope = new ManagementScope(WmiNamespace);
>> scope.Connect();
>> serverClass = new ManagementClass(WmiRSClass);
>> serverClass.Get();
>> if (serverClass == null)
>> throw new Exception("No class found");
>> ManagementObjectCollection instances = serverClass.GetInstances();
>> foreach(ManagementObject instance in instances)
>> {
>> Console.Out.WriteLine("Instance Detected");
>> PropertyDataCollection instProps = instance.Properties;
>> foreach(PropertyData prop in instProps)
>> {
>> if(prop.Name == "DatabaseServerName")
>> {
>> string name = prop.Name;
>> object val = prop.Value;
>> Console.Out.Write("Property Name: " + name);
>> if (val != null)
>> Console.Out.WriteLine(" Value: " + val.ToString());
>> else
>> Console.Out.WriteLine(" Value: <null>");
>> }
>> }
>> }
>> Console.WriteLine("");
>> Console.WriteLine("Press any key to exit....");
>> Console.ReadLine();
>> --
>> HTH,
>> Jasper Smith (SQL Server MVP)
>> http://www.sqldbatips.com
>>
>> "Mike Harbinger" <MikeH@.Cybervillage.net> wrote in message
>> news:%23weMuK8DGHA.1976@.TK2MSFTNGP10.phx.gbl...
>>I don't see any reference to this any any of the items discussed?
>>
>> "Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
>> news:O$iSKI7DGHA.620@.TK2MSFTNGP11.phx.gbl...
>> Use WMI. There is an example here
>> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSUIREF/htm/f1_rsc_help_v1_3ddc.asp?frame=true
>> --
>> HTH,
>> Jasper Smith (SQL Server MVP)
>> http://www.sqldbatips.com
>>
>> "Mike Harbinger" <MikeH@.Cybervillage.net> wrote in message
>> news:uj74zY0DGHA.3916@.TK2MSFTNGP10.phx.gbl...
>>I am now supporting a previously installed copy of RS 2000.
>> RS was installed on ServerA which the users access via browser to
>> render the reports. The RDLs however are located in a SQL DB
>> on ServerB.
>> After much searching around I finally found the RDL server\DB but
>> this
>> was after having no luck trying to determine this from the RS config
>> installed on ServerA. I checked the registry and all the config files
>> under
>> the \Program Files\Microsoft SQL Server folder. Where is the RDL
>> server info maintained?
>> Thanks and Happy New Year to All!!
>>
>>
>>
>>
>>
>