Server Fault
Server Fault

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.

SQL Database is a general-purpose relational database managed service in Microsoft Azure that supports structures such as

  • Relational data
  • JSON
  • Spatial
  • XML

SQL Database delivers dynamically scalable performance within two different purchasing models: a vCore-based purchasing model and a DTU-based purchasing model. SQL Database also provides options such as columnstore indexes for extreme analytic analysis and reporting, and in-memory OLTP for extreme transactional processing. Microsoft handles all patching and updating of the SQL code base seamlessly and abstracts away all management of the underlying infrastructure.

Ask any question related to Azure SQL and read more at https://docs.microsoft.com/en-us/azure/sql-database/

105 questions
38
votes
7 answers

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 permission? I found this online which suggests the answer…
userSteve
  • 1,673
7
votes
1 answer

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 Authentication (so passwords aren't stored in…
Dai
  • 2,309
6
votes
3 answers

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 - one for the GatewaySubnet and another into which…
Chris Roberts
  • 473
4
votes
1 answer

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 switch over to just using the new one. Instead of…
Andreas
  • 329
4
votes
1 answer

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 database: [DBNAME]. ErrorCode: 400 ErrorMessage: Cannot…
Louwrens Potgieter
  • 41
4
votes
1 answer

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 was importing a bacpac file (575mb) of a database…
John Fox
  • 320
3
votes
0 answers

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:\clusterstorage) this is using storage spaces direct s2D.…
Norrin Rad
  • 353
3
votes
1 answer

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 that all communication with the SQL Database…
Thuy Guevarra
  • 31
3
votes
1 answer

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 Directory Admin, the following error message is…
Fabian Schmied
  • 209
3
votes
4 answers

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.
sumit salunke
  • 33
3
votes
2 answers

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?
Neil P
  • 185
3
votes
1 answer

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 was resolved. In Azure Cloud Shell, I type…
PrometheusRising
  • 31
3
votes
1 answer

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 have Log Analytics or App Insights turned on, no…
Tessaract
  • 175
2
votes
2 answers

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 to be able to save backups in the cloud and with…
Omer Anisfeld
  • 121
2
votes
0 answers

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,1433;Initial Catalog=[database]; Persist Security…
Paul O'Leary
  • 31
1
2 3 4 5 6 7