after restore db to another server got problem

Hi,
Our production database JDE7334 tables not belong to dbo
owner; those tables belong to 4 different users.
Once I did backuped and restored this database to another
server. I can't use sp_dropuser to drop automatically
existing users because the user owns objects in the
database and cannot be dropped. The thing is I can't
change table's owner from specific user to dbo, this
database work with JDEdwards software.
My question is how to create login and user to access this
database in new server?
The primary server which I did backup installed SQL Server
Standard Edition with SP3 and the secondary server which I
did restore installed SQL Server Enterprise Edition with
SP2.
Regards
JennyTake a look at these:
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scr...sp?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
Andrew J. Kelly
SQL Server MVP
"Jenny" <jyu@.iseoptions.com> wrote in message
news:12b1301c3f63d$ecccf980$a501280a@.phx
.gbl...
> Hi,
> Our production database JDE7334 tables not belong to dbo
> owner; those tables belong to 4 different users.
> Once I did backuped and restored this database to another
> server. I can't use sp_dropuser to drop automatically
> existing users because the user owns objects in the
> database and cannot be dropped. The thing is I can't
> change table's owner from specific user to dbo, this
> database work with JDEdwards software.
> My question is how to create login and user to access this
> database in new server?
> The primary server which I did backup installed SQL Server
> Standard Edition with SP3 and the secondary server which I
> did restore installed SQL Server Enterprise Edition with
> SP2.
> Regards
> Jenny|||Thanks a lot Andrew, it worked.
Jenny

>--Original Message--
>Take a look at these:
>
>http://www.support.microsoft.com/?id=314546 Moving
DB's between Servers
>http://www.support.microsoft.com/?id=224071 Moving
SQL Server Databases
>to a New Location with Detach/Attach
>http://support.microsoft.com/?id=221465 Using
WITH MOVE in a
>Restore
>http://www.support.microsoft.com/?id=246133 How To
Transfer Logins and
>Passwords Between SQL Servers
>http://www.support.microsoft.com/?id=298897 Mapping
Logins & SIDs after a
>Restore
>http://www.dbmaint.com/SyncSqlLogins.asp Utility
to map logins to
>users
>http://www.support.microsoft.com/?id=168001 User
Logon and/or Permission
>Errors After Restoring Dump
>http://www.support.microsoft.com/?id=240872 How to
Resolve Permission
>Issues When a Database Is Moved Between SQL Servers
>http://www.sqlservercentral.com/scr...iptdetails.asp?
scriptid=599
>Restoring a .mdf
>http://www.support.microsoft.com/?id=307775 Disaster
Recovery Articles
>for SQL Server
>
>--
>Andrew J. Kelly
>SQL Server MVP
>
>"Jenny" <jyu@.iseoptions.com> wrote in message
> news:12b1301c3f63d$ecccf980$a501280a@.phx
.gbl...
another
this
Server
which I
>
>.
>