Server Fault Stack Exchange
Server Fault Stack Exchange

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/

99 questions
0
votes
0 answers

Error moving Sql Server Azure between subscriptions

I’m trying to move a SQL Azure Server that has 2 databases from one subscription to another. The databases’ sizes are 10G and 1G. I’m using the azure portal to do it and I’m getting the following error -> There was an error moving…
Copeleto
  • 113
  • 2
0
votes
2 answers

Azure IaaS Client VM to PaaS SQL Connection Issues

I'm trying to get a website hosted on Azure IaaS VM to communicate with a database hosted on Azure PaaS SQL. However, I am receiving an exception when trying to connect: A network-related or instance-specific error occurred while establishing a…
MichaelFStarke
  • 1
  • 1
0
votes
2 answers

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 listening on a public port? Using non-encrypted…
morgano
  • 123
  • 1
  • 7
0
votes
1 answer

How to connect multiple sql instances installed in same azure vm via internet

I have an Azure VM which has installed two sql server instances (Sql server 2012 and sql server 2016). First I installed the SQL server 2012 and could able to connect via internet using Sql Server Management Studio. I referred this article. Then I…
sahan peiris
  • 1
0
votes
0 answers

Cannot import bacpac from blob storage

I'm unable to import a data tier application (BACPAC) via SSMS from Azure storage on my PC. It works with the same account on multiple other PCs, the only difference is that that runs an older version of SSMS (I am on version 19) but I can't see why…
Nick P
  • 121
  • 1
  • 6
0
votes
0 answers

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 database on the SQL server. From what I see…
GilShalit
  • 149
  • 7
0
votes
0 answers

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 with most of the data removed, as a test…
SeaQwell
  • 1
0
votes
1 answer

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 Managed Instance. The VMs and the Managed Instance…
Adam Crossland
  • 113
  • 4
0
votes
1 answer

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 calculate how many eDTU I am currently using for my…
Jimbo
  • 309
  • 1
  • 5
  • 16
0
votes
0 answers

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 solution. We need to be able to perform this…
Alex T.
  • 185
  • 2
  • 12
0
votes
0 answers

Routing connection to Azure DB through StrongSwan IPSec site-to-site tunnel

I have a Linux Strongswan IPSec site-to-site connection up and stable to an Azure Cloud Network, I'm trying to route an sql connection with a python script through the tunnel to an Azure database in the clients network but I keep getting timed out…
Jason is a robot
  • 11
  • 2
0
votes
1 answer

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 the read scale out option, as this option…
learner
  • 101
  • 1
0
votes
1 answer

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 recovery? Maybe someone in his project met faced…
Anastasiia D
  • 1
0
votes
1 answer

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 frontends, Azure App Services for the backends (.NET 6)…
xalib
  • 1
  • 1
0
votes
1 answer

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 connected to the vnet can connect to the private IP…
Utegrad
  • 145
  • 1
  • 2
  • 8
1 2 3 4
5
6 7