Administrators might want to convert their Microsoft SQL Server workspace from non-contained to contained, allowing authentication to travel with the database instead of being managed at the server level.
A proper workspace backup strategy should be implemented to prevent possible data loss.
Configure your SQL Server to allow contained databases:
Should the last command return an error message, use the sp_who2 command to find the SPID of the open connections.
Create an administrator user for the SQL database:
Back in Remote Desktop Manager, in the General tab of your workspace, change the type to Microsoft Azure SQL, and set a Username and Password. Click Save.
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.
Then, tick the Contained database user (recommended) checkbox every time you create a new user for this workspace.
Share your feedback