Previous page | Next page | Locate page |

### Recovering Orphaned Database Users

If you are restoring MS SQL database, there is a possibility that some database users will be orphaned. In order to provide the ability to access and use the database for these users, you need to repair them.

To check if a database has orphaned users:

1. Go to domain name > Databases > database name.
2. If you see a warning saying that there are several orphaned users that should be repaired in order to function properly, you have orphaned users who need to be repaired.

To repair orphaned users:

1. Go to domain name > Databases > database name and click Repair now button corresponding to the orphaned user you want to repair.
2. Provide a password for this user and click Repair.

   If a user is supposed to be a sysuser without a password, run repair with empty password field.

3. Repeat steps 1-2 as necessary to repair all orphaned users.