April 23, 2012 at 2:21 pm
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
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
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy