5,754 questions with Azure SQL Database tags

Sort by: Updated
1 answer

Permission Issues with Application Registration for Creating External Users in Azure Synapse Databases

Hello everyone, I’m encountering an issue with an Application Registration in Azure AD that needs to create external users in several on-demand Azure Synapse databases across multiple environments. Despite configuring the necessary permissions in Azure…

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.
4,996 questions
Microsoft Entra
Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
22,093 questions
asked 2024-11-06T08:14:30.0266667+00:00
NavasMiguel-4566 0 Reputation points
commented 2024-11-07T20:01:01.68+00:00
Raja Pothuraju 7,750 Reputation points Microsoft Vendor
1 answer

Issue when trying to use [AzureSqlSyncGroupSchemaModel]::new()

using namespace Microsoft.Azure.Commands.Sql.DataSync.Model $newSchema = [AzureSqlSyncGroupSchemaModel]::new() Running this command on cloud powershell fails with error InvalidOperation: Unable to find type [AzureSqlSyncGroupSchemaModel]. Im trying to…

Azure SQL Database
asked 2024-11-05T15:23:31.4733333+00:00
Aparna Manoharan 20 Reputation points
edited a comment 2024-11-07T19:28:36.31+00:00
Vijayalaxmi Kattimani 405 Reputation points Microsoft Vendor
2 answers

Issue with Deploying Azure SQL Server Managed Instances: “Your deployment failed”

Hello, I am encountering an issue while trying to deploy Azure SQL Server Managed Instances. The deployment process fails with the message “Your deployment failed.” I have attached a screenshot of the deployment details and included the error message…

Azure SQL Database
Azure Storage Accounts
Azure Storage Accounts
Globally unique resources that provide access to data management services and serve as the parent namespace for the services.
3,220 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,981 questions
asked 2024-11-05T09:15:43.5866667+00:00
DoFast 26 Reputation points
commented 2024-11-07T19:01:04.11+00:00
Mahesh Kurva 725 Reputation points Microsoft Vendor
1 answer

Connection time out issue in Manged vnet IR from ADF to SQL. How to resolve?

We are using Managed Vnet integration runtime to connect between Azure data factory and SQL DB. This was suggested by microsoft since our Azure SQL is private only, and Autoresolve IR wont work. We tried with SHIR earlier, but since we are using…

Azure SQL Database
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,833 questions
asked 2024-11-06T07:54:24.8666667+00:00
Jerald K Philip 0 Reputation points
commented 2024-11-07T18:40:26.5+00:00
Smaran Thoomu 16,735 Reputation points Microsoft Vendor
0 answers

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."

Azure SQL Database
asked 2024-10-31T19:37:36.5766667+00:00
John Tran 0 Reputation points
edited the question 2024-11-07T18:25:32.4233333+00:00
Oury Ba-MSFT 19,581 Reputation points Microsoft Employee
1 answer

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.?

Azure SQL Database
asked 2024-11-04T15:36:00.9633333+00:00
Aparna Manoharan 20 Reputation points
commented 2024-11-07T18:23:53.6+00:00
Oury Ba-MSFT 19,581 Reputation points Microsoft Employee
1 answer One of the answers was accepted by the question author.

Moving data from Snowflake to Azure SQL DB using Copy Activity

Hi All, I am using COPY activity to move data from Snowflake to Azure SQL DB. First of all, this data movement is not allowed without intermediate staging of the data in ADLS. I would love to avoid this intermediate step. If this is how it will work then…

Azure SQL Database
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,833 questions
asked 2024-09-04T14:26:06.79+00:00
PK 20 Reputation points
commented 2024-11-07T18:05:48.26+00:00
PK 20 Reputation points
1 answer

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:…

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,981 questions
asked 2024-11-04T15:17:49.8866667+00:00
nikithakoshy 80 Reputation points
commented 2024-11-07T17:55:35.13+00:00
Mahesh Kurva 725 Reputation points Microsoft Vendor
0 answers

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…

Azure SQL Database
asked 2024-11-04T14:48:22.59+00:00
Aparna Manoharan 20 Reputation points
commented 2024-11-07T17:50:04.5133333+00:00
Mahesh Kurva 725 Reputation points Microsoft Vendor
1 answer

How to fix "Selected user account does not exist in tenant 'Microsoft Services'" when using Microsoft Entra to access Azure SQL Server?

I'm encountering the following error when trying to access my Azure SQL Server using Microsoft Entra: Selected user account does not exist in tenant 'Microsoft Services' and cannot access the application '04b07795-8ddb-461a-bbee-02f9e1bf7b46' in that…

Azure SQL Database
Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
22,093 questions
asked 2024-11-07T16:49:33.31+00:00
Ryan M 0 Reputation points
answered 2024-11-07T17:47:15.7333333+00:00
Deepanshukatara-6769 10,215 Reputation points
1 answer

server Error in '/' Application

When logging into our Rock portal this message pop up and we can not access the platform

Azure SQL Database
Windows 10
Windows 10
A Microsoft operating system that runs on personal computers and tablets.
11,712 questions
Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
7,991 questions
Azure Managed Applications
Azure Managed Applications
An Azure service that enables managed service providers, independent software vendors, and enterprise IT teams to deliver turnkey solutions through the Azure Marketplace or service catalog.
148 questions
Windows Server PowerShell
Windows Server PowerShell
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.PowerShell: A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
5,552 questions
asked 2024-11-05T17:33:24.8433333+00:00
BCC Admin 0 Reputation points
commented 2024-11-07T17:42:34.54+00:00
Mahesh Kurva 725 Reputation points Microsoft Vendor
0 answers

Having trouble trying to remove the BATCH_COMPLETED_GROUP audit action item group from the auditing setup

Having trouble trying to remove the BATCH_COMPLETED_GROUP audit action item group from the auditing setup from a Azure SQL server instance

Azure SQL Database
asked 2024-11-05T17:23:07.8533333+00:00
Spaulding, Anthony 0 Reputation points
commented 2024-11-07T17:20:55.6833333+00:00
Spaulding, Anthony 0 Reputation points
1 answer One of the answers was accepted by the question author.

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.…

Azure SQL Database
Azure VPN Gateway
Azure VPN Gateway
An Azure service that enables the connection of on-premises networks to Azure through site-to-site virtual private networks.
1,557 questions
asked 2024-10-30T17:09:26.5466667+00:00
Eric Brunet 20 Reputation points
accepted 2024-11-07T17:01:24.54+00:00
Eric Brunet 20 Reputation points
1 answer

after creating login in Azure SQL server, getting error while login to DB using SSMS

Hi, i am trying to connect to Azure sql server using sql authentication. but it is throwing error. i have followed the below steps to create login. Error attached for reference. Thanks CREATE LOGIN [john_doe] WITH PASSWORD = 'MySecurePassword123!'; --…

Azure SQL Database
asked 2024-11-07T08:53:18.8333333+00:00
Lakshmi Narayana Sarma Bhamidipati 90 Reputation points
commented 2024-11-07T16:27:40.19+00:00
Sai Raghunadh M 1,045 Reputation points Microsoft Vendor
1 answer

Parallel Execution or Multi Thread Execution of Stored Procedure.

Hi, I have a Stored Procedure, that compares data from multiple tables and adds into my main table. This Stored Procedure will run on a large amount of data to add data in the main table. What I need help with is that I want to run multiple instances of…

Azure SQL Database
asked 2024-11-05T13:04:02.9933333+00:00
Ayush Singh 0 Reputation points
commented 2024-11-07T16:23:39.9933333+00:00
NIKHILA NETHIKUNTA 3,105 Reputation points Microsoft Vendor
3 answers

Upload and restore .bak file to Azure SQL Database from Local Machine

I have a .bak file on my machine I am trying to restore into an azure database. I then created an Azure storage/blob account to hold this file, to restore via ssms but unfortunately, the file is large (about 35GB) and crashes my machine multiple times.…

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,981 questions
asked 2024-07-09T09:06:52.5033333+00:00
Babawale Dawodu 110 Reputation points
answered 2024-11-07T13:28:33.7833333+00:00
Denny Webb 1 Reputation point
0 answers

Unable to Connect to SQL Server Using ActiveDirectoryPassword Authentication

Encountering an issue while trying to connect to SQL Server using ActiveDirectoryPassword authentication. The error message states: "Failed to load MSAL4J Java library for performing ActiveDirectoryPassword authentication." For Info -> I…

Azure SQL Database
asked 2024-11-05T10:49:37.1+00:00
Akash Narvaria 0 Reputation points
edited a comment 2024-11-07T12:00:58.5266667+00:00
Vijayalaxmi Kattimani 405 Reputation points Microsoft Vendor
2 answers

Integrate Azure Powershell result into Azure workbook

I want to grab the PITR and longTermRetentionWeeks for all the sql databases in azure and display this along with some other basic values in azure workbook(for example subscription name, resource group name, db name, PITR, etc). Seems these 2 values are…

Azure SQL Database
PowerShell
PowerShell
A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
2,592 questions
asked 2023-05-22T23:21:41.7833333+00:00
William Li 0 Reputation points
commented 2024-11-07T11:38:56.54+00:00
Anil Kumar 0 Reputation points
1 answer

Defender cloud for SQL

Hello, when i navigate to defender cloud i got this warning. Anyone know if this process will have downtime for the SQL? Also is there any extra cost?

Azure SQL Database
Microsoft Defender for Cloud
Microsoft Defender for Cloud
An Azure service that provides threat protection for workloads running in Azure, on-premises, and in other clouds. Previously known as Azure Security Center and Azure Defender.
1,411 questions
asked 2024-11-07T07:21:09.8333333+00:00
Handian Sudianto 5,161 Reputation points
commented 2024-11-07T11:14:23.79+00:00
NIKHILA NETHIKUNTA 3,105 Reputation points Microsoft Vendor
0 answers

Azure Active Directoy

Hello everyone, how are you? I would like to ask all of you how can I resolve the error in the attached printout?Captura de tela 2024-11-06 192922.png i've tried everything and nothing ):

Azure SQL Database
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,833 questions
asked 2024-11-06T22:57:13.93+00:00
Gabriel Rozzato 0 Reputation points
commented 2024-11-07T04:26:52.34+00:00
NIKHILA NETHIKUNTA 3,105 Reputation points Microsoft Vendor