I am trying to make connection through Azure Databricks to Azure SQL Server and if database is not available, then create a new one and same for table but getting error for ODBC driver How to install 'ODBC Driver 17…
I have an on-premises console application through which I am accessing Azure SQL Server. Currently I am using the user name/password connection string to connect to Azure SQL. I would like to use managed identity to connect to Azure SQL…
I am encountering an error when configuring a SQL Server connection string in my Azure Function App using KeyVault to retrieve the connection string. The error message I receive is: Message Error configuring services in an external startup class. Details…
I need remove the all comments in a SQL view created in Azure SQL Data Warehouse. Create the query without comments (/* */ ; -- , ...); regular expression functions not working Query: CREATE VIEW [dimension].[v_dim_customer] AS SELECT -- primary…
I have a C# .NET 8 isolated Azure Function App that I am trying to connect to a SQL database, but I am having trouble trying to locate the problem. The SqlException: A network-related or instance-specific error occurred while establishing…
For one of our clients I'm configuring a build and deployment pipeline in Azure DevOps for an Azure SQL database. We have done this many times before without issue, but this is the first time I'm using a service connection…
I have created a bacpac backup from Azure SQL database and I want to restore it to AWS RDS SQL server. But when I try to import the .bacpac file to RDS, I get the following error. Error SQL72014: Core…
I have a pretty large (250gb) Azure SQL database which is mostly used for a multi-tenant transactional point of sale system. We have a lot of business reports which are essentially stored procedures sitting behind a reporting framework (Telerik Reports).…
I have a group of linux web apps with VNet Integration enabled on a subnet called web-tier and an azure server with private link configured on another subnet called data-tier. I have also added nsg rules to the data-tier subnet…
I've setup an AzureSQL failover group using a bicep, with very simple settings. The first deployment works as expected. If I deploy again, without making any changes, I get this error: The property targetServer of the read-only endpoint must be…