Results 1 to 2 of 2
  1. #1
    Join Date
    May 2002
    Location
    Brisbane, Australia
    Posts
    13

    Unanswered: Logins some help plz

    I have database called 'sco' it has the following users
    + sco_admin
    + sco_publish
    + sco_default
    + sco_config

    I had to rebuild the machine this database was running on, and I have attached the db back now I need to make the logins again, however when i try and make a SQL login 'sco_admin' and give it access to 'sco' it says "user 'sco_admin' already exists". Which of course it does. I don't want to delete all the users and reset all the permissions.

    So how do I associate SQL Login 'sco_admin' with DB User 'sco_admin'?

    I had a look at the help but couldn't make much sense of what I was reading.

    Also is there a way to keep the SQL Logins intact with the database??

    Thanks In Advance,

    Nicholas Orr

  2. #2
    Join Date
    May 2002
    Location
    Brisbane, Australia
    Posts
    13
    Solved you have to use

    sp_change_users_login

Posting Permissions

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