Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Posts
    454

    Unanswered: login problem after restoring a database in SQL7

    Since the database server was removed to a new Windows Advanced Server 2000, I restored a database from the backup file. When I tried to create a new Login under Security, I got the following error message:

    Error 15023: User or role 'MyDatabaseLoginName' already exists in current database.

    But I checked it and it doesn't exist. I even could not create a system DSN without the Login. Someone told me to create a new one with another name, but I do not want to change the connection string in my ASP files. Does anyone has any idea about it? Thanks in advance.

  2. #2
    Join Date
    May 2003
    Location
    Parsippany NJ
    Posts
    36
    Did you try to fix it with this system stored proc, can be used in sql server login, should fit ur situation.

    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
  •