Convert Microsoft SQL Server data source to contained

On this page

Administrators might want to convert their Microsoft SQL Server data source from non-contained to contained, allowing authentication to travel with the database instead of being managed at the server level.

A proper data source backup strategy should be implemented to prevent possible data loss.

Steps

  1. Configure your SQL Server to allow contained databases:

Set database containment to partial
Set database containment to partial

Should the last command return an error message, use the sp_who2 command to find the SPID of the open connections.

  1. Create an administrator user for the SQL database:

Create your first administrator user
Create your first administrator user

  1. Back in Remote Desktop Manager, in the General tab of your data source, change the type to Microsoft Azure SQL, and set a Username and Password. Click Save.

Switching type to Microsoft Azure SQL
Switching type to Microsoft Azure SQL

  1. Go to the Advanced tab, click on More settings, and set the Encrypt setting’s value to false. Click Ok to close the window, then Save the modification.

Disable encryption
Disable encryption

  1. Then, tick the Contained database user (recommended) checkbox every time you create a new user for this data source.

Create a new contained user
Create a new contained user
Devolutions Forum logo Give us Feedback