sql server 2005 upgrade

  • Planning to upgrade from 2000 to 20005. Just want to know what is going to break. So I can have a plan for it.

  • Run Microsoft's Upgrade Adviser (including a check of SQL running on the machine from a profiler trace).

  • Did upgrade...I unistalled 2000 and installed 2005. I think i did it wrong. Cause i lost all the user names and linked servers. But I dunnot what i did wrong.

  • x-portal (9/28/2007)


    Did upgrade...I unistalled 2000 and installed 2005. I think i did it wrong. Cause i lost all the user names and linked servers. But I dunnot what i did wrong.

    How did you upgrade exactly? Did you just back your database up and restored? Linked servers and login information are stored in the master database.

    Regards,

    Andras


    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software

  • i uninstalled SS2k and installed SS2k5. Then attached the 3 Databses, recreated the link servers and logins

  • As Andras stated, that information is stored in the master database. The loss of logins, etc, that you describe is expected behavior for the upgrade path that you used. Your best bet is to do a backup / restore of all databases and to script out all users. roles etc.

  • thanks, you guys are very helpful.

  • There's a stored proc on microsoft's site called sp_help_revlogins that will script all the windows and sql logins that are in master. Run that and save the output. Apply that to the new instance to get your logins. Then resolve your orphaned users and you're fine.

Viewing 8 posts - 1 through 7 (of 7 total)

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