Questions tagged [azure-sql]
Azure SQL Database is a general-purpose relational database-as-a-service (DBaaS) based on the latest stable version of Microsoft SQL Server Database Engine.
105 questions
1 vote
1 answer
261 views
How can I connect from a windows service to an Azure Managed Instance with Integrated Authentication
We use Azure Managed Instance for our databases. Alongside this, we have applications servers who run our software, also in Azure and connected to the domain. Each environment consists of a Windows ...
0 votes
0 answers
336 views
Azure SQL Managed Instance Windows Authentication
I am looking to migrate from Azure SQL VMs to Azure SQL Managed Instance and I had a few questions related to integrating this with an on-premises Windows Active Directory domain. We have some legacy ...
- 101
1 vote
1 answer
46 views
Restrict monitoring scope on Azure for Grafana
I'm trying to monitor Azure resources (mainly managed SQL servers) through The Azure monitor Grafana plug-in. It works if I assign Monitor Reader permissions on the subscription scope to the grafana ...
- 133
0 votes
0 answers
68 views
SSL Error connecting to Azure SQL
A connection was successfully established with the server, but then an error occurred during the pre-login handshake I am getting this error when testing from SSMS and also from linked servers and ...
0 votes
1 answer
116 views
How do I create a new login on an Azure SQL Database?
I'm trying to install SonarQube on Azure, using an Azure SQL Database, which is a serverless database. Instructions I have found advise me to run these commands from the query editor: -- On master ...
- 503
0 votes
0 answers
123 views
Azure SQL Datasync IP address
We have to sync 2 SQL servers located in different clouds under the different tenants. One in Azure global cloud and another one is in Azure China. I've created a sync group in global cloud, added ...
0 votes
1 answer
199 views
Diagnosing ASP.NET Core SQL Azure sporadic performance
I have an ASP.NET Core 6 application using EF Core and SQL Azure 'Business Critical' pricing tier with 2 VCPUs. 90% of the time the application is lightning fast, but occasionally throughout the day, ...
- 101
0 votes
1 answer
1k views
Azure SQL Elastic Pool max size lower than max size of database included in pool
I am trying to save some money by utilizing Azure SQL Elastic Pools. I have a bunch of databases which only peak in usage once a while, so having them in a pool would be optimal. The problem now is ...
- 1
2 votes
1 answer
522 views
On Azure, how do I find the ip address of an app service to create a firewall rule for it on Azure SQL?
I have created an Azure SQL server, setting 'Allow Azure services and resources to access this server' to no. I have a. ASP.Net application running as an App Service and I want to allow it to access a ...
- 171
0 votes
0 answers
113 views
How to configure Azure Data Factory to handle larger files?
I have an azure data factory pipeline that reads a 100 mb CSV from blob storage and inserts it into an Azure SQL DB that has tons of space (200 GB). I also have a 1 MB version of the same files, just ...
- 1
-5 votes
2 answers
306 views
Troubleshooting corporate DNS
I'm on a corporate network with various mysterious lockdowns including ZScaler My current issue is that when I try to connect to xyz.databases.windows.net (Azure SQL database) I see these symptoms: ...
- 193
1 vote
1 answer
167 views
Restore an Azure SQL database while retaining backups
I'm trying to figure out how to restore a database using the Azure Portal without losing either point-in-time or long-term retention history. My production database has both a point-in-time and a ...
- 13
0 votes
1 answer
142 views
Why are my Azure VMs briefly unable to connect to an AZure Managed Instance?
I have a bunch of load-balanced Azure VMs running Windows Server 2019 that are running IIS with ASP.NET MVC/Web API 2 applications running on them. They communicate with a Database in a SQL Server ...
- 113
0 votes
1 answer
1k views
How do I calculate how many eDTU I need?
I currently have four on-premise SQL Server instances (all replicated) each with between 3 and 5 production databases in them which I want to migrate to a single Azure SQL elastic pool. How do I ...
- 319
0 votes
0 answers
228 views
mysqldump restore with poor performance
we need to migrate our platform from an on premise location to azure cloud. In this context, we need to take a mysqldump from our mariadb on premise server and inject it to an azure mariadb managed ...
- 185
3 votes
1 answer
4k views
How to tell what is accessing my Azure SQL Server?
I have a legacy Azure SQL Server that I want to decommission but we have a LOT of legacy systems that no one knows about. I want to confirm what accesses this server and/or its databases. It doesn't ...
- 175
-1 votes
1 answer
1k views
Azure Security Alert - Login from an unusual data center
Azure Security Center generates an alert for a SQL Database that someone authenticated from an "unusual datacenter". Provided IP is Microsoft owned. Hostname is nothing recognizable.
- 169
0 votes
1 answer
1k views
Azure sql server read only replica
we have a database which is a SQL server PaaS offering, I would like to create a read only replica database which has a dedicated server behind it. The reason behind this is that I do not want to use ...
- 101
2 votes
1 answer
1k views
Azure SQL Elastic Pool: increase data size max GB with no downtime
We have an Azure SQL elastic pool with a data size max GB setting. We would like to increase this setting to a larger value. The question is: can you increase the size of the elastic pool max size ...
- 569
0 votes
1 answer
358 views
Will there be data loss in Azure Cosmos DB with multi-region write if one of the regions fails (outages)?
I use Azure Cosmos DB with multi-region write in two regions and I need to know what will happen if one of this regions fails (outages). Will it be data loss and if, yes, how much time will it take to ...
0 votes
1 answer
1k views
Azure App Service to SQL Server DB connection fails with generic "error occurred during the login process"
I have a project consisting of several frontend and backend apps, and several databases; I am in the process of building the deployment pipeline. It should use Azure Static App Services for the ...
- 1
0 votes
1 answer
211 views
How to route Azure MSSQL queries over vnet
I've got a vnet in Azure with a private endpoint connection configured for A MSSQL server. There's a private DNS zone configured with an A record for the private endpoint connection. App Services ...
- 145
0 votes
1 answer
513 views
Azure SQL Private Endpoint - can creating one cause downtime?
Suppose I have an Azure SQL Database Elastic Pool and I am accessing it from an Azure Web App via Firewall rules and everything is working fine. Now suppose I want to add a new Private Endpoint to the ...
- 569
0 votes
1 answer
717 views
sp_send_dbmail succeding but sometimes failing
Also posted in Stack Overflow. Any feed back would be much appreciated. I have a need for a SQL job to send multiple emails, and I have come across this error that I am unable to find any solutions ...
- 1
1 vote
1 answer
700 views
Azure Serverless SQL will not pause due to Azure service queries keeping it online
There is a database we use for archiving old data which I want to be 'serverless' so that it only fires up when we make a query. I changed the size from standard to serverless without issues. I have ...
- 415
0 votes
1 answer
183 views
Error code ElasticPoolOverStorageUsage
I'm trying to create a new database in our Azure SQL elastic pool and getting the following error code. Error code: ElasticPoolOverStorageUsage. We have a total space of 32GB and based on the ...
- 1
0 votes
1 answer
560 views
authenticate ASP.Net App on Azure WS2019 against Azure SQL via AAD - Access token could not be acquired No mapping between account names and securi
I try to reconfigure our ASP.Net app with .Net Framework 4.7.2 from SQL username/password Auth. to token based Azure Active Directory Authentication by using the system assigned managed identity of ...
- 1
0 votes
1 answer
4k views
Connection error related to sql azure database instance
I use the azure sql database service, I try to connect to the server where I have hosted the database and in a specific network I can not connect, however, from other wifi networks if I can connect. ...
-1 votes
1 answer
93 views
What additional role should I provision in an Azure resource group so that a contributor can see/accept/fix Azure SQL security recomendations?
We are receiving security recommendations for one of our Azure SQL databases. I'm owner of the subscription and can see those recommendations in the Azure SQL Security Center. I would like to delegate ...
- 155
-1 votes
1 answer
129 views
Information about free account Azure and SQL database
I'm using free account and I need to create an instance of SQL database. I have read there is 250 GB of instance S0 Standard of SQL database with 10 DTU in the free tier for 12 months. But, when I try ...
0 votes
1 answer
456 views
How to migrate Dedicated SQL Pool (DW) to Serveless Synapse?
I have Azure Datawarehouse which has fixed pricing tier DW100. Usage is small and assuming that Serverless can be cheaper. A) How do get information how much data processing have been occurring in ...
- 101
1 vote
1 answer
1k views
Azure SQL bacpac Restore Over Existing Database
I want to restore a bacpac file over an existing Azure SQL database using PowerShell. Past with experience with restoring bacpac files in Azure requires creating a new database altogether when ...
- 728
0 votes
1 answer
3k views
"An existing connection was forcibly closed by the remote host" when trying to connect to azure sql server
I'm trying to deploy a SQL database to my azure SQL server. When I'm trying to connect to my target server, I get the error listed below. I'm using Microsoft SQL Server management studio 18 with ...
1 vote
1 answer
1k views
ARM Template - Azure SQL Database Diagnostics & Log Analytics Workspace
Using an ARM Template I want to enable diagnostics settings for my Azure SQL Database and have that data stored in a Log Analytics workspace I created. I want to enable the errors, timeouts, blocks ...
- 728
0 votes
0 answers
145 views
Enter Azure SQL Connection String in App Settings w/ PowerShell
I've deployed an Azure Web App and Azure SQL Database using PowerShell. At the moment I have the following code with a dummy value that sets a sql connection string for my web app: $connectionStrings =...
- 728
0 votes
1 answer
248 views
Azure SQL database still incurring vcore charges despite move to DTU?
So, in my MSDN subscription, myself and a developer set up an Azure SQL 480mb database to test performance, initially on the vcore model. Charges very quickly accrued and despite practically nothing ...
- 11
1 vote
1 answer
4k views
My Azure Data Factory Linked Service can't see my SQL Managed instance
We're using Azure Data Factory and have an Azure hosted Integration Runtime as well as a SQL Managed instance where our databases live. I'm having trouble getting a data set from our Managed Instance -...
- 29
0 votes
1 answer
201 views
Azure SQL. Scale out database to improve performance (read only)
We have a database that is used quite heavily (almost 100% of requests are selects), and now database becomes a bottleneck. We were looking for a solution that would let us scale this database out (...
2 votes
0 answers
578 views
How to set up firewall rules for hosted Azure SQL cross database query using external tables
I have a hosted Azure SQL Server instance with an elastic pool that contains multiple databases. I want to do a cross database query between two of those databases. I understand that the only way to ...
0 votes
2 answers
2k views
Unable to connect to Azure SQL server through Point-to-Site VPN
Is there any possibility to connect to an Azure SQL server through Azure's P2S VPN client? More specifically, I want to force clients connected through Azure's S2P VPN client to use the VPN to connect ...
- 259
1 vote
1 answer
447 views
Can't identify where SQL backups are being initiated from
A little background on my skill: I am new to running SQL on Azure and, although I've done a bit of development on SQL Server, I would still consider myself a novice with SQL Server as well. We ...
- 969
1 vote
0 answers
857 views
Azure SQL PIM like access
We are implementing PIM across our Azure setup and whilst it works well I cannot see a way to restrict access to the SQL databases in a way that allows a user to request elevation to access the ...
- 115
0 votes
2 answers
157 views
Is an Azure Vnet really private?
I'm in the process of splitting the functions of a single VM web server on Azure across two VMs on the same Vnet. I want to check, can I assume that traffic between them is absolutely isolated and ...
- 143
0 votes
1 answer
1k views
Azure Database for MySQL servers: Location: service not available in this location for your subscription
I am trying to create an Azure DB MySQL server and under location I keep getting this error. " service not available in this location for your subscription." Could you guide me what needs to be ...
- 1
0 votes
1 answer
59 views
Azure SQL metric
I am not able to find few SQL metrics in Azure. Can anyone help in how to set metrics for below topics. 1)Under utilized capacity 2)Number of databases outside of pool 3)Scale up 4)Connection ...
- 139
0 votes
1 answer
615 views
WebApp cannot connect to Dbaas SQL server database
Since yesterday afternoon our Azure website is (again) not working because it cannot connect to its Azure SQL Server database. We haven't changed anything. The database is accessible through ...
- 101
4 votes
1 answer
3k views
Azure SQL bacpac import job stuck - timeout on it?
Got some issues with a stuck azure sql bacpac import preventing me from importing the bacpac again to the database with the same name. The file is being pulled in from an Azure storage account. I ...
- 320
0 votes
1 answer
285 views
Detect when scaling Azure SQL database via async TSQL command has failed
I have a scheduled task which runs each night to copy an existing production Azure SQL db to a dev environment. Once copied, I scale the database down (actually I put it into an elastic pool to share ...
- 111
0 votes
1 answer
32 views
Cross reference between azure sql data ware houses
In one sql server instance, I have below 2 data warehouses, sqlwarehouse1 sqlwarehouse2 And in sqlwarehouse2, I have the table "dbo.test". How can I refer this table from sqlwarehouse1? Is this ...
0 votes
1 answer
485 views
Failed queries in Azure SQL
Finding the failed queries in Azure SQL Description: How can I get all the failed queries in Azure SQL for the last 5 days? Use-case- I need to troubleshoot certain issues
- 1