Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

refresh dev server from prod: how to reconnect logins/users Expand / Collapse
Author
Message
Posted Friday, August 27, 2004 9:12 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, June 6, 2012 6:49 AM
Points: 249, Visits: 140

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




Post #134259
Posted Friday, August 27, 2004 9:57 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 7:27 PM
Points: 33,204, Visits: 15,351
add the logins to the dev db.
the users will be there once you restore
sp_change_users_login will synch them.








Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #134268
Posted Friday, August 27, 2004 11:34 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, June 6, 2012 6:49 AM
Points: 249, Visits: 140

Thanks.  That did the trick.

 

Joseph




Post #134291
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse