An Azure relational database service.
Unable to connect to SQL 2022 instance with Entra MFA after successfully implementing Entra MFA on Azure ARC
We are unable to connect to SQL 2022 instance with Entra MFA after successfully implementing Entra MFA on Azure ARC Upon checking the on-prem SQL server logins, the Entra Admin account is still not added under logins. There is no Federated Authentication…
Azure SQL Database
Soft-deleted Azure SQL logical server cannot be restored - deletedServers API returns the record but restore fails with SubscriptionDoesNotHaveServer
Summary I accidentally deleted an Azure SQL logical server and cannot restore it, despite the soft-deleted record existing and being well inside its retention window. Environment Server: actually-split-db-server Region: UK South Resource group:…
Azure SQL Database
An Azure relational database service.
Unable to create technical support request with active Developer Support plan
We recently upgraded our Azure support plan from Basic to Developer. I am an Owner of the affected Azure subscription. However, when I try to create a technical support request, either from the affected Azure SQL resource/alert or through Help + support,…
Azure SQL Database
An Azure relational database service.
I am locked out of my Azure account.
I am locked out of my Azure account. I am the only person that uses it. Azure tells me to contact my admin to get permissions but I am the only person in my company. How do I contact a human at Azure to fix this?
Azure SQL Database
An Azure relational database service.
Problem: Sync-Gruppe ist "invalid" (Fehler beim Lesen), Löschversuch hängt seit >30 Min in "InProgress"
Subscription-ID: f3e2736f-fcd9-4d84-ba44-8bd8e098d43c Resourcengruppe: Kalibrierung Server: kaldat-2020 Datenbank (Hub): Kaldat2022 Sync-Gruppen-Name: MW Async-Operation-ID: 7beb56ca-a3a5-4d1e-a4f7-570a0a9b24f3
Azure SQL Database
An Azure relational database service.
How do I fix a connection access issue to my database server on azure?
|System.Data.SqlClient.SqlException: Database 'GetSketchy_QA' on server 'getsketchy-serverqa.database.windows.net' is not currently available. Please retry the connection later. If the problem persists, contact customer support, and provide them the…
Azure SQL Database
An Azure relational database service.
Cannot access Azure SQL database from SSMS.
I have created an Azure SQL DB with Entra ID authentication. I cannot access the database from my Windows workstation using SSMS. I need somebody to help me get all the settings set up correctly so that I have smooth access to the database from SSMS.
Azure SQL Database
An Azure relational database service.
Getting Issue with CES unable to connect with Azure Event Hub
Earlier CES working with Destination Type = AzureEventHubsAmqp this was working with same Credentials and everything but now my Azure SQL Database update and not accepting above destination type and restrict to pass AzureEventHubs only then it is not…
Azure SQL Database
An Azure relational database service.
IP communication to Azure SQL server suddenly 10 times slower than usual.
IP communication from our office (data centre) to Azure SQL server suddenly 10 times slower than usual. psping usually take 10 msec or less but now 70 - 100msec resulting some apps very slow. I can send you psping / tracert results over email. Regards,
Azure SQL Database
An Azure relational database service.
Billing question
My DB invoice was too high last month. I need to understand the reason so that I can proactively manage it. I do have budget set up but I didn't get any notification and received a high invoice. My database and usage are not high to be charged $180…
Azure SQL Database
An Azure relational database service.
I'm unable to delete the DataSync table
I have been unable to delete the DataSync table, the sync metadata database, which we are not using anymore as we moved away from DataSync groups. The data sync group was deleted, and then I've applied all cleanup scripts so we don't have any of the data…
Azure SQL Database
An Azure relational database service.
How to set Azure SQL Database default_database to NewDatabase
How do we change the default database for a new user to our [new database] instead of master. we are using Azure SQL/ SQL database and getting the error 'Keyword or statement option 'default_database' is not supported in this version of SQL Server.' …
Azure SQL Database
An Azure relational database service.
All Azure resources missing after subscription reactivation — backend investigation required before retention deadline
My Azure Pay-As-You-Go subscription was cancelled and subsequently reactivated. The subscription now displays Active, but all resources that previously existed under it are missing. This includes: Resource groups Azure SQL databases Storage Accounts …
Azure SQL Database
An Azure relational database service.
Sending SQLSecurityAudit logs to multiple Log Analytics workspaces
We're trying to get logging (SQL Security Audit specifically) to both an "Operations" LAW as well as Sentinel workspace. Scenario; Create SQL Server, set SQL Auditing to send to Sentinel workspace Create sample DB Create diagnostics…
Azure SQL Database
An Azure relational database service.
Data Sync - Adding On Prem DB is "AdAzure SQL Data Sync – Unable to Add New On-Premises Databases After Unregistering Previous Databasesd Failed"
We are facing an issue with our Azure SQL Data Sync configuration. The previous on-premises databases/members were unregistered and removed, and we also performed cleanup and restarted the Data Sync Agent. However, we are still unable to add the new…
Azure SQL Database
An Azure relational database service.
Azure SQL Database login fails with error 916 for least-privilege SQL user and managed identity, but admin login works
I am trying to connect an Azure App Service application to Azure SQL Database using a least-privilege account. The admin SQL login can connect successfully, but non-admin access fails. Environment: Azure App Service connecting to Azure SQL Database …
Azure SQL Database
An Azure relational database service.
Azure SQL Database: Managed identity login fails with error 18456
I have a user-assigned managed identity with an existing contained database user in an Azure SQL Database that cannot log in via Azure AD authentication. Every attempt fails with a login error naming a token-identified principal as unable to log in. I…
Azure SQL Database
An Azure relational database service.
Point-in-time restore (RESTORE LOG phase) extremely slow on SQL Managed Instance - stuck in IO_COMPLETION for 4+ hours
Problem summary: A point-in-time restore of a 34 GB database is taking over 4 hours and has not completed. The operation is active (not failed) but progressing extremely slowly. It appears to be I/O-bound on the remote storage rather than CPU- or…
Azure SQL Database
An Azure relational database service.
Data Sync - Adding On Prem DB is "Add Failed"
Adding On Prem DB is "Add Failed" Failed to perform data sync operation: Cannot create sync member 'XXX_1' because the maximum number of on-premise database as sync member can be created under a sync group is 5 for Basic sync group, But i have…
Azure SQL Database
An Azure relational database service.
How to set up new SQL server database
I am using enterprise SQL at work and would like to practise my coding from a home laptop. With no previous experience, how do I configure my azure account to create a simple SQL database that I can load data to and use SSMS?
Azure SQL Database
An Azure relational database service.