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.

Filter by
Sorted by
Tagged with
0
votes
1answer
15 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 ...
0
votes
1answer
27 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 ...
0
votes
1answer
35 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 ...
0
votes
1answer
162 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
1answer
23 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 ...
-1
votes
1answer
40 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
0answers
16 views

wrangling data flow button “done” on datafactory

I am trying to do a wrangling data flow in azure data factory like this example: https://www.youtube.com/watch?v=LKenBZYZaLA&t=159s but i dont see the button "done" inside of powerquery ...
0
votes
0answers
20 views

MySQL workbench database import from Azure SQL

I am currently trying to use the MySQL Workbench migration wizard to import a database located on an Azure SQL Managed instance to an on-premise MySQL server, but i have an issue with the wizard: it ...
0
votes
1answer
43 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 ...
0
votes
0answers
45 views

Azure SQL BACPAC Import - Team Foundation Server 2018

I created a release pipeline in TFS 2018 and I have two tasks - deploying an ARM template and deploying a powershell script which imports/restores a bacpac file and creates an azure sql database. The ...
0
votes
1answer
70 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 ...
0
votes
0answers
17 views

Set PowerShell Azure SQL Connection String Parameter

I have an Azure SQL database in one resource group and a key vault in a separate resource group. Everything is already deployed but I'd like to assign the connection string values of the sql db to a ...
0
votes
0answers
27 views

Deploy Azure Web App & SQL - Create Key Vault Secrets and Assign to Web App

I have an existing key vault in a separate resource group. I want to deploy an Azure SQL database and web app to a separate resource group then create a new secret in the existing key vault. This ...
0
votes
1answer
1k 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 ...
0
votes
1answer
318 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 ...
0
votes
0answers
31 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 =...
0
votes
1answer
48 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 ...
1
vote
1answer
1k 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 -...
0
votes
1answer
68 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 (...
1
vote
0answers
216 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
1answer
911 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 ...
1
vote
1answer
43 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 ...
1
vote
0answers
136 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 ...
0
votes
2answers
88 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 ...
0
votes
1answer
239 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 ...
0
votes
1answer
36 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 ...
0
votes
1answer
122 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 ...
2
votes
0answers
542 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 ...
0
votes
1answer
67 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 ...
0
votes
1answer
18 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
1answer
166 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
0
votes
1answer
434 views

Can you remove SQL Server from an Azure SQL VM?

I am migrating our SQL Server (Web 2017) instance our of our Azure VM (Windows Server 2019) into Azure SQL. After this I obviously do not want to be paying for SQL Server on the VM any more. The VM ...
0
votes
1answer
180 views

Azure SQL Watchdog for Analytics

unsure if the right place for my question. In the Azure portal there are many tools for Analytics and Monitoring; however they all seem to be for server related metrics such as CPU usage, query times,...
0
votes
1answer
258 views

Azure CLI list Azure SQL Server DB backups

I'm trying to make an automated script that restores from the latest LTR backup of an Azure SQL server database. Using this command: az sql db restore --dest-name $newdbname --name $dbname--resource-...
0
votes
1answer
43 views

Azure Monitor Metrics

About 4 weeks ago we had a development SQL database on azure and it was great as we could see the CPU and other information. After doing what we needed to do to make our database work with Azure, we ...
37
votes
7answers
10k views

Can Microsoft employees see my data in Azure?

I have sensitive data stored in both Azure DB and Azure SQL VM. An authorised DBA can log on and query the database, but in theory could a random Microsoft employee do the same without asking ...
3
votes
0answers
139 views

Azure Failover Cluster Backup

We have configured a failover cluster instance in Azure (iaas), and we are running SQL 2016, and we have a backup directory presented as a csv (which is a mountpoint on the c: drive, under c:\...
0
votes
2answers
3k views

TDE vs Disk Encryption

We are a small business that host applications and data for clients. Some of our clients are requesting we protect their data with 'encryption at rest' - although it's never very clear if they know ...
1
vote
1answer
122 views

Is there any scheduled downtime with Azure DB?

With a standard SQL Server platform (with no replication or redundancy), some downtime is to be expected for weekly/monthly patching and reboots. Is this still the case for Azure DBs (elastic pools, ...
0
votes
2answers
88 views

Backing up Azure SQL Server databases to external destination

I run a bunch of Azure SQL Server databases, and they are backed up internally in Azure to storage. This is great for most cases. However, to mitigate risk (if for example, we lose access to the ...
1
vote
2answers
51 views

Query regarding Azure SQL database setup

I am new to Azure and I am required to create a Azure SQL database. So far I have created a Azure SQL server and post that sql database. Now my main concern comes as to how to access that database? ...
0
votes
1answer
99 views

how to restore Azure Database for MySQL in azure using data factoryy Destination data store

i want to save data from Destination data store via data factory to blob or some other storage in azure cloud and then get it back to Azure Database for MySQL , but the only options in the UI screen ...
1
vote
1answer
1k views

how to export Azure Database for MySQL server to blob?

is there a way to export Azure Database for MySQL server to a blob or a container ? my main goal is to keep the backup for over 35 days in blob/container and still be able to restore it after? i want ...
0
votes
1answer
72 views

Error While Creating Azure SQL Server Failover Group

I am trying to implement a failover group in Azure for my SQL servers but I am getting this error while doing so. Further, I have question too. I got to know that Secondary Server should not be in ...
0
votes
1answer
53 views

can't connect to my sql DB server [closed]

I'm trying to connect to my sql DB in azure with my primary username and password (I don't have any other username and password) and its failed. I'm 100% sure I entered the right username and password....
0
votes
1answer
2k views

ADO NET Destination has failed to acquire the connection with the following error message: "Login failed for user

Created a SSIS package, it is running fine when I run it on premise but when i try to execute it from sql server agent it gives me error for login failed for user, I am using SQL authentication to ...
0
votes
1answer
37 views

Azure Key vault, getting suffice permissions to develop/administrate a customers environment

I need to administer azure key vault for a client to store VM creds, Data Factory creds, SQL creds etc. I have guest account access to their environment, setup with contributor access to the azure ...
0
votes
0answers
70 views

Azure mysql server portal shows 150 GB extra used space than actual db size

I'm using azure mysql database, Azure portal shows total of 350 GB of used space but when I analyzed using schema inspector the total size used is 205 GB. what might be cause of extra storage. My ...
1
vote
0answers
56 views

What is the fastest way to backup an Azure SQL Server Database?

I have a medium sized database that is running within Azure. It is about 30GB. I used the Azure console to do an export to an Azure storage account- that seems to be the way to do it. However, it has ...
0
votes
1answer
487 views

Autoscaling Azure SQL Database

I'm looking to set up some type of method to autoscale (vertically) my Azure SQL Databases based on CPU or some other performance metric. My environment is in govcloud and I don't see any options for ...