Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2002
    Posts
    9

    Unanswered: Is it possible to import users logins when u restore a DB?

    Im abit puzzled here and im looking to see if there is any easy solution

    Case:

    Have Backed up an DP, then Restored it on another computer.

    Then all users will be in the system (Not visible to users, but in sys info)

    OK!

    Then I set up all LOGINS...

    After all this procedure is completed I use the sp_change_users_login Update_One function....

    Question:

    Cant I just import or other way use old logins/users

    (I know this msg might sound weird, but hehe I hope someone knows what I mean..)

    Thx!

  2. #2
    Join Date
    Feb 2002
    Location
    North Wales, UK
    Posts
    114
    As far as I know there isn't since the logins are stored in the master database. Unless in your scenario you can backup the master database and restore it on the other computer after doing the same for your database.

    This worked for me when upgrading from SQL 7 to SQL 2K.
    J^ - web | email
    newsASP Developer

  3. #3
    Join Date
    Feb 2002
    Posts
    9
    oh!

    Many thanks, I will try that one

  4. #4
    Join Date
    Feb 2002
    Location
    S.E. London
    Posts
    5
    You can use command line utility bcp to copy the master..syslogins table
    out of server1 and then bcp it back in to server2. Make sure you use
    -c option as this will allow you to edit the output since you will need to
    remove any entries which already exist in server2 (eg. "sa") in order
    to prevent it falling over with duplicate key errors.

    Type bcp on command line to get full list of options.

  5. #5
    Join Date
    Mar 2002
    Posts
    2

    Angry

    2Scre@m
    Sorry, but I think that guys were wrong.
    Read this
    http://support.microsoft.com/directo...;EN-US;Q298897
    and other links from it.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •