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.
100
questions
37
votes
7
answers
12k
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 ...
- 1,583
7
votes
1
answer
12k
views
Exporting on-prem SQL Server to Azure SQL using BAPAC fails because of users with Windows Auth
I have an on-prem SQL Server 2014 database - the schema itself is fine and fully Azure SQL compatible.
However, it has a USER object that is bound to a Server LOGIN which is configured to use Windows ...
- 2,290
6
votes
3
answers
12k
views
How do I connect to an Azure SQL Server via an Azure VPN Gateway?
I have setup an Azure SQL Server with an Elastic Pool into which I have created a Test database.
I have also setup an Azure Virtual Network and a Point-to-Site VPN. The Virtual Network has 2 subnets -...
- 473
4
votes
1
answer
122
views
Migrate SQL 2008 database to Azure
I am migrating a SQL server 2008 R2 production database to Azure SQL database service in the cloud.
Is it possible to mirror/replicate the Azure database from the 2008 R2 database? So I can just ...
- 309
4
votes
1
answer
1k
views
Cant delete Azure Database
Created this a database from a backup.
I want to delete this database because I selected the incorrect backup. When trying to delete the database I get the following error:
Failed to delete the ...
3
votes
4
answers
12k
views
How to create database user and assign role to it with terraform
I have created sql server and database with terraform now I have to create database user and assign role to it.
How I can do it. Please suggest me.
3
votes
2
answers
13k
views
How to give an Azure SQL DB instance a private IP?
I have an Azure SQL DB. Is it possible to give it a local IP address for connections from within my network and vnet so that it forces the traffic over expressroute?
- 175
3
votes
1
answer
3k
views
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON' on Azure SQL with Active Directory Admin via SSMS
When I attempt to connect to an Azure SQL Server via SQL Server Management Studio using the "Active Directory - Universal with MFA support" method with an account that is configured as the Active ...
- 181
3
votes
1
answer
455
views
Cannot Enter-AzureRMVM - Azure CloudShell (PowerShell)
I have a SQL Server on IaaS Windows 2016 using the default marketplace image (SQL Server 2016 SP1 Enterprise on Windows Server 2016) today, after fighting the East US region problem yesterday which ...
3
votes
1
answer
2k
views
How can I configure an Azure VM to act as a proxy for connecting to SQL Database over a Service Endpoint?
Currently, Azure does not allow for SQL Databases to be accessed through a Service Endpoint over a VPN Gateway. My idea to circumvent this limitation is to set up an Azure VM to function as a proxy so ...
3
votes
0
answers
2k
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 ...
- 310
3
votes
0
answers
180
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:\...
- 353
2
votes
1
answer
833
views
Using domain Active Directory account for connecting to SQL Server running on an Azure VM
According to the first note on this Microsoft Azure article: Connecting to SQL Server running on an Azure VM is not supported using an Azure Active Directory account. Use a domain Active Directory ...
- 217
2
votes
2
answers
6k
views
Azure automation runbooks access to Azure SQL Database
I am trying to run some SQL statements against my Azure SQL database using an Azure Automation runbook. In all examples I can find on https://docs.microsoft.com they are using an Automation credential ...
- 309
2
votes
1
answer
507
views
Azure - can't remove SQL server
Something went wrong, I can't connect to Azure SQL server. I try to remove it
but get an error:
Failed to delete the server: ***. ErrorCode: 504 ErrorMessage:
{"error":{"code":"GatewayTimeout",...
- 123
2
votes
2
answers
4k
views
How to set up a nightly job that runs a script on Azure SQL?
I'm looking for a way to set up a nightly job that will run a small SQL Script, to rebuild fragmented indexes on an Azure SQL database. Resources I have found online seem to be either dated, or ...
- 177
2
votes
1
answer
636
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 ...
- 469
2
votes
0
answers
652
views
Cannot Connect to Azure Database from Azure Web Application
We have a SQL Server database in Azure. In the same resource group is an App Service.
The App service connects to the database, using the connection string:
Server=tcp:[server].database.windows.net,...
- 31
2
votes
1
answer
134
views
Azure elastic database pool storage limit briefly drops to zero
Yesterday and today I my azure web app experienced bunch of timeouts and 502's for few minutes. While investigating I found out that database storage limit and storage used dropped to zero at that ...
- 123
1
vote
3
answers
7k
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,583
1
vote
1
answer
411
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 ...
- 155
1
vote
1
answer
2k
views
Unable to connect as a database contained user to an Azure SQL database
On my free trial Azure account, I'm working on Exercise 5 of this official Azure lab tutorial to work on the section Connect as a database contained user to an Azure SQL database. I've successfully ...
- 217
1
vote
2
answers
2k
views
Add Azure SQL Server in to Azure VNET
Is it possible to add Azure SQL Server into a Azure Virtual Network?
Currently I see only a separate firewall for SQL server. But I want to maintain a single Network Security Group and have all my ...
- 111
1
vote
2
answers
2k
views
How to accomodate very large SQL database in Azure?
I have a database with a growth of more than 100 Gb per week, and 5 TB yearly.
Since this is financial data, we can't purge it. If we keep this data for at least 10 years, size will become 50 TB.
...
- 11
1
vote
2
answers
2k
views
What's the difference between Azure Database Backup, Copy, and Export
I tried searching online for an answer to the above question but all I see are the long documentations on performing these operations. What I'm looking for is a brief description of how do the ...
- 217
1
vote
1
answer
224
views
Unable to login to Azure SQL Server using Azure Active Directory account
Using Azure Trial Free account to practice on their lab tutorials. I'm not clear on steps 5 and 6 of Exercise 4 on this Azure Official Lab. When I login using ADSQLAdmin it says (as expected) account ...
- 217
1
vote
1
answer
425
views
Move SQL 2008 database to Azure
I need to move a SQL 2008 R2 on-premis database to an Azure SQL cloud database. The database is to big to script out with data and Azure SQL cloud cannot restore a standard .bak file.
Trying to use ...
- 309
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 ...
- 688
1
vote
2
answers
54
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? ...
- 21
1
vote
1
answer
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 ...
- 111
1
vote
1
answer
3k
views
How to minimize latency between Azure App Service and Azure SQL Database?
We have an Azure App Service application using Java Tomcat 8.5 running in West US Region. The Service Plan for this Service is Standard, Big.
This App Service application is connected to a SQL ...
- 111
1
vote
1
answer
3k
views
What cross-subscription communication & connectivity is possible in Azure?
I work in a large distributed org, and several divisions have purchased their own subscription to Azure.
I am a co-administrator to all the accounts, and can see all the resources in all ...
- 8,921
1
vote
1
answer
61
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
1
vote
1
answer
410
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
1
vote
1
answer
651
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 ...
- 688
1
vote
1
answer
3k
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
1
vote
0
answers
469
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 ...
1
vote
1
answer
137
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 ...
- 979
1
vote
0
answers
554
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
1
vote
1
answer
215
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, ...
- 1,583
1
vote
0
answers
101
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 ...
- 111
1
vote
1
answer
595
views
Change Azure Master Database Collation ARM Template
I'm deploying an environment in Azure using ARM Templates. I'm using Azure SQL Server and 4 databases. I went to restore a bacpac file and got an error complaining about different collation settings ...
- 688
1
vote
0
answers
27
views
Azure SQL Built-in Backup not completing
I've configured the retention policy in 'Manage Backups' for my Azure SQL Server but nothing is appearing under 'Available Backups'. Does there need to be an associated storage account? If so, how do ...
- 281
1
vote
0
answers
418
views
Azure VPN cannot connect to sql server
We have setup our VPN connection in Azure to our on-premises database, the connect is working with no problems. I have written a MVC app that tries to connect to our on-premise database in SQL Server ...
- 111
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
0
votes
1
answer
825
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
2
answers
265
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,049
0
votes
1
answer
536
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 ...
- 688
0
votes
2
answers
152
views
SQL Azure used by Azure VMs, Encrypted connection or virtual network?
We Have an Azure SQL Server which is going to accept connections from four VMs also in Azure. My question is, Which one is better?
Using encrypted connections protected by certificates and Azure SQL ...
- 123
0
votes
1
answer
265
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 ...
- 469