---
title: "Remap Cloud Sites MSSQL Users"
source: "https://docs.nexcess.com/hosting/cloud-sites/database-management/mssql/remap-cloud-sites-mssql-users/"
description: "Remap the server-level logins on Microsoft SQL Server database users on Cloud Sites."
vertical: "Hosting"
date: "2024-03-04"
last_modified: "2026-08-14"
---

# Remap Cloud Sites MSSQL Users

Microsoft SQL Server has two logical layers of security.

- The term login refers to the account at the server level.
- The term user refers to the account that exists inside the database.

When you restore a database from one server to another server, you effectively sever the mapping between the server-level login and the database-level user. All databases have a single owner that is assigned to a server-level login. That special owner login is mapped to a special database user called dbo. The owner login account and password is the primary administrative account for your database.

You might need to re-establish the mappings between the server-level logins and the database users for the new database to be accessible. Your new server-level logins are found in your Cloud Sites Cloud control panel under your MSSQL 2014 Database.

| ### **Note:** |
|---|
| For additional login to user mappings that are not the special owner account, you can use the following command: ``` ALTER USER [123456_olduser] WITH LOGIN = [123456_newlogin] ``` |

## Remap database users to logins

1. To manage your [SQL Server database](https://www.liquidweb.com/sql-server-hosting/), log in to the online manager ([myLittleAdmin](https://www.liquidweb.com/help-docs/logging-into-mylittleadmin-from-cloud-sites/)).  
    ![mylittleadmin home page](https://docs.nexcess.com/wp-content/uploads/2026/06/help.liquidweb.com_qA6ADM.png)
2. Click **Tools** to open the menu and select **New Query**.  
    ![tools link](https://docs.nexcess.com/wp-content/uploads/2026/06/help.liquidweb.com_A2Da7v.png)
3. Enter the following command to reassign ownership to the new login that you created in the control panel (the brackets are required). Replace your database name and login name. ```
    ALTER AUTHORIZATION
    ON Database::[123456_database]
    TO [123456_login]
    ```
    
    ![new query entry](https://docs.nexcess.com/wp-content/uploads/2026/06/help.liquidweb.com_nAiDpA.png)
4. Verify that the command worked by going to your database and viewing the properties.
5. The login should now be listed as the new owner.