Post reply

Problem in creating login

  • April 8, 2009 at 12:17 am

    #202660

    I have created database with user (sql server authentication). now when i shifted the database to other computer and trying to create the login for the user. it show error "User already exist in databse". how i can create login for user in database without deleting the existing user. Plz help

  • April 8, 2009 at 12:50 am

    #974032

    Create the login without adding any database access, then run sp_change_users_login with the Update_One option to link the existing database user to the new login.

    [font="Verdana"]Markus Bohse[/font]

  • April 8, 2009 at 1:20 am

    #974046

    Thanks it worked. :-):-):-):-)

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

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