Questions tagged [azure-sql-managed-instance]
258 questions
0
votes
1 answer
Challenges with Azure SQL Managed Instance
Unable to make a copy of the database using the following SQL command or through the Azure portal
CREATE DATABASE mydatabase_copy AS COPY OF mydatabase;
Unable to make a copy of the database on Azure SQL Server, no wizard is present
we know…
Akash Samal
- 87
- 1
- 9
0
votes
1 answer
Maintenance tasks on Azure SQL Managed instance
I have 4 SQL managed instances and have some custom task defined on SQL Managment Studio. On azure I found that the managed instance have a Maintenance Window:
My question is.. What kind of tasks are performed in the Azure maintenance window?
I…
Van Darth Vadden
- 561
- 1
- 5
- 11
0
votes
2 answers
Can I disable a Vulnerability Scan rule for Azure SQL Managed Instance?
I have a Azure SQL Managed instance with active vulnerability scan assessment routines. And everytime it gives me VA2129 - Changes to signed modules should be authorized. I have baselined it quite a number of times but this one has become…
S.Ali
- 29
- 4
0
votes
1 answer
Can not compare Azure database in Visual studio 2022 schema compare
I'm trying to compare the Azure SQL Managed instance to my local database project. But when I make a selection of the database "Ok" button is not getting enabled.
This used to work a month ago but all of a sudden it stopped working.
It's an issue…
Sachin jeev
- 201
- 4
- 14
0
votes
0 answers
Database Migration Assistant not detecting deprecated features
The documentation for Database Migration Assistant claims that it will identify and flag any "deprecated features". However, this does not seem to be true in the least. I have a SQL Server on-premises database full of features that Microsoft's…
Pittsburgh DBA
- 6,672
- 2
- 39
- 68
0
votes
0 answers
SQL bulk insert csv with currency sign separator ¤
I have a .csv file with a currency sign field separator (¤), when I execute this query to bulk load it to a table it raise an error.
The file is UTF-8 encoded.
BULK INSERT dbo.test
FROM 'file.csv'
WITH (DATA_SOURCE = 'MyAzureBlobStorage',
…
SniperPro
- 75
- 1
- 10
0
votes
1 answer
Azure SQL MI: The requested server principal already exists on Managed Instance
In my SQL MI i have a ad group (called Group A) which was already assigned to the Active Directory Admin through Portal. I'm trying to update/replace that with a new group called Group B.
When I tried I get the error…
Jayendran
- 9,638
- 8
- 60
- 103
0
votes
1 answer
Changing Max Job History setting on Azure SQL Managed Instance
We are running Azure SQL Managed Instance 2019 and need to change the max job history settings in SQL Server agent.
On a non-Azure-hosted SQL Server, it can be done by going to SQL Server Agent Properties, the History tab.
But, this tab is not…
user1044169
- 2,686
- 6
- 35
- 64
0
votes
1 answer
Why Does Azure Require Write Permission On Source SQL Instance During Point In Time Restore?
I am trying to clone a SQL database from a managed instance to another managed instance. And I am using Point In Time Restore to do so. The identity used to perform this action has "Reader" role for the instance of source database and "Contributor"…
John L.
- 1,825
- 5
- 18
- 45
0
votes
1 answer
"Assign an Azure AD identity to your server and add Directory Reader permission to your identity" - Error
I am writing a little thing in YAML to assign permissions to a newly built SQL Server.
az account set --subscription $(SubscriptionId)
Install-Module -Name SqlServer -Force
$sqlCmd = "CREATE LOGIN [Users-PreProd2] FROM EXTERNAL…
Jason_Hough
- 392
- 5
- 31
0
votes
1 answer
Error while creating linked server in Azure Sql MI
I am migrating on-prem sql to Azure SQL MI. In the migration, I need some tables from on-prem for development. I am trying to link SQL server installed in Azure VM. But I am getting error -
I have added firewall rule to allow the traffic from SqlMI…
Rohi_Dev_1.0
- 372
- 1
- 2
- 19
0
votes
1 answer
Azure SQL Managed Instance Connection in Virtual Machine
We have setup where our applications are hosted in Azure Virtual Machine, and our Databases are hosted in SQL Managed instance. Both are in same region, same subscriptions, but different Vnet as is the requirement of SQL Managed Instance.
We have…
Neelam
- 1,028
- 12
- 25
0
votes
1 answer
Connect to Azure Sql Managed Instance from on-premise SSMS
I am new to Azure. I am currently trying to migrate the on-premise databases to Azure Sql Managed Instance. I created the resources in Azure. I now like to connect to the database that I created from my on-premise Sql client from the organization…
Ashan
- 13
- 5
0
votes
1 answer
Associate static FQDN with Azure Managed Instance
I have a Azure managed instance that has a host name as yourdb..database.windows.net . I Whenever this managed instance is newly created I have to update this host name in every connection string.
Is there a way which allows to have a…
S.Ali
- 29
- 4
0
votes
1 answer
Managed Instance deployment failed due to error related to preparation of network intent policy
Following Pulumi doc Create managed instance with all properties and trying to create Managed Instance with code below:
//
// spokeManagedInstanceSubnet -> delegated to "Microsoft.Sql/managedInstances"
// spokeManagedInstanceSubnet -> does not have…
MD TAREQ HASSAN
- 1,188
- 20
- 46