1. Home
  2. Cloud & Dedicated Servers
  3. MS SQL
  4. How to drop orphaned SQL Server users

How to drop orphaned SQL Server users

 

Summary

When you restore a Microsoft SQL Server database on a different machine, you cannot access the database until you fix the permissions.


Detail

The problem is that the user in the database is an "orphan". This means that there is no login id or password associated with the user. 

All of these instructions can be done via SQL Server Management Studio, with the restored database selected.

If you you want to remove the user from the database, fix it by doing the query below:

 	DROP USER user_name
 This will drop the user from the database so that you will no longer receive the orphaned user message.
   

Content retrieved from: https://support.appliedi.net/kb/a307/how-to-drop-orphaned-sql-server-users.aspx.

Updated on November 11, 2019

Was this article helpful?

Related Articles

Need Support?
Can't find the answer you're looking for? Don't worry we're here to help!
CONTACT SUPPORT

Leave a Comment