March 20, 2006 at 1:14 pm
When upgrading db from 2000 to 2005, my db users for the 2005 db, the "without login" option keeps getting set in their "Properties".
Here is what I did:
1) Created a new blank db on my sql 2005 server named "TestingDB".
2) Under "Security" -> "Logins" folder for the server, I double-clicked on the two users that need access to "TestingDB" and set the "User Mapping" such that the users had access to this database. Note: These users already existed on my 2005 server since I created them previously.
3) Within "TestingDB", I created two new database roles. I added the 2 users (from step 2) to these roles. Note: After this step, I checked the user properties for my two users and the "Login Name" option was set appropriately (as opposed to "Without Login" option).
4) From a query window, I used the "restore" command to restore a backup of the 2000 version of the database to my new "TestingDB" 2005 database.
5) From a query window, I ran "sp_dbcmptlevel TestingDB, 90".
6) Now when I look at the properties for the 2 db users in "TestingDB", the "Without Login" option is set.
What am I missing?
Thanks for your help in advance.
Norene Malaney
March 21, 2006 at 4:28 am
Use the copy database wizard, it'll migrate the users as well.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply