473,385 Members | 1,707 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

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

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
2 7219
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: Edwinah63 | last post by:
Hi Gurus, i am having problems with restoring a ms sql database. i have restored the database using veritas to a different location ('g:\datafiles') in no recover mode. when i view the...
2
by: Kev | last post by:
Hi all, I have a very old MSSQL data backup file. I do not even remember that it was created in SQL7 or 2000. Anyway, I'm trying to recreate DB from this backup. Is it possible to create DB...
1
by: Byron | last post by:
Hi, I have(had) an old Win2k Server server with about 30 web site databases (SQL 2000) that just went under due to hardware problems. Thankfully, I have backups of all the databases plus the MDF...
4
by: Kittikun | last post by:
I am currently using the BACKUP DATABASE method to backup my database. Everything works fine, except for users. I created various users with sp_addlogin to access this database and they are located...
3
by: rdemyan via AccessMonster.com | last post by:
I'm thinking about providing a relatively easy method for users to restore the front end from a backup. The purpose is to allow for restoring if the front end becomes corrupt. Here are some...
1
by: Robbert van Geldrop | last post by:
Hello, I have a problem restoring Exchange 2000 files. Our software has an interface to ESEBCLI2.dll for online backup and restore features. Everything works fine with Exchange 2003 and also...
1
by: DavidCh | last post by:
Is there any way to do that? (Restoring a SQL Server 2005 database in SQL Server 2000) I know that there's not an automatic way, but i wanna know if there's some type of backup or something like...
3
by: riyazrasheed1234 | last post by:
Hi Any one is there to help me? I got stuck migrating SQL Server 2000 to SQL 2005 I have many data in SQL 2000 I create backup file but SQL 2005 is not supporting backup file to restore to SQL...
2
by: l0b0 | last post by:
I'm working on a restore procedure for the case where all MDF files are missing, but the LDF files are all intact. A full backup is done every 24 hours, and a log backup is done every 3 hours....
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.