Stack Overflow
Stack Overflow

Questions tagged [azure-sql-managed-instance]

258 questions
0
votes
1 answer

Azure Purview scan to SQL Managed Instance fails

I followed this tutorial from Azure team: Connect to and manage an `Azure SQL Managed Instance in Microsoft Purview. As shown in the image 1 below, the scan process successfully tested the connection. But later the scanning fails with the following…
nam
  • 21,967
  • 37
  • 158
  • 332
0
votes
1 answer

How to access Azure File Storage from SQL managed instance through SSIS packages

We plan to migrate the DB server from SQL VM to a managed instance. And previously the input files (csv) for the SSIS packages were kept in some drive location (like C: E:) since it was VM. But now we are moving to the managed instance and it is…
Ram
  • 527
  • 1
  • 4
  • 7
0
votes
1 answer

Update and delete queries are taking longer to run in Azure managed instance

I am in the process of migrating a data warehouse to Azure from our on premise solution. The nightly load process for the on premise solution takes between three and four hours to run depending on the incoming data. I am trying to move to an Azure…
Dave
  • 61
  • 6
0
votes
1 answer

How to set a metric condition in Azure SQL Managed Instance

My Azure SQL Managed Instance is showing the storage utilization chart as follows: And the Average Storage used metric is showing as follows: Goal: set a condition for the metric Storage Space used so that when the average space used exceeds 52k,…
nam
  • 21,967
  • 37
  • 158
  • 332
0
votes
0 answers

Azure SQL metric - Alert rule not working as expected

Question: Based on the following storage space statistics of my Azure SQL Managed Instance: What does the "storage space used (avg) 51.76k" (shown at the bottom of the image1 below) represent the value 51.76k relates to which value in the stats…
nam
  • 21,967
  • 37
  • 158
  • 332
0
votes
1 answer

Trusted Connection to SQL Managed Instance from Azure Active Directory Domain Services

When connecting a .net application to a local database we have always used a trusted connection connection string. We are porting our platform over to Azure with: Apps on Virtual Machines Azure Domain Services Sql Managed Instance We have multiple…
Charle Lang
  • 11
  • 2
0
votes
0 answers

DENY ALTER ANY DATABASE DDL TRIGGER TO testLogin

We are trying to DENY the ALTER ANY DATABASE DDL TRIGGER permission to a login. This permission is listed in this Microsoft Doc. But a testLogin that is also a user in one database, and has ALTER TABLE permission on TestTable, can still create a…
nam
  • 21,967
  • 37
  • 158
  • 332
0
votes
2 answers

How to correctly configure an outgoing SQL connection WITH TLS under ZATO?

I'm using zato esb for a personal project/experiment and had success when creating and querying SQL databases via de outgoing->SQL connection (with no TLS encryption....) However I'm trying to get a managed MSSQL hosted on azure to work and can't…
Alex
  • 13
  • 5
0
votes
1 answer

Max text Repl Size equivalent quey in Azure Sql Database

We are trying to execute the below statement in Azure SQL Database. Is there any workaround this or equivalent query for Azure SQL Database. EXEC sp_configure 'show advanced options',1 RECONFIGURE WITH OVERRIDE EXEC sp_configure 'max text repl size…
Ravi 1001
  • 25
  • 4
0
votes
1 answer

Azure SQL Managed Instance: RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3201)

I'm trying to restore my database into Azure SQL Managed instance from blob storage URL. But I'm getting below error. RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3201) I tried to restore it to localhost and that…
Sandesh A D
  • 162
  • 2
  • 12
0
votes
0 answers

Database migration from Sybase ASE to Azure SQL managed instance

We planned to migrate Sybase ASE database to Azure SQL managed instance. Our source Sybase database collation is Binary as like below Character Set = 1, iso_1 ISO 8859-1 (Latin-1) - Western European 8-bit character set. Sort Order = 50,…
Yuvaraj
  • 1
0
votes
2 answers

Manage read scale-out setting in Azure Portal

I'm trying to see the current setting for read-scale out in the Azure Portal. The document says: You can manage the read scale-out setting on the Configure database blade. I'm unable to find any "Configure" option in the menu on the left in the…
David Klempfner
  • 8,700
  • 20
  • 73
  • 153
0
votes
1 answer

ManagedIdentityCredential authentication unavailable. No Managed Identity endpoint found

we have a nightly process (all running on Azure VMs) which is largely a collection of powershell scripts to update DBs in our TEST environment. Quite frequently we hit issues like below. We have around 25 DBs to update and at some random point in…
Tony Campney
  • 205
  • 1
  • 3
  • 7
0
votes
1 answer

Azure PaaS Databases - SQL DB vs Managed Instance

I am working on both PaaS databases of Azure, i.e., Azure SQL Database and Azure SQL Managed Instance. Basic doubt is that both are 'managed' by Azure. Then why the word 'managed' is attached only to the Azure Managed Instance? Either it should be…
Iniyavan
  • 61
  • 1
  • 5
0
votes
1 answer

Import Data-Tier Application vs sqlpackage.exe

We are now encountering an error with an automated process when attempting to restore a .BACPAC file using the sqlpackage utility but are successful when importing the same file using the "Import Data-Tier Application" wizard through SSMS. The error…
Cza102282
  • 33
  • 6
1 2 3
…
17 18