Restoring SQL Userids

  • Not sure if this is the proper group for this message...

    I am restoring a SQL Server 2000 database to another server, which works fine except for migration of the database users.  The users do exist in the database but not in the master security system.

    How do I get all my users into the master security system?

    Thanks for any and all comments/help/suggestions.

    Russ...

  • This MS article describes a tried and true way to transfer logins and associate them with database users.  I've used it many times when moving databases to new servers.

    Greg

    http://support.microsoft.com/kb/246133/en-us

    Greg

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply