Post reply

users not appearing when database moved to a new server

  • April 5, 2004 at 2:35 pm

    #82488

     I have a backup of a database.I have created this in a new server.I have moved the logins using sp_help_revlogin. My problem is , the users for this database are not appearing in the new server. I am lookign at the EM  and I can see all the logins but no users for the database. Could anybody help me please?

  • April 5, 2004 at 2:46 pm

    #501806

    If the login already exist on the new server, you could do:

    EXEC sp_change_users_login 'Update_One', 'Mary', 'NewMary'

    at the current database, and your user will start appearing one by one.

     

     

    mom

  • April 5, 2004 at 3:06 pm

    #501808

    Hi,

    When I did the sp_change_users_login it gave me this error message

    Server: Msg 15291, Level 16, State 1, Procedure sp_change_users_login, Line 87

    Terminating this procedure. The User name 'sree' is absent or invalid.

    I just found out that all the users went to my master database. where did I go wrong?

     

     

  • April 5, 2004 at 3:25 pm

    #501810

    I think I found out the answer myself. I had created  generate sql server users and role permissions by generating the s

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

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