Home Forums SQL Server 2005 SQL Server 2005 Compact Edition How to transfer the logins and the passwords between instances of SQL Server 2005 and SQL Server 2008 RE: How to transfer the logins and the passwords between instances of SQL Server 2005 and SQL Server 2008

  • You need to go into each database and use the ALTER USER command on each user that is affected, in order to associate it with the login on the new server. From memory, the command is something like this:

    ALTER USER [MyDomain\MyAccount] WITH LOGIN [MyDomain\MyAccount]

    John