Skip to main content

SQL Server: "Error '15023' User or role already exists in the current database" when you perform restore database from backup

When you are restoring a Microsoft SQL Server database (.bak) from backup, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to allow necessary user permissions to the new database. This is puzzling enough since a database backup should bring us back to the original state. This is caused by Security Identification numbers (SID) that are mismatched or 'orphaned' in the sysusers table.

To resolve this problem, we need to make use of the SQL Server stored procedure sp_change_users_login.
--Run it with a single parameter 'Report' to get a listing of abandoned user names and corresponding SIDs
exec sp_change_users_login Report

--'Update_One' as 1st parameter will reconnect a single login
exec sp_change_users_login Update_One, 'MyLogin', 'MyLogin'

Popular Posts

Ho Ching named 5th most powerful and is mistaken as first lady by Forbes

Forbes named Singapore Prime Minister wife and CEO of Temasek Holdings, Ho Ching, as the 5th most powerful woman in the world. Ho Ching is mistaken as Singapore's first lady! OMG!

I wonder how can Forbes makes such a blunder. For a complete list, refer to here.

How to stop FortiClient from starting automatically?

Installed FortiClient recently but the challenge in disabling the application/service from running automatically on every start-up annoyed me. Attempt to stop 'FortiClient Service Scheduler' only return 'Parameter is incorrect' error message.

An article on Technet help solve my trouble. To stop FortiClient from starting automatically, try the following:
Shut down FortiClient from the system tray.
Run net stop fortishield on command prompt.
Run msconfig.
On msconfig, switch to the Services tab. Clear the FortiClient Service Scheduler check box and click Apply.Run services.msc on command prompt to open up show all available services.Look for FortiClient Service Scheduler. Switch Startup type to Manual.Restart your computer. FortiClient should not be running automatically the next time round. Hope it helps.
QET next week

My friend admitting to NTU this month had had their QET few days back and from them, their QET's format was straightforward and questions to me was simple. 2 close passages with some blanks for students to fill in and a 300 words essay to be written from many topics to choose from. Topics available to choose from are like "Why do you choose NTU?", "Describe one major recent event just happened in your country", "What do you want to do in the future?", etc. Very simple to write essay with 300 words limit. But then for NUS, it is a very different story. 1 close passage with many grammatical phrases underlined for you to edit and a 500 words essay to write. Before writing the essay, there will have 3 pre-reading topics for students to ponder and then a lengthy topic related article to read from. There is only ONE essay TOPIC to write on and it can be like "how your country's goverment can help reserve the originality of tourist spot…