6,845 questions

Sort by: Updated
2 answers

add replica access restriction for Azure SQL contained users

Please add a setting for Azure SQL database contained users that controls which replica types they can connect to: Read-only: Allow connections only to read-only replicas. Read-write: Allow connections only to the read-write primary. Both: Allow…

Azure SQL Database
asked 2026-11-19T17:47:21.5233333+00:00
Dan McClain 0 Reputation points
answered 2026-11-19T18:24:12.84+00:00
Erland Sommarskog 137.7K Reputation points MVP Volunteer Moderator
1 answer One of the answers was accepted by the question author.

Azure SQL server name not released after deletion - ServerDnsAliasDnsRecordInUse when creating a server DNS alias

I migrated an Azure SQL logical server to a new region and deleted the old one (name klevio, westus2) about 1.5 hours ago. I want to create a server DNS alias called klevio on the new server (swedencentral) so existing clients keep working. Creating it…

Azure SQL Database
asked 2026-11-19T15:11:49.7266667+00:00
David Alguacil Aragón 0 Reputation points
accepted 2026-11-19T15:27:32.4433333+00:00
David Alguacil Aragón 0 Reputation points
2 answers

SQL Server Deployment in East US 2 Region — Regional Capacity Restriction

Problem description I am unable to provision a new Azure SQL Database logical server in the East US 2 region. Both Azure CLI and ARM deployment via Bicep fail with the error indicating that the region is not accepting new SQL server creation at this…

Azure SQL Database
asked 2026-08-27T15:51:38.9333333+00:00
Jake Stratton 15 Reputation points
edited an answer 2026-11-17T21:50:42.1533333+00:00
JuliaMarvin 24,285 Reputation points Volunteer Moderator
1 answer One of the answers was accepted by the question author.

Azure SQL Server Creation in West Europe Fails Due to Subscription Region Access Restrictions

Problem description I am trying to create a new Azure SQL logical server in the West Europe region using the Azure Portal. However, the creation is blocked with the message indicating that my subscription does not have access to create a server in the…

Azure SQL Database
asked 2026-11-16T09:01:24.0233333+00:00
Shubham Sanap 145 Reputation points
accepted 2026-11-16T13:15:07.72+00:00
Shubham Sanap 145 Reputation points
3 answers

Can't Create Database Scoped Credentials in Serverless synapse Database

When I run the below script, I am getting an error saying Incorrect syntax near IDENTITY

Azure SQL Database
Azure Synapse Analytics
Azure Synapse Analytics

An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.

5,576 questions
asked 2022-08-15T22:57:56.153+00:00
Teja.Gudipati 11 Reputation points
answered 2026-11-13T05:57:17.6+00:00
Vinodh247-1375 44,281 Reputation points Volunteer Moderator
2 answers

Database user password change in Azure SQL after Import bacpac

On Prem:\ I have a db called db1 User test is having access to db1 Now I have exported bacpac in Azure SQL Single DB: Import bacpac file Able to Connect with server admin and able to see db1 in Azure. Issue: I wanted to…

Azure SQL Database
asked 2022-07-28T18:21:14.573+00:00
Prakash M, Bhanu 171 Reputation points
edited an answer 2026-11-13T05:15:13.5433333+00:00
Prakash M, Bhanu 171 Reputation points
1 answer

Is it possible to deploy a an Azure SQL database + server with only Azure Active Directory authentication via an ARM template?

Hi all, I am wondering whether I can deploy a Azure SQL server + database and assign a Azure Active Directory admin at the same time. I saw someone asked this question 5 years ago and I was wondering whether it is possible now.

SQL Server on Azure Virtual Machines
Azure SQL Database
asked 2022-07-19T16:12:57.49+00:00
John 81 Reputation points
edited an answer 2026-11-13T05:12:19.5266667+00:00
John 81 Reputation points
1 answer

Create Audit Trail from SQL CDC

I have a few tables on which I have enabled CDC. As each row in CDC table contains all the columns regardless if they were changed or not, so it becomes difficult to figure out only the changed data. Is there a way to create a single Audit Table with…

Azure SQL Database
asked 2022-03-21T23:35:58.377+00:00
Ajeet Singh 51 Reputation points
edited an answer 2026-11-13T04:55:15.68+00:00
Ajeet Singh 51 Reputation points
0 answers

Connecting RStudio Workbench Standard for Azure to an Azure SQL database.

If I use RStudio Workbench Standard for Azure. Is it possible to connect this to my Azure SQL database.

Azure SQL Database
asked 2022-03-07T17:31:38.45+00:00
derry 6 Reputation points
2 answers

Is that possible to trigger SQL Managed Instance Backup Manually by a script?

Hi everyone, We are going to build a SQL Managed Instance, as I known, the backup of SQL MI is automatically managed by Azure. How could we control the timepoint of SQL MI backup? Is there anyway to trigger the SQL MI backup by powershell, that…

Azure SQL Database
asked 2021-12-03T11:57:47.213+00:00
Eric Chen 76 Reputation points
edited an answer 2026-11-13T04:39:43.4833333+00:00
Eric Chen 76 Reputation points
1 answer

Azure sql and Visual Studio

how can i connect a database that is on azure servers to my visual studio uwp project. the goal of the project is to make the application work on different PCs from 1 database over the network

Azure SQL Database
asked 2021-10-19T21:11:48.403+00:00
edited an answer 2026-11-13T04:37:13.7833333+00:00
1 answer

External table creation based on table from another server

Hi, I am trying to create an External table in one database server , by accessing some table from another Remote Database server. Creation of External Data source as well as External table was successful. But when I try to query the External…

Azure SQL Database
Azure Synapse Analytics
Azure Synapse Analytics

An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.

5,576 questions
asked 2021-08-16T13:20:42.01+00:00
Gowri Shankar 211 Reputation points
edited an answer 2026-11-13T04:34:31.8033333+00:00
Gowri Shankar 211 Reputation points
3 answers

Visual Basic app to connect to an online database

Hey Microsoft Community, I have an app with a login (name, email, and password) form and since it's hard to keep track of how many users are using the app, I want to know if it's possible and how to connect my Visual Basic application to an online…

Azure SQL Database
Developer technologies | VB
Developer technologies | VB

An object-oriented programming language developed by Microsoft that can be used in .NET.

2,914 questions
asked 2021-07-20T18:57:22.98+00:00
Doom 1 Reputation point
edited an answer 2026-11-13T04:33:27.8466667+00:00
Doom 1 Reputation point
1 answer

SQL login for DTU database

HI I am trialling creating a SQL database on Azure and I am trying to create a SQL login for a user but I am not sure how to do so. I can log in using my email ID and Azure authentication but some of my end-client applications allow only SQL…

Azure SQL Database
asked 2021-06-16T17:56:59.463+00:00
Ps2131 11 Reputation points
edited an answer 2026-11-13T04:31:58.1833333+00:00
Ps2131 11 Reputation points
6 answers

Invalid Object Name when attempting to insert data from a table in one DB to a table in another DB on the same server

I am attempting to perform an insert from a table in one database to a table in another database on the same server I have tried this: INSERT INTO SDCS_AUDIT.BMA_FORM_DATA (.....) and this: INSERT INTO [SDCS_AUDIT].[BMA_FORM_DATA] (...) as well as…

Azure SQL Database
Developer technologies | Transact-SQL
Developer technologies | Transact-SQL

A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.

4,702 questions
asked 2021-04-12T19:38:47.667+00:00
James Hackney 41 Reputation points
edited an answer 2026-11-13T04:27:48.13+00:00
James Hackney 41 Reputation points
1 answer

Why are users not able to login to restored DB after the backup is restored to another SQL server?

I have restored a sql database in another server, but existing users are not able to access the newly restored database. Please advise.

Azure SQL Database
asked 2021-03-27T01:56:41.99+00:00
Lawrence080-MSFT 26 Reputation points Microsoft Employee
edited an answer 2026-11-13T04:26:37.34+00:00
Lawrence080-MSFT 26 Reputation points Microsoft Employee
0 answers

about permission, view server performance state denied in paas server database

i have read write permission to particular database in paas server, but while user run the update statement, it was throwing an error, like view server performance state denied, but when i try to give server performance state permission, throwing an…

Azure SQL Database
asked 2025-05-07T13:17:12.07+00:00
2 answers

How to Retain User Logins & Passwords When Migrating Azure SQL Database via BACPAC

I have a production application running on Azure with an Azure SQL Server and a SQL Database inside it. In my application, all users are created at the database level with their passwords. I need to migrate this database to another Azure tenant by…

Azure SQL Database
asked 2025-02-22T09:15:44.4733333+00:00
Raj Kadhi 0 Reputation points
edited an answer 2026-11-13T04:12:57.57+00:00
Raj Kadhi 0 Reputation points
0 answers

How to fix code throwing exception : Microsoft.Data.SqlClient.SqlException: 'Login failed for user '

Hi All, I'm encountering an issue while trying to connect to an Azure SQL Database using Microsoft Entra Authentication (formerly Azure AD). I am using DefaultAzureCredential in my .NET application to authenticate and retrieve the access token, but…

Azure SQL Database
Azure App Service
Azure App Service

Azure App Service is a service used to create and deploy scalable, mission-critical web apps.

10,031 questions
SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,669 questions
Developer technologies | C#
Developer technologies | C#

An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.

11,581 questions
asked 2025-01-03T00:29:43.2+00:00
Krishna Basavaraj K S 0 Reputation points
0 answers

How to publish a blazor website with sql sever that is giving the error HTTP Error 500.30 - ASP.NET Core app failed to start

hi, im trying to publish my blazor web app on azure however it fives me the error HTTP Error 500.30 - ASP.NET Core app failed to start. when i try to debug it and go into the diagnose page of the websever i get this error…

Azure SQL Database
Developer technologies | .NET | Blazor
Developer technologies | .NET | Blazor

A free and open-source web framework that enables developers to create web apps using C# and HTML, developed by Microsoft.

1,664 questions
Microsoft Security | Microsoft Entra | Microsoft Entra ID
asked 2024-11-18T11:43:25.1633333+00:00
Aidan Waterford 0 Reputation points