By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,664 Members | 1,592 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,664 IT Pros & Developers. It's quick & easy.

Restoring backup from SQL 2000 to SQL 2005 but login name is missing

P: n/a
Hi all,

I'm having a problem restoring backup from 2000 to 2005. The actual
restore process went ok. However, the database user of the restored
database is missing a Login Name. I've made sure that the Login Name
is created in 2005. Also tried deleting the user, but couldn't the
user is db owner. Is there any way that I can assign a Login Name for
this database user or maybe drop this user and assign another one?

Regards,
Gerd

Mar 29 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
kb
I'm having a problem restoring backup from 2000 to 2005. The actual
restore process went ok. However, the database user of the restored
database is missing a Login Name. I've made sure that the Login Name
is created in 2005. Also tried deleting the user, but couldn't the
user is db owner. Is there any way that I can assign a Login Name for
this database user or maybe drop this user and assign another one?
use system stored procedure:

sp_change_users_login

--
Tom
http://kbupdate.info/
Mar 29 '07 #2

P: n/a
kb
>I'm having a problem restoring backup from 2000 to 2005. The actual
>restore process went ok. However, the database user of the restored
database is missing a Login Name. I've made sure that the Login Name
is created in 2005. Also tried deleting the user, but couldn't the
user is db owner. Is there any way that I can assign a Login Name for
this database user or maybe drop this user and assign another one?

use system stored procedure:
sp_change_users_login
here is online documentation:

SQL Server 2005 Books Online sp_change_users_login:
http://msdn2.microsoft.com/en-us/library/ms174378.aspx
--
Tom
http://kbupdate.info/
Mar 29 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.