Post reply

SQL 2008R2 to 2008 R2 login/password migration

  • March 28, 2014 at 2:37 pm

    #283952

    Hello,

    I copied a database from SQL 2008R2 to another 2008 R2 server, then scripted SQL logins and created them in new server , however can't login to the new server. These are not windows logins, but SQL logins.

    how to we synch the login/password, so users can logon to new server?

    TIA,

    Nasir

  • March 28, 2014 at 2:52 pm

    #1701322

    If you copied the database files over before the sql logins it will break the login connection to the DB. You basically have to re-initialize the logins. There are a few scripts out there that will do that for you. If you create the logins before you migrate the DB's, you should be fine.

  • March 28, 2014 at 2:53 pm

    #1701323

    Take a look at this, I believe this might fix your problem,

    http://qa.sqlservercentral.com/scripts/users/69523/[/url]

  • March 28, 2014 at 2:53 pm

    #1701324

    Read this article. It generates the create login statements and includes their password as a hashed value.

    http://support.microsoft.com/kb/918992

Viewing 4 posts - 1 through 3 (of 3 total)

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