Stack Overflow
Stack Overflow

Questions tagged [azure-sql-managed-instance]

258 questions
0
votes
1 answer

How to delegate a subnet for Azure SQL Managed Instance in Pulumi C#

The Pulumi doc Create subnet with a delegation is wrong (it did not set SubnetArgs.Delegations property). I tried to delegate subnet with following code: // // Managed Insatnce subnet must be delegated // var spokeManagedInstanceSubnet = new…
MD TAREQ HASSAN
  • 1,188
  • 20
  • 46
0
votes
1 answer

Granting Azure SQL MI -> AD read permissions fails with error 400, Invalid object identifier 'null' - any ideas?

I have a new Azure AD I've switched my subscription over to it I created a SQL Server managed instance I went to the SQL Server MI, and to the active directory admin section of the MI. I attempted to grant read permissions to the AD via the "click…
GilesDMiddleton
  • 2,279
  • 22
  • 31
0
votes
2 answers

Setting up a linked server on a Managed SQL Instance

On an Azure Managed SQL Instance that has been setup, I'm trying to setup some linked server connections. When I access these same databases through Management Studio while logged into this MI SQL Instance, I can access the databases I am wanting to…
MJGJr
  • 1
  • 4
0
votes
1 answer

Connection to Azure Managed server fails from .NET app but works when connection from the command line

I am trying to connect from an Azure virtual server (windows 10) to an Azure Managed SQL instance. From the command line on the virtual server I can connect to the managed SQL instance using: sqlcmd -S…
Columbo
  • 2,896
  • 7
  • 44
  • 54
0
votes
1 answer

Removing Azure SQL Managed Instance admin user

I would like to change the Azure SQL Managed Instance admin (this is not for the Active Directory Admin). I do not see any way to do this directly. I am guessing that if I create another sysadmin user, and then delete the current Managed Instance…
ppham
  • 17
  • 7
0
votes
1 answer

Copy data from Azure SQL Managed Instance DB to Azure SQL Server DB

We are needing to create a copy of all data that is on an Azure SQL Managed instance to an Azure SQL Server. The data will be updated/refreshed regularly. ideally some sort of job on a schedule would help as well but manual is fine. We just cannot…
Amommy
  • 47
  • 1
  • 8
0
votes
0 answers

SQL Agent Error 0xC0100037 - SSIS SQL Services Integration Services

It's been days that I get a SQL job error: Executed as user: DB8C0\WF-bFkfnwG44FCe3pF. Microsoft (R) SQL Server Execute Package Utility Version 15.0.2195.176 for 64-bit Copyright (C) 2019 Microsoft. All rights reserved. Started: 10:54:32 PM…
CRazensuar
  • 59
  • 2
0
votes
0 answers

SQL Managed Instance Making Connectivity Easier for Users

So we just switched to SQL Managed Instnace. As much as it pains me, we had more than a few places where untrained users were querying our production database(s). The switch to a business critical SQL Managed Instance was made partially because we…
Daniel Williams
  • 167
  • 1
  • 10
0
votes
1 answer

Azure SQL -- what is vCore actually

We are planning to create and Azure SQL Managed Instance. When we select Vcore based purchasing model, how is the CPU Physical Cores calculated. As per Microsoft docs: Gen5 logical CPUs are based on Intel® E5-2673 v4 (Broadwell) 2.3 GHz, Intel®…
Hillol Saha
  • 123
  • 1
  • 12
0
votes
1 answer

Fix or avoid SQL71501 and SQL71561 build errors in SSDT referencing master DB in Azure Managed Instance?

I'm converting an existing DB into SSDT project and getting a ton of these errors, despite having added the reference to master DB. They can't be ignored because they're errors, not warnings, so it won't build. Error SQL71501: View:…
Jane Dilbert
  • 13
  • 9
0
votes
1 answer

How to move dataset from Azure Managed Instance to Azure SQL using SSIS with change data capture

How to move data from Azure Managed Instance to Azure SQL Database by using SSIS package with Change data capture feature in it? Please help me with links or documents.
shubhi jain
  • 29
  • 3
0
votes
1 answer

Failed to grant "read" permissions to the Managed Instance

I create an azure managed instance, I want to set one account to active directory admin ,But I cannot grant "read" permission to the MI like below screenshot
Alex Wang
  • 103
  • 1
  • 10
0
votes
1 answer

Azure Sql managed instance database mail to external emails blocked due to "Relay Access Denied"

We have moved from ono-premise to Azure SQL Managed Instances for our database servers and cannot seem to get database mail to sent to external email addresses however it works correctly for internal (our domain) email addresses. The specific error…
hamish
  • 447
  • 1
  • 9
  • 19
0
votes
2 answers

Azure Managed Instance :: Why Extended Stored Procedure are listed?

I'm creating a security assessment for an Azure Managed Instance. The Vulnerability Assessment that I find on the Azure portal alerts me that there are 6 Extended Stored Procedure that could harm my Managed Instance: Strange... I taught that…
Francesco Mantovani
  • 10,216
  • 13
  • 73
  • 113
0
votes
2 answers

SQL Server creation failing on Azure due to policies in place

We are in the process of creating SQL Server using ARM Template but since there are policies in place we are unable to get SQL Server created following are the 2 policy exceptions: ##[error]Resource 'xxxxx' was disallowed by policy. Error Type:…
user42012
  • 722
  • 12
  • 33
1 2 3
…
17 18