Azure SQL Database

How to find ARM resource id of the sync agent in the sync member.

Im trying to use New-AzSqlSyncMember for Sql Database member , And it requires a paremeter , SyncAgentId . How to find ARM resource id of the sync agent in the sync member in Azure portal.?

In the UK South region, we face SQL Server login issues. The ensureCreated method fails with “Login failed for user ‘myUsername’.”

In the UK South region, we are experiencing issues with the SQL Server login. Although we are using the correct username and password, the login fails when attempting to call the method ensureCreated from Entity Framework, we encounter the error:…

New-AzSqlSyncMember command fails

Im trying to create a sync member for an on-premises SQL Server database , Im using the command - New-AzSqlSyncMember -ResourceGroupName "ResourceGroup01" -ServerName "Server01" -DatabaseName "Database01" -SyncGroupName…

SQL Server Agent in Azure SQL Server

Hello, I would like to know if you can help me with a problem I am having. I have Azure SQL Data Bases which are managed through SQL Management Studio. I need to check some of these Databases to see if they have Jobs configured, but I cannot see the SQL…

How to restore database that are part of azure data sync group?

How to restore on-prem and azure sql database that are part Azure data sync group? When Azure sql database which is part of azure data sync group is restored, the sync group gets deleted automatically? How to restore both on-prem and azure sql database…

Azure Data Bases - Job

Hello, I would like help with the following question. I need to create a job or a Debugging task in Azure Data Bases, which runs automatically on certain days and times. I have the Query with Delete, but I need to leave it configured to run…

Command 'CREATE LOGIN FROM EXTERNAL PROVIDER' is not supported as Azure Active Directory is not configured for this instance.

We have an SQL Server on an Azure VM. For our main instance, which is our live one, Entra euthentication works without any problem. We can create and login directly using Entra authentication. We also have another instance of SQL on the same server…

Can't connect to Azure services through VPN Gateway

Hi, Since this morning, my team and I can't connect to the different Azure services we use, more specifically Azure Database and Azure Storage. We use a VPN Gateway to connect to our Azure Virtual Network in which the different services are connected.…

How to keep data consistency for read replica in Azure SQL MI

Hi, I have a question about read replica in Azure SQL MI. The question is how to keep data consistency for read replica? transaction log or something else. Is there any document about this? best regards Jindong

Login Issues with SQL Authentication After Enabling Entra ID Authentication

Previously, SQL Server was authenticated using SQL authentication, and I enabled Microsoft Entra ID authentication to allow direct connections to the database via SSMS. I implemented Entra ID authentication without removing the existing SQL…

The Resource 'Microsoft.Web/sites/vcpbasicplanexpressappwebapp/slots/g4hwaqgebvfedpdn' under resource group 'vcpbasicplanexpressappresourcegroup' was not found.

My current context is Have azure account, subscription to basic plan Locally, I am using MacBook Pro sequoia 15 Backend is express.js sequelize, tedious, migration, works and can connect to a database located in azure sql database. It worked.   in order…

service dependencies

Azure SQL Database backups, PITR and LTR with Failover Groups

Let’s say I have two Azure SQL DB servers which participate in a failover group (one server in east, the primary, and the other in west, the read-only secondary). There are roughly a dozen databases on the servers that belong to the failover group. These…

Azure SQL Database vs Azure Database for MySQL

"I'm working on a project We're considering using either Azure SQL Database or Azure Database for MySQL for the relational data. I've noticed that Azure SQL Database tends to be more expensive. Can someone explain the main differences between Azure…

Sqlconnectionstring using managed identity in sql trigger

I have an azure function that has a connection string that needs to use the managed identity assigned to it. The managed identity is a user assigned identity. What is the syntax of the connection string ?

Clients inside the network cannot connect to Azure SQL Database using SQL Studio.

We are trying to establish a connection to an SQL Database on Azure using SQL studio. We are receiving the error message below.

Database re-provisioning failed with the exception "The schema info could not be retrieved from the schema info table.

Database re-provisioning failed with the exception "The schema info could not be retrieved from the schema info table. For more information, provide tracing ID ‘a991aa28-7145-459b-9530-e009fb53708d’ to customer support."

How can I use sys.fn_get_audit_file_v2 (or sys.fn_get_audit_file) to read .sqlaudit files stored in blob storage?

How can I query my .sqlaudit files stored in a blob container within an azure storage account? Details: I have thousands of .sqlaudit files created from Server Audit configurations on over a hundred SQL 2016 and SQL 2019 servers. When I place these files…

Connectivity from Azure extension for SQL Server to DPS is not OK

Hi I'm trying to register my machine / on-prem SQL Server instance with my Azure subscription. I've done it two different ways because the first one failed. In both cases the machine seemed to register successfully (it's visible within Azure Arc), but…

Error SQL71621: Azure Key Vault URI '' must be an well-formed, absolute URL

I have an Azure SQL Database using Always Encrypted with the Column Master Key being stored in Azure Key Vault. The project is in Azure DevOps and I am using the Azure SQL DacpacTask to deploy my releases to my dev and prod environments. I am using a…