Cannot integrate Intrust with SaaS Azure SQL Enviroment (4318116)

Tchater maintenant avec le support

Retour

Commentaire envoyé

Cet article vous a-t-il à résoudre un problème ?

Sélectionner une évaluation

Titre

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.
Résolution

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.
Informations supplémentaires

https://feedback.azure.com/forums/217321-sql-database/suggestions/14822082-allow-the-use-statement-to-switch-between-database

Commentaire envoyé

Cet article vous a-t-il à résoudre un problème ?

Sélectionner une évaluation

Contenu recommandé

Historique de l’article :: Créé le : 4/14/2021
Dernière mise à jour le : 1/25/2024

Titre