Hello,
SQL-Server 2000:
how can I remove server registrations from enterprise manager, when
the servers are no more available?
For example there are several registrations from servers running under
a virtual pc (for developer purposes). Others are there from remote
support sessions. I'm not able to get in the context menu of that
servers.
Can you please help me?
Thanks AlfredI found this to be possible.
Using the mouse, if one "right clicks" on the server registration and waits
for what seems like an age, the menu appears allowing one to delete the
registration. Don't left-click first!|||"Alfred Sehmueller" <alfred.sehmueller@.gmx.de> wrote in message
news:8d338431.0408310515.7ae1d9d6@.posting.google.com...
> SQL-Server 2000:
> how can I remove server registrations from enterprise manager, when
> the servers are no more available?
Does right-click, Delete SQL Server Registration not work?
Kind Regards, Howard|||try attached vbscript uses DMO to delete the server registration - rename to
.vbs and run on the server with registration u want to delete byusing
CSCRIPT DELSQLRegistration.vbs
"Alfred Sehmueller" <alfred.sehmueller@.gmx.de> wrote in message
news:8d338431.0408310515.7ae1d9d6@.posting.google.com...
> Hello,
> SQL-Server 2000:
> how can I remove server registrations from enterprise manager, when
> the servers are no more available?
> For example there are several registrations from servers running under
> a virtual pc (for developer purposes). Others are there from remote
> support sessions. I'm not able to get in the context menu of that
> servers.
> Can you please help me?
> Thanks Alfred|||(sorry fat fingers)
try attached vbscript uses DMO to delete the server registration - rename to
.vbs and run on the server with registration u want to delete by using :
CSCRIPT DELSQLRegistration.vbs SERVER
where SERVER is the name of the server Registration you want to delete
Note for it to no longer appear in Enterprise Manager , you need to restart
Enterprise Manager.
Andy.
"Alfred Sehmueller" <alfred.sehmueller@.gmx.de> wrote in message
news:8d338431.0408310515.7ae1d9d6@.posting.google.com...
> Hello,
> SQL-Server 2000:
> how can I remove server registrations from enterprise manager, when
> the servers are no more available?
> For example there are several registrations from servers running under
> a virtual pc (for developer purposes). Others are there from remote
> support sessions. I'm not able to get in the context menu of that
> servers.
> Can you please help me?
> Thanks Alfred
Showing posts with label available. Show all posts
Showing posts with label available. Show all posts
Friday, March 30, 2012
Monday, March 26, 2012
How can I programmatically know if RS is installed on a server or not
Hi,,
I have a list of SQL servers available in our network in a ComboBox ,I want
to show a message if there is no reporting service installed on a server of
user choice ,I tried to use listChildern ,,but when there is no RS ,,it
thows an Exception inside the web referenc.
ThanksOne suggestion would be to put the code calling ListChildren inside of
a Try Catch block. If you catch the exception you can display a
message box saying reporting services was not found.
More info on Try Catch can be found here:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconusingtrycatchblocktocatchexceptions.asp
The problem with this approach is you'll have to set the Url property
of the web reference and assume the report server is installed at the
default location (http://machinename/reportserver). If someone
installed the report server at a different location you'll need a more
robust mechanism to find it. I'd suggest trying WMI (windows
management instrumentation). There is an example in the docs showing
how to connect to a remote report server:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_prog_wmi_6iua.asp
Note: the sample code in the docs also needs a try / catch in case the
server does not have SSRS installed.
--
Scott
http://www.OdeToCode.com/blogs/scott/
On Fri, 12 Nov 2004 11:25:32 -0800, "ALI-R" <newbie@.microsoft.com>
wrote:
>Hi,,
>I have a list of SQL servers available in our network in a ComboBox ,I want
>to show a message if there is no reporting service installed on a server of
>user choice ,I tried to use listChildern ,,but when there is no RS ,,it
>thows an Exception inside the web referenc.
>Thanks
>
I have a list of SQL servers available in our network in a ComboBox ,I want
to show a message if there is no reporting service installed on a server of
user choice ,I tried to use listChildern ,,but when there is no RS ,,it
thows an Exception inside the web referenc.
ThanksOne suggestion would be to put the code calling ListChildren inside of
a Try Catch block. If you catch the exception you can display a
message box saying reporting services was not found.
More info on Try Catch can be found here:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconusingtrycatchblocktocatchexceptions.asp
The problem with this approach is you'll have to set the Url property
of the web reference and assume the report server is installed at the
default location (http://machinename/reportserver). If someone
installed the report server at a different location you'll need a more
robust mechanism to find it. I'd suggest trying WMI (windows
management instrumentation). There is an example in the docs showing
how to connect to a remote report server:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_prog_wmi_6iua.asp
Note: the sample code in the docs also needs a try / catch in case the
server does not have SSRS installed.
--
Scott
http://www.OdeToCode.com/blogs/scott/
On Fri, 12 Nov 2004 11:25:32 -0800, "ALI-R" <newbie@.microsoft.com>
wrote:
>Hi,,
>I have a list of SQL servers available in our network in a ComboBox ,I want
>to show a message if there is no reporting service installed on a server of
>user choice ,I tried to use listChildern ,,but when there is no RS ,,it
>thows an Exception inside the web referenc.
>Thanks
>
Subscribe to:
Posts (Atom)