Hello fellow DBAs-

  Before I get to the question here's my setup.

I'm using SQL Server 2000 and have a database TempDB that has the user login UserA. UserA is setup using Windows Authentication on ServerA (Name of Server). So under SQL Server Logins it displays as "ServerA\UserA". I backed up the TempDB database on ServerA.

Now here's my question. I now want to restore the TempDB database on ServerB. When restoring the TempDB database on ServerB, the User Login is restored only as "UserA" instead of "ServerB\UserA".
Is there any way to easily restore user logins accross servers/domains instead of having to create the User Logins from scratch?

The purpose of this example is if ServerA crashes and you need to restore the database TempDB onto ServerB, what is a quick way to restore logins if ServerA is not available anymore?

yes there is many ways of doing this. One note to take under consideration. You should not be using the tempdb to store any user information. The tempdb is rebuilt each and every time SQL Server is restarted, it is what it says it is "temporary database"

http://support.microsoft.com/default...-US;Q246133#3


Jaime E. Maccou
Applications Analyst