Post reply

How can I transfer registered servers in Enterprise Manager to SQL Server 2005?

  • April 26, 2007 at 6:58 am

    #123674

    Hi,

    How can I transfer all of my registered SQL Servers from Enterprise Manager in SQL Server 2000 to SQL Server 2005's Management Studio? Can someone help me with this as I have more than 80 registered servers and I don't want to re-register each one under Management Studio in SQL Server 2005.

    Thanks.

     

  • April 26, 2007 at 11:48 am

    #702721

    I dont know if this is what your looking for, but worth a try

    Registered servers. Create your registrations. When login, you will see a list of registered servers. I registerd 2 as Windows Authentication and one as SQL Server authentication with remember password checked.  When re-opened MS tried to prompt me for password for the local server, I dismissed the dialog box and on the left was a list of my registerd servers. I was able to expand each of them without any additional authentication.

    Eric

Viewing 2 posts - 1 through 1 (of 1 total)

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