November 15, 2009 at 10:52 pm
Server A is 2000 and Server B is 2005, in server A there are about 10 users having different permissions i dont know the password of the users, if i take the backup and restore server A to server B whether all the users will come into server B or how?
there are different logins are also there how to get those Logins to Server B(2005)
Thanks
Parthi
Thanks
Parthi
November 16, 2009 at 12:31 am
I guess you have to create the server logins explicitly on 2005 (once you move your db). Users would be there at database level.
---------------------------------------------------------------------------------
November 16, 2009 at 9:44 am
Follow the instructions in this kb article for tranferring logins and passwords between different versions: http://support.microsoft.com/kb/246133.
After transferring the logins and restoring the databases, you may need to resolve ophaned users since the logins may have different sids in the new instance. Use sp_change_users_login to resolve these.
Greg
November 16, 2009 at 12:55 pm
Slightly off topic:
would you mind stop qualifying your requests as "very urgent" or "urgent"? (Seems like it became a habit...)
If you ar requested to migrate a db from SS2K to SS2K5 it would save a lot of trouble if you would prepare yourself before you start, not as you go....
That would also prevent marking your requests as "urgent".
Btw: There are some people around that tend to ignore "urgent" requests. And there are more each day.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply