Server Registration Feature - by WesleyB

Status : 

  Fixed<br /><br />
		This item has been fixed in the current or upcoming version of this product.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 136596 Comments
Status Closed Workarounds
Type Suggestion Repros 0
Opened 6/16/2006 2:41:39 AM
Access Restriction Public


In SQL Server 2000 you had the ability to register your servers from a remote location in Enterprise Manager.  Although I understand the security consequences I feel that every DBA should be able to decide if he wants to take the risk.  We have to distribute our server list to over 50 people and servers change quite often.  Manual import procedures are not an option in our environment.
Sign in to post a comment.
Posted by WesleyB on 7/21/2006 at 1:50 AM

Ok thanks for the effort already.

Kind regards,
Posted by Microsoft on 6/23/2006 at 2:58 AM
Hi Wesley,
    I understand the scenario better. This isn't something that we will do for a service pack, but we will strongly consider this change request for the next major release of SQL.
Thank you,
Posted by WesleyB on 6/22/2006 at 1:05 PM
Hi Bill,

That is what I call a manual procedure :-)

We have over 30 developers and 10 DBA's. We have a quite volatile server list where new servers and SQL instances pop up quite regularly. Having 40 people import the list on a regular basis is difficult to maintain since people tend to forget things they have to do manually.

The export/import option is certainly a great feature but does not meet the needs we have at our project. If we could import this list automatically from a specified location or even through an API which we can control it would certainly help.

Kind regards,
Posted by RML_NLD on 6/20/2006 at 5:45 AM
This functionality would be nice if I could get it to work. I exported a list, trying to do so with passwords, but after the import, accessing any server results in a error -2146893813 (CryptUnprotectData).
Posted by Microsoft on 6/19/2006 at 12:39 PM
Hi Wesley,
Thank you for your feedback regarding the need to make the management of registered servers easier. We do have the ability to Export your Registered servers by right clicking on any folder/node in the registered server window and choosing the command. You can then right this to a centralized share and have people import the registered servers from this share. Please let us know if this is sufficient to meet your needs.
Thank you,
Bill Ramos