Interview Questions

1. What are Orphaned Users?

A database user for which the corresponding SQL Server login is undefined or is incorrectly defined on a server instance cannot log in to the instance. Such a user is said to be an orphaned user of the database on that server instance.

  • A database user can become orphaned if the corresponding SQL Server login is dropped.
  • A database user can become orphaned after a database is restored or attached to a different instance of SQL Server.
  • Orphaning can happen if the database user is mapped to a SID that is not present in the new server instance.

By Expert User 2 0
Is this helpful? Yes No

Submit an interview question

Submitted questions and answers are subject to review and editing, and may or may not be selected for posting, at the sole discretion of w3Sniff.

Get Started

Comments

Leave a Comment


Check out more interview questions

Based on your skills

MS SQL Server

2392771 1720 39 859

Angular

62415 92 0 46

Wordpress

52482 72 1 36