Post reply

refresh dev server from prod: how to reconnect logins/users

  • August 27, 2004 at 9:12 am

    #112200

    All of our SQL is SQL 2000.  Most the refreshes I do for development teams are straight forward.  When I am done, I have a script that drops all logins/users and re-creates them. 

    I now have a development enviroment where that is not desireable.

    How do I match up the logins and userids after a refresh so the password does not change in the development enviroment?  This is a vendor/is driven combined application where the vendor has a user/pwd hard coded into the code.

     

    thanks for any help

    Joseph

  • August 27, 2004 at 9:57 am

    #520907

    add the logins to the dev db.

    the users will be there once you restore

    sp_change_users_login will synch them.

  • August 27, 2004 at 11:34 am

    #520926

    Thanks.  That did the trick.

     

    Joseph

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

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