Moving Registered server from one SQL client to another.

Question

Moving Registered server from one SQL client to another.

Arun Modasra

SSChasing Mays

Points: 604
More actions
September 27, 2005 at 1:00 pm

#89306

This has always been a nagging problem for me. The laptop/workstation in our company are leased and thereby replaced every three years.
As a result, I reinstall SQL server on my laptop. The problems I have is, I manage 100+ server so they are registered locally on my machine.
IS THERE A WAY TO MOVE THE REGISTERED SERVER FROM ONE WORKSTATION/LAPTOP TO ANTOHER? BESIDES THE PAINS TAKING WAY OF REREGISTERING EACH SERVER.
Much Appreciated
am

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

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

Linda M Palladino SSC Eights! Points: 928 More actions · Answer 1

I'm not aware of a way to move the registered servers, but you could write a script using the sp_addserver so that you would just have to run the script when you change machines.

l

Carl Federl One Orange Chip Points: 25384 More actions · Answer 2

If by registered servers, you mean registered with Enterprise Manager, use RegEdit to export from registry key HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\80\Tools\SQLEW\Registered Servers X

and then import into the other workstation.

SQL = Scarcely Qualifies as a Language

Arun Modasra SSChasing Mays Points: 604 More actions · Answer 3

Yup, that is what I meant and thanks, will give a try..