SQL Server Performance Forum – Threads Archive

Move database to new server – users missing

Hi all,<br />Newbie<br /><br />I’m trying to move a database from an old SQL2000 server to a new SBS2003 box before re-purposing the the old server. I detached the database and moved the 2 files to the new hardware, then reattached the database. The front end of the software can authenticate with the database, but when I look under users, only the dbo is showing, the 2 users from the original are not there. I tried to recreate the users and give them the necessary permissions to log in to the database with no luck. Unable to get the required info from the original authors [<img src=’/community/emoticons/emotion-6.gif’ alt=’‘ />]<br /><br />Is there a way I can move this database maintaining the original users?<br /><br />Regards Trev

---

Use Copy Database Wizard to move or copy database onto the different server with all the logins created and without dettaching the database.

---

Hi ,
definately you can do this with : 1) in my opinion the best way to achieve this is "Generate the script with all objects (Tables,sps,views,cosraints,triggers,roles,users everything – with all options/object),then run the script and then use import / export wizard to copy data to the tables.
2)take complete/full backup and then restore
Regards
Hemantgiri S. Goswami
[email protected]
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemant Goswami

---

you can use sp_change_users_login to fix this problem.
Thanks N’ Regards
DJ

---

Also, see this link for instructions on moving databases with their logins: http://support.microsoft.com/default.aspx?scid=kb;en-us;314546 ————————–
Yes, I am a geek. I know. I can’t help it.

---

Hi, i think there are many ways of doing it depending of what you want to achieve?
For a quick moving of database you can use the ATTACH & DETACH DATABASE
or even the restore way have a look at this:
http://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1102260,00.html?adg=301324
AKTHAR DILMOHAMUD
65 BENARES ST
PORT LOUIS
MAURITIUS

---

Please execute: – select * from yourdbName..sysusers if there were users in database previously..this query should show listing… else i don’t find any reason that attaching-dettaching a database on another server can drop database users. Deepak Kumar –An eye for an eye and everyone shall be blind

---

Thanks all,<br />Copy database wizard failed to copy object.<br />Generate script with object wouldn’t work because disk structure is different on both machines.<br /><br />In the end I managed to recreate the two missing login users and guess their passwords. Detach the database and copy mdf & ldf files to new system. Then attach with new paths.<br /><br />Everything now fine [<img src=’/community/emoticons/emotion-1.gif’ alt=’‘ />]<br /><br />Trev

---

Hi,
i didn’t get you on this ! [?] seems strange to me BTW its good that it is working now Hemantgiri S. Goswami
[email protected]
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemant Goswami

---

]]>