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.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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment