Stack Overflow
Stack Overflow

Questions tagged [azure-sql-server]

548 questions
26
votes
4 answers

How to set Azure SQL to rebuild indexes automatically?

In on premise SQL databases, it is normal to have a maintenance plan for rebuilding the indexes once in a while, when it is not being used that much. How can I set it up in Azure SQL DB? P.S: I tried it before, but since I couldn't find any options…
Ashkan S
  • 10,464
  • 6
  • 51
  • 80
24
votes
5 answers

Azure SQL DB Error, This location is not available for subscription

I am having pay as you go subscription and I am creating an Azure SQL server. While adding server, on selection of location, I am getting this error: This location is not available for subscriptions Please help.
Tarik Khan
  • 243
  • 2
  • 5
14
votes
2 answers

How to create BAK file from azure sql db

I want to move my azure sql db to another host. However my new host allows to import sql db backup-files (.BAK) only; I found out how to generate .BACPAK files with SQL Server Management Studio but I could not find a way to create a BAK-file from…
Manu
  • 1,290
  • 5
  • 17
  • 32
13
votes
1 answer

Azure SQL Login Denied, error 18456 state 113

We have an Azure SQL server. From some machines in our Azure subscription we cannot connect to our SQL server, but from other machines it's fine. From machines outside of Azure we have no issues at all. The error thrown is Login failed for user…
Mark Henderson
  • 2,586
  • 1
  • 33
  • 44
13
votes
2 answers

Azure SQL Server BACPAC import failed

whenever i try to import BACPAC on local sql server I am getting below error message: TITLE: Microsoft SQL Server Management Studio ------------------------------ Could not import package. Warning SQL0: The source contains users that rely on an…
Deepak Kumar
  • 615
  • 1
  • 5
  • 20
11
votes
1 answer

UpsertLogicalServerRequestAlreadyInProgress when trying to create Azure SQL Logical Server

I have Azure DevOpe pipeline, which have worked fine so fine, but yesterday I got suddenly showstopper error. Pipeline gave no error, but SQL Logical Server was not created. I deleted all resources in Resource group. Then I executed pipeline again.…
Kenny_I
  • 2,001
  • 5
  • 40
  • 94
10
votes
1 answer

Can't Create Azure SQL Database Users Mapped to Azure AD Identities using Service Principal

As part of an Azure SQL database automation solution, I'm trying to create Azure SQL database users mapped to Azure AD Identities, using a service principal. The result is an error message saying: Principal 'AAD_User_UPN_or_Group_Name' could not be…
Ding Liu
  • 103
  • 1
  • 6
10
votes
2 answers

How to add Azure SQL Server connection string to app.config in Windows Forms?

I'm trying to add an Azure SQL Server connection string into my app.config file, but there are red underlines all over the connection string when I try to copy and paste it from Azure. I'm using Windows Forms in Visual Studio. Here is my connection…
mabel
  • 111
  • 1
  • 1
  • 7
10
votes
2 answers

Assigning an Active Directory Administrator to an Azure SQL instance through ARM Templates

Is it possible to assign an Active Directory Administrator to an Azure SQL Instance within an ARM resource template? I'm trying to automate the deployment of a database server, but I only seem to be able to specify the local server administration…
mclark1129
  • 7,532
  • 5
  • 48
  • 84
9
votes
2 answers

Spring Batch Deadlock - Could not increment identity; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException

We are in the process of moving to Azure SQL Server from Oracle DB for our Spring Batch application. I am getting the following error while trying to execute two different jobs at the same time that updates different tables however uses the same…
One Developer
  • 99
  • 5
  • 43
  • 103
9
votes
2 answers

Vulnerability assessment enablement on Azure SQL server through ARM template

I have created my Azure SQL server through ARM templates. To enable the vulnerability assessment I need to enable Advanced data security. I use the following code in my ARM template inside the resource bracket of the SQL server resource to enable…
achahbar
  • 901
  • 3
  • 21
  • 47
8
votes
2 answers

CXSYNC_PORT wait type in Azure Sql Database

I'm facing this issue intermittently now, where the query (called from stored Procedure) goes for CXSYNC_PORT wait type and continues to remain in that for longer time (sometimes 8hours in stretch). I had to kill the process and then rerun the…
user1941025
  • 541
  • 6
  • 21
7
votes
1 answer

Azure SQL Serverless tier never shuts down

I'm experimenting with the Serverless tier in Azure SQL, but the database never "sleeps" because it seems that Azure is continually querying the database behind the scenes. I created the database via and ARM template. The "Compute utilisation" and…
SturmUndDrang
  • 1,876
  • 5
  • 27
  • 47
7
votes
2 answers

How do you maintain idempotency with Azure EventGrid webhooks?

I have configured an EventGrid subscription to initiate a web hook call for events in a resource group when a resource is created. The web hook call is successfully handled, and I return a 200 OK. To maintain idempotency, I store all events that…
Colin
  • 624
  • 8
  • 27
7
votes
1 answer

Azure SQL database DTUs maxing out - due to large database?

We have an Azure SQL database. Up until a few weeks ago, we were set at 10 DTUs (S0). Recently, we've gotten more SQL timeout errors, prompting us to increase our DTUs to 50 (S2). We get the errors less frequently, but still on occasion. When we get…
Scotty H
  • 6,432
  • 6
  • 41
  • 94
1
2 3
…
36 37