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

    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
    Parsippany NJ
    Did you try to fix it with this system stored proc, can be used in sql server login, should fit ur situation.


Posting Permissions

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