Post reply

Migrating SQL 2000 logons to SQL 2005

  • April 23, 2012 at 2:21 pm

    #260301

    I am aware of the standard process to move SQL logons and passwords from one SQL version to another, especially if the different SQLs are on different servers.

    But we have installed a side by side SQL 2005 instance on the same physical server as where the originating SQL 2000 database is installed. Since it is the same box, do I still need to run the logon

    move process to get the userids from SQL 2000 to 2005? Thanks in advance!! J. Nelson

  • April 23, 2012 at 2:34 pm

    #1477814

    If the 2005 instance wasn't an in-place upgrade but a fresh install you'll still need to copy the logins from 2000 instance to the 2005 instance. Instances on the same server don't share internal sql resources.

  • April 23, 2012 at 2:53 pm

    #1477825

    Thanks Richard. Just confirms you can't skip anything around here...:Whistling:

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

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