Questions tagged [azure-sql-managed-instance]
258 questions
0
votes
1 answer
BULK INSERT into Managed Instance from a file in Azure Files?
How can I use BULK INSERT to load files that are in Azure Files, from a Managed Instance? Everything I can find talks about Azure Blob storage, but I've got an old Perl script that we don't want to modify that grabs the file currently. Our options…
mbourgon
- 1,286
- 2
- 17
- 35
0
votes
1 answer
Insert through Linked Server from Azure VM to Managed Instance - fails when app runs it, succeeds when I run it in SSMS
I am trying to insert into a table from an on-prem app, through a SQL Server 2019 instance running in a Azure VM (Windows), that has a linked server to an Azure Managed Instance. Due to , we can't connect to Managed…
mbourgon
- 1,286
- 2
- 17
- 35
0
votes
0 answers
Creating a db in a managed instance with containment "partial" makes a non contained database
When I run the following code on SQL Server (docker) it makes the db as contained first time around, but in a SQL managed instance it creates it as a "none" contained db, the subsequent ALTER is required to fix that.
if db_id('test11') is not null…
Nisar Yaqoob
- 49
- 4
0
votes
2 answers
Azure SQL database vs Azure SQL Managed Instance
I want to understand the difference between Azure SQL database and Azure SQL Managed Instance. On a brief level, I understood that Azure SQL managed instance is to be used when we need compatibility with on prem SQL database, but didnt get any good…
user961
- 453
- 6
- 20
0
votes
0 answers
What is SQL Server wait type TRANLOGIO?
I am using analytics on an Azure Managed SQL instance, and have noticed a query whose performance has dropped markedly apparently to an increase in "TRANLOGIO" wait type.
However, I can find no documentation about what that wait type actually is. A…
Neil Moss
- 6,598
- 2
- 26
- 42
0
votes
2 answers
Cannot Create Contained Database on Azure SQL Managed Instance
In my Azure SQL Managed Instance, I'm unable to create CONTAINED databases and use ordinary logins and passwords with them (not Azure AD users).
In SSMS > New Database > Options, the Containment type option is grayed out.
If I create a database with…
Emperor Eto
- 2,456
- 2
- 18
- 32
0
votes
1 answer
How to create a linked server in Azure SQL MI to connect IBM AS400 i series
I want to fetch some data from AS400(IBM i series) from Azure sql Managed Instance. Currentlty I am not finding any solution to do that. Please suggest if there is any way to do this.
please help me getting the information to connect to IBM i series…
Asutosh Nayak
- 1
- 1
0
votes
1 answer
Calling HTTP API endpoint in Azure Managed SQL
I am in the process of integrating SendGrid APIs with Azure Managed SQL and I am facing the below issue.
I am required to send an email via the SendMail() API and get the response back to SQL Server.
Since I am using SQL Managed instance, I cannot…
Harsha W
- 3,162
- 5
- 43
- 77
0
votes
0 answers
Azure MI SQL Agent cannot use Linked Server
BACKGROUND
I have created a Linked Server on an Azure Managed Instance and secured it to specific logins only.
I have a SQL Agent job that wants to use the Linked Server.
QUESTION
How do I grant the Azure MI SQL Agent execution account the…
Peter E
- 1
0
votes
2 answers
Azure SQL database with MFA login to connect from Azure ADF
I have an Azure SQL server and database which have MFA login and I am the admin. But when I try to establish a connection via a new linked service from ADF to this database using System Managed Identity option, it throws error -
"Cannot connect to…
Manoj Srivastava
- 3
- 2
0
votes
1 answer
Unable to connect to Azure SQL MI from dotnet web application using Authentication=Active Directory Managed Identity
I have an ASP.NET web application running on prem windows server. We need to connect to an Azure SQL MI from the C# code. I tried as below example code:
string ConnectionString1 = @"Server=demo.database.windows.net; Authentication=Active Directory…
Xavier
- 1,672
- 5
- 27
- 46
0
votes
1 answer
Azure Sql Managed Instance not using non cluster index of table after some time
Recently we have migrated from On-prem hosting to Azure hosting, and migrated our Sql Server to Azure SQL Managed Instance.
We have a huge table having close to 1 billion records and it has a non-cluster index. When we rebuild index or update…
Ranjit Singh
- 3,715
- 1
- 21
- 35
0
votes
1 answer
Azure SQL Managed Instance and Azure Active Directory Authentication
Question: In Azure SQL Managed Instance, what is the procedure for setting Password Expiration when using Azure Active Directory (AAD) Authentication? As shown below, in SSMS, I see Password Expiration option is grayed out:
nam
- 21,967
- 37
- 158
- 332
0
votes
1 answer
Link for SQL MI as DR
Can i use preview feature link for SQL MI as DR site (database) for on-prem SQL Server instance?.We don't want to use the SQL MI for reporting purpose. If the answer is yes, if i failover to SQL MI database as primary in case of DR, when original…
Suresh
- 9
- 3
0
votes
0 answers
How to connect/Load data to a SQL database inside the Azure Managed Instance via SSIS
I can successfully connect my "Azure managed instance" in my local SSMS. But not sure how to load data into the database via SSIS.
Is there any supporting component to use for loading data into Azure managed instance from ON-Perm SSIS packages. Note…
Gowtham Ramamoorthy
- 896
- 4
- 15
- 36