Re: SQL 2000 on SBServer 2003

Have a look at these especially the first one.


http://support.microsoft.com/?id=240872 How to Resolve Permission Issues When a Database Is Moved Between SQL Servers
http://support.microsoft.com/?id=168001 User Logon and/or Permission Errors After Restoring Dump

http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
http://msdn2.microsoft.com/en-us/library/ms345408.aspx Moving system dbs 2005
http://www.databasejournal.com/features/mssql/article.php/3379901 Moving system DB's 2000
http://support.microsoft.com/?id=314546 Moving DB's between Servers
http://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.sqlservercentral.com/columnists/cBunch/movingyouruserswiththeirdatabases.asp Moving Users
http://support.microsoft.com/?id=246133 How To Transfer Logins and Passwords Between SQL Servers
http://support.microsoft.com/?id=298897 Mapping Logins & SIDs after a Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to users
http://support.microsoft.com/?id=168001 User Logon and/or Permission Errors After Restoring Dump
http://support.microsoft.com/?id=240872 How to Resolve Permission Issues When a Database Is Moved Between SQL Servers

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"mikev" <mikev@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:E896EAB5-90B8-44F5-8ACF-C944592BD812@xxxxxxxxxxxxxxxx
I restored a database to a new server. On the new server I can access the
database. When I go to a workstation I receive the error "user name does not
exist" any help is greatly appreciated.

.

Relevant Pages
Loading