Questions tagged [azure-managed-database]
36 questions
2
votes
3 answers
Why can't I re-authenticate (MFA with mssql extension for VS Code)?
Here's an example of a connection configuration that has stopped working (it's for connecting to an Azure managed database):
{
"server": "sqldb.12345abcde.database.windows.net",
"database": "sqldb01",
"authenticationType": "AzureMFA",
…
benmcf
- 31
- 1
- 6
2
votes
1 answer
Delete "orphaned" SSIS catalog
Not sure I am referring to this correctly, but we seem to have an "orphaned" or rogue Integrated Service Catalog, SSISDB, with a database SSISDB on an azure managed instance
We were testing SSIS options a few months ago including creating it in data…
Amommy
- 47
- 1
- 8
2
votes
1 answer
How to copy managed database?
AFAIK there is no REST API providing this functionality directly. So, I am using restore for this (there are other ways but those don’t guarantee transactional consistency and are more complicated) via Create request.
Since it is not possible to…
robot40q
- 101
- 5
1
vote
0 answers
Unable to create Databases in Azure SQL Managed SQL
When running the create DB from the managed instance I get this message.
{
"status": "Failed",
"error": {
"code": "LinkedInvalidPropertyId",
"message": "Property id '' at path 'properties.recoverableDatabaseId' is invalid.…
Scott Elmore
- 21
- 1
1
vote
1 answer
Azure SQL DB - Scale Up - vCore Hyperscale or Azure Managed Instance?
We are currently using Azure SQL DB for our data warehouse project. Though it is an OLAP application, it has partial OLTP functionality as well. Our DB's current configuration is Basic, DTU based. Now the requirement is that the DB size may increase…
Iniyavan
- 61
- 1
- 5
1
vote
1 answer
Timing out while trying to connect to sql in Azure Managed Instance from Azure VM
I am trying to access tables in SQL database in Azure Managed Instance (with IP: xxxx.database.windows.net) from a python script in Azure VM machine but I am getting the Operational Error below. I have tried with 2 different ways…
scudarian
- 13
- 2
1
vote
1 answer
SQLCLR Assembly Much Faster When Unloaded
I have a SQLCLR assembly that does a simple JSON deserialization using the LitJson package on a SQL Azure Managed Instance. This CLR is called from a table-valued function that just returns the JSON properties as a table (in theory faster than the…
Jon
- 91
- 1
- 7
1
vote
0 answers
Azure managed instance connecting using ssh tunnelling
I am connecting to the Azure SQL managed instance using PUBLIC ENDPOINT by JDBC connection. It is connecting properly. I can able to read the data using JDBC.
But If I tried to connect the public endpoint of azure sql using SSH tunneling, I am…
SUBHASH V K
- 11
- 3
1
vote
1 answer
migrate "Azure sql server" data to "Azure managed instance"
What are different options to move database from "Azure sql server" to "Azure sql managed instance", Looks like below options are not possible 1) Azure migration service - Not supporting azure sql server as source 2) bacpac and use sqlpackage to…
Dyaneshwaran S
- 69
- 1
- 7
1
vote
1 answer
Azure Data Factory from VM SQL Server to File on FTP
This year We moved from hosted servers to Azure VM's, we run two production servers (SQL and IIS). A vital component of our business is bulk transfer of data file. We take customers data from our SQL Server and then write it out to a file (XLS,…
LarryG
- 627
- 1
- 6
- 14
1
vote
1 answer
Cannot bulk load. The file "csv" does not exist or you don't have file access rights -- Azure
I am trying to import a file from my Azure blob storage into Azure managed instance.
So first I created a extrenal data source
CREATE EXTERNAL DATA SOURCE MyAzureBlobStorage
WITH ( TYPE = BLOB_STORAGE,
LOCATION =…
Pரதீப்
- 91,748
- 19
- 131
- 172
1
vote
1 answer
Azure SQL Management instance - restore db different version
Actually we have Azure SQL Management instance I got a backup but I cannot restore our VM SQL Server owing this has a SQL Server version less SQL Azure (Azure Team updated SQL Server a couples week ago), so We cannot update QA Server to last SQL…
Carlos Bolivar
- 307
- 5
- 12
0
votes
1 answer
PowerShell to check available free space in Azure SQL Managed Instance
I am working on a PowerShell script to restore databases dynamically from the Azure storage account to Managed instance. To add additional functionality I am looking for a PowerShell module that can help me to find free space from managed instances…
Vinod Narwal
- 169
- 2
0
votes
1 answer
Run SQL query against Azure SQL managed Instance using PowerShell
My task is to execute Azure MI database SP using Powershell.
I am using connection string. I believe I am able to login to the SQLMI database using the connection string with PowerShell.
However, I am getting an error while running the SQL. Below is…
user112359
- 11
- 2
- 5
0
votes
1 answer
Elastic Job sp_add_jobstep returns "Cannot reference the credential because it does not exist or you do not have permission"
I'm pretty new to Azure (and SQL for that matter). I've been trying to configure Elastic Jobs Agent with a few specific jobs that would run queries against some of my databases on the server.
For right now I am targeting a test database where I want…
kontrago
- 5
- 2