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…
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…
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…
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…
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 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.?
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…
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…
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…
server Error in '/' Application
When logging into our Rock portal this message pop up and we can not access the platform
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
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.…
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!'; --…
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…
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.…
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…
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…
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 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 ):