Read only permissions for report writer

I have an msde database (SQL Server 2000) with an web front end. I would
like to create an MS Access Project to allow certain users to create ad hoc
reports.
I have created a new login named Reporter and connected to the msde database
using this user. This user has dbreadonly permissions.
This works to a certain extent in that new reports can be created based on
existing tables. However, I would like the user to be able to create their
own select queries and cannot find a way to manage this. I recieve a
message saying the user needs 'Create Procedure' rights.
Can anyone tell me how I can let Reporter create their own queries but not
add/edit/delete any existing data?
Many thanks
June
hi June,
June Macleod wrote:
> I have an msde database (SQL Server 2000) with an web front end. I
> would like to create an MS Access Project to allow certain users to
> create ad hoc reports.
> I have created a new login named Reporter and connected to the msde
> database using this user. This user has dbreadonly permissions.
> This works to a certain extent in that new reports can be created
> based on existing tables. However, I would like the user to be able
> to create their own select queries and cannot find a way to manage
> this. I recieve a message saying the user needs 'Create Procedure'
> rights.
> Can anyone tell me how I can let Reporter create their own queries
> but not add/edit/delete any existing data?
> Many thanks
> June
if you are required to allow "CREATE PROC" statement you have to grant
membership to ddladmin database role but, with such a permission, Reporter
can even create new tables and of course access/modify their data..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||better,
if you only are required to create procedures, you can grant that specific
permission to Reporte user like
GRANT CREATE PROCEDURE TO [Reporter]
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Read Only

If I change my Replicated db to Read Only, will this result in any adverse effects for Replicating to this db?
I don't want users to have any access to the db other than reporting, and I read on sql server performance:
"If you have a database that acts as a datamart or data warehouse, set the "read only" database option to true. This will turn off locking and greatly speed queries against the data."
Thoughts anyone?
Thanx!
JLS,
for replication I think you'll have to achieve the same effect (protecting the database) using permissions. Alternatively you could use this option and 'undo' it in the replication synchronization job as a custom step.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||nice idea. however. readonly is readonly and replication i think is not an
excuse
thanks,
Jose de Jesus Jr. Mcp,Mcdba
Data Architect
Sykes Asia (Manila philippines)
MCP #2324787
"JLS" wrote:

> If I change my Replicated db to Read Only, will this result in any adverse effects for Replicating to this db?
> I don't want users to have any access to the db other than reporting, and I read on sql server performance:
> "If you have a database that acts as a datamart or data warehouse, set the "read only" database option to true. This will turn off locking and greatly speed queries against the data."
> Thoughts anyone?
> Thanx!
>

Read list of publications

Is it possible to read the list of publications on a database? What I'd like
to do is give my PocketPC users the ability to choose which publication they
wish to subscribe to on a particular day simply by making a selection from a
listbox or a combo.
On Wed, 17 Nov 2004 16:10:18 -0500, "Earl"
<brikshoe@.newsgroups.nospam> wrote:

>Is it possible to read the list of publications on a database? What I'd like
>to do is give my PocketPC users the ability to choose which publication they
>wish to subscribe to on a particular day simply by making a selection from a
>listbox or a combo.
>
exec sp_helppublication
exec sp_helpsubscription - lists articles
J.
|||Thanks J, I'll give it a go.
"jxstern" <jxstern@.nowhere.com> wrote in message
news:loqnp0t76fc5uas8nij1mm347hm7jgbtsq@.4ax.com...
> On Wed, 17 Nov 2004 16:10:18 -0500, "Earl"
> <brikshoe@.newsgroups.nospam> wrote:
>
> exec sp_helppublication
> exec sp_helpsubscription - lists articles
>
> J.
>
>
|||Both executed successfully in QA. However, neither one returned a result set
(which should be just one item at this time). The publication in question
works properly in both directions, so I'm still scratching my head over how
to view the publication list.
"jxstern" <jxstern@.nowhere.com> wrote in message
news:loqnp0t76fc5uas8nij1mm347hm7jgbtsq@.4ax.com...
> On Wed, 17 Nov 2004 16:10:18 -0500, "Earl"
> <brikshoe@.newsgroups.nospam> wrote:
>
> exec sp_helppublication
> exec sp_helpsubscription - lists articles
>
> J.
>
>
|||Hi Earl,
You will have to run sp_helppublication in the publication database and you
will see the publications. System table Syspublications only exists in the
database that has been replicated, so make sure you are running the
sp_helppublication in the right database.
Another way is using sp_MSenumallpublications, HOWEVER, please KEEP in mind
that it was NOT DOCUMENTED. Microsoft may decide to change it without any
advanced notice. See Bill Hollinshead's comments on this topic:
http://www.google.com/groups?hl=en&l...cpmsftngx a08
Thank you for your patience and corporation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
|||Your kind of up a creek here. The supported way of pulling your merge
publication is through an ActiveX script which uses the Merge ActiveX
control.
You could probably connect to the merge publisher and issue this command
through sp_helpmergepublications using ADOCE. Then present a dialog to the
users displaying these publications and have them select which one they
want.
The IBuySpy CE demo does something like this. You can select your publisher
name, and then this is fed to the ActiveX control.
Hilary Cotter
Looking for a SQL Server replication book?
Now available for purchase at:
http://www.nwsu.com/0974973602.html
"Earl" <brikshoe@.newsgroups.nospam> wrote in message
news:%23xG5skSzEHA.1412@.tk2msftngp13.phx.gbl...
> Both executed successfully in QA. However, neither one returned a result
> set (which should be just one item at this time). The publication in
> question works properly in both directions, so I'm still scratching my
> head over how to view the publication list.
> "jxstern" <jxstern@.nowhere.com> wrote in message
> news:loqnp0t76fc5uas8nij1mm347hm7jgbtsq@.4ax.com...
>
|||Thanks Michael. I ran sp_helppublication in the publication database but did
not see the publication. Thats what has me stumped. I ran it without any
variables, thus it would appear that the list of articles should appear,
sooooo I must be overlooking something. I'll experiment with your
sp_MSenumallpublications.
""Michael Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
news:7UZhKbVzEHA.2544@.cpmsftngxa10.phx.gbl...
> Hi Earl,
> You will have to run sp_helppublication in the publication database and
> you
> will see the publications. System table Syspublications only exists in the
> database that has been replicated, so make sure you are running the
> sp_helppublication in the right database.
> Another way is using sp_MSenumallpublications, HOWEVER, please KEEP in
> mind
> that it was NOT DOCUMENTED. Microsoft may decide to change it without any
> advanced notice. See Bill Hollinshead's comments on this topic:
> http://www.google.com/groups?hl=en&l...cpmsftngx a08
> Thank you for your patience and corporation. If you have any questions or
> concerns, don't hesitate to let me know. We are always here to be of
> assistance!
>
> Sincerely yours,
> Michael Cheng
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> Get Secure! - http://www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>
|||Thanks Hilary. Well, it was a good thought, not a requirement of the
project, and in terms of CF or SQLCE certainly far down the list of "things
I could not do". Oh, I'm looking forward to reading the book.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%23oBAjhXzEHA.3096@.TK2MSFTNGP10.phx.gbl...
> Your kind of up a creek here. The supported way of pulling your merge
> publication is through an ActiveX script which uses the Merge ActiveX
> control.
> You could probably connect to the merge publisher and issue this command
> through sp_helpmergepublications using ADOCE. Then present a dialog to the
> users displaying these publications and have them select which one they
> want.
> The IBuySpy CE demo does something like this. You can select your
> publisher name, and then this is fed to the ActiveX control.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> Now available for purchase at:
> http://www.nwsu.com/0974973602.html
> "Earl" <brikshoe@.newsgroups.nospam> wrote in message
> news:%23xG5skSzEHA.1412@.tk2msftngp13.phx.gbl...
>
|||sp_MSenumallpublications shows my publication, but sp_helppublication does
not. I'm running them both in the pubs database -- is there any other reason
why sp_helppublication would not show the publication?
""Michael Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
news:7UZhKbVzEHA.2544@.cpmsftngxa10.phx.gbl...
> Hi Earl,
> You will have to run sp_helppublication in the publication database and
> you
> will see the publications. System table Syspublications only exists in the
> database that has been replicated, so make sure you are running the
> sp_helppublication in the right database.
> Another way is using sp_MSenumallpublications, HOWEVER, please KEEP in
> mind
> that it was NOT DOCUMENTED. Microsoft may decide to change it without any
> advanced notice. See Bill Hollinshead's comments on this topic:
> http://www.google.com/groups?hl=en&l...cpmsftngx a08
> Thank you for your patience and corporation. If you have any questions or
> concerns, don't hesitate to let me know. We are always here to be of
> assistance!
>
> Sincerely yours,
> Michael Cheng
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> Get Secure! - http://www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>
|||Hi Earl,
It seems really strange. Usually sp_helppublication depends on system table
syspublications. Please run the query, select * from syspublications to see
whether you have get any result.
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!

Re: Set permissions on stored procedures

Hello to all,
How do I set permission to allow some users to Execute the stored procedures without setting indiviually in ea. stored procedure?
Thank you much!You don't

Place the users in a role and grant permission to the role.

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!!
>>
>>
>>
>>
>>
>