Return
-
Title
Cannot integrate Intrust with SaaS Azure SQL Enviroment -
Description
When attempting to create an Intrust Organization and creating the Database(s) in Microsoft Azure, the following error is thrown:
USE statement is not supported to switch between databases. Use a new connection to connect to a different database. -
Cause
The regular Azure subscription to use SQL-Services does indeed not allow the USE statement to prevent one customer from accessing other customer's databases that are hosted independently on different servers to allow for Azure-internal failover services. -
Resolution
SQL Azure Managed Instance supports use database as a command because all of the databases in that model are on the same SQL instance – just like SQL Server. It is therefore recommended that you consider Managed Instance for migrations from on-premises SQL Server where you can not/do not wish to modify behavior to fit within a single SQL Azure DB. -
Additional Information
https://feedback.azure.com/forums/217321-sql-database/suggestions/14822082-allow-the-use-statement-to-switch-between-database