Post reply

How to transfer the registered SQL Servers

  • July 26, 2007 at 7:39 am

    #75165

    Hi Guys !

    I have around 50 servers registered on my client machine,now i want to transfer these registred servers to another client machine,is there any method to transfer these logins without much efforts(may be using some scripts to transfer)

    or do i need to manually register each and every server to another client machine..?

    thnks 4 any help !

  • July 26, 2007 at 7:52 am

    #722578

    Not sure how much this helps... but you can get a list of registered servers on the local pc here :

     

    HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\80\Tools\SQLEW\Registered Servers X

     

    I'm not srue how I'd go into turning this into a script tho...

  • July 26, 2007 at 8:17 am

    #722585

    Thnks !

    I think by exporting this registry value and importing this value to another client machine may help !

    thnks a lot

  • July 26, 2007 at 8:34 am

    #722593

    NP, but I will suggest that you backup the client's registry before importing :-).

     

    Let us know how this works for ya.

  • July 31, 2007 at 6:58 am

    #723546

    Although exporting/importing registry did work at one time, this method no longer works. The good news is that Gustavo Merle has written a VBS to perform this function.

    http://www.sqlservercentral.com/forums/printtopic.aspx?forumid=24&messageid=270935

    SQL = Scarcely Qualifies as a Language

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply