Q:
Users/Roles/Schemas
I'm trying to find some documentation or procedures that will allow me to xfer existing users' roles, etc from sql2000 to sql2005.
When our sql 2005 database was restored on a new server (from sql2000), all of the database users were orphaned. I need to create identical server logins and then make the logins database users. It is also important to understand the significance of the new schema concept. The Microsoft SQL2005UpgradeTechRef.doc white paper does not explain any of this.
Ultimately, I would like to create a script for the above scenario once a sql2005 db is restored from a sql2000 db.
Could someone please help me out on this?
When our sql 2005 database was restored on a new server (from sql2000), all of the database users were orphaned. I need to create identical server logins and then make the logins database users. It is also important to understand the significance of the new schema concept. The Microsoft SQL2005UpgradeTechRef.doc white paper does not explain any of this.
Ultimately, I would like to create a script for the above scenario once a sql2005 db is restored from a sql2000 db.
Could someone please help me out on this?
ASKED:
Nov 27 2006 9:46 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
A:
RATE THIS ANSWER
0
Click to Vote:
0
Click to Vote:
- 0
0
I'm not exactly sure if I followed your description correctly, so let me see if I have this right:
You currently have a SQL2000 server running. You want to upgrade those databases to SQL2005 on a different box. And the issue you're having is orphaned local Windows accounts after the upgrade.
First off, unless you have a method of copying the SAM and having that work on the new server with a different SID, you'll need to do a full copy of the old server and restore onto the new server. That will bring over the local Windows accounts. Otherwise, I would suggest (if this is an option, since I don't know your environment) making the local accounts domain accounts. The you can do a fresh build on the new server, install SQL2005, and migrate the accounts over.
Otherwise, you'll have to build the new server, manually create all of the local accounts, install SQL2005, then migrate the databases over. I'm not terribly Windows savvy, but I'm not aware of any way to script the automation of copying the Windows accounts from one server to another.
I hope this helps.
Jeff
