Results 1 to 12 of 12

Thread: different login & SQL console root .....

  1. #1
    Join Date
    Mar 2003
    Posts
    383

    different login & SQL console root .....

    Logged on local Administrator on one of my sqlserver 2000 "ABC" and registered 5 sql groups and linked 50 sql2k servers from MSDE to Standare (all sp3).
    Now, I need a different login on this machine "ABC", how could I get back all the SQL Enterprise Manager Console Root Setting and connections like before?

    thanks
    David

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Don't think so, have to register servers for new windows user.

  3. #3
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Copy

    C:\Program Files\Microsoft SQL Server\80\Tools\Binn\SQL Server Enterprise Manager.MSC

    file while logged in as your original user to a different location, log in as new user and overwrite the file.

    Never tried but may work

  4. #4
    Join Date
    Sep 2002
    Posts
    5,938
    Info for registered servers are saved in current user hive in registry, and all windows users use same .msc file.

  5. #5
    Join Date
    Mar 2003
    Posts
    383
    I have tried to copy
    <<SQL Server Enterprise Manager.msc>> file from the old login and overwrite to the tools\binn with the new login.

    But the SQL enterprise manager actually only presented the default local group instead of previous 5 groups and 50 registered servers.

    Thank for your kind response.
    -David

  6. #6
    Join Date
    Nov 2002
    Location
    DE
    Posts
    246
    Open EM and choose Tools from the MMC menu bar, go to Options. There is an option "Read/Store User Independent" which is checked by default. Uncheck it and your registered servers should be stores in "All Users" instead of "Current User".

    If this does not work for replicating existing registrations you can still hack the registry:

    Export HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\80\Tools\SQLEW\Registered Servers X\SQL Server Group
    while logged in with the old user

    and import the registry file after having logged in as the new user.

  7. #7
    Join Date
    Sep 2002
    Posts
    5,938
    Neither of them work in sql2k em since registry key is encrypted.

  8. #8
    Join Date
    Nov 2002
    Location
    DE
    Posts
    246
    Ooops, have not tried it i must admit.

    Are you sure that even the first option in EM does not do the job?

  9. #9
    Join Date
    Mar 2003
    Posts
    383

    re-new all registered servers from console...

    I have tried the EM Console-->Tools-->Options--> unchecked "Read/Store user independently" under Read/Store Locally option.
    the result is all 5 groups gone and left no groups there. Thus, have to rechecked box of "Read/Store user independently".

    Just think there got to have a way to do so, those smart guys who developped MMC for sql2k should have a better way than in the registry, since these are just part of the interface!?

    thanks
    David

  10. #10
    Join Date
    Sep 2002
    Posts
    5,938
    It's confirmed by Microsoft that you can't do that with sql2k em for security reason.

  11. #11
    Join Date
    Mar 2003
    Posts
    383

    Still Not Give Up Yet.....

    thanks rmiao, with Microsoft and your conformation, it is time to 'give up'...

    The last effort: Is there a way to generate the script for all 50 servers registration?

    In another word, instead of registering a remote server via EM, could it be registered via Tran-SQL? Thus, we could run the script any time with any different logins!

    -D

  12. #12
    Join Date
    Sep 2002
    Posts
    5,938
    You can't register sql server with t-sql, it's nothing to do with database.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •