Azure SQL Database
An Azure relational database service.
5,750 questions
1 answer
server Error in '/' Application
When logging into our Rock portal this message pop up and we can not access the platform
asked 2024-11-05T17:33:24.8433333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 25%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBA%3C/text%3E%3C/svg%3E)
BCC Admin
0
Reputation points
commented 2024-11-06T17:13:15.6866667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 60%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
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…
asked 2024-11-04T14:48:22.59+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(249.60000000000002, 87%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Aparna Manoharan
20
Reputation points
commented 2024-11-06T17:07:38.0666667+00:00
Mahesh Kurva
725
Reputation points Microsoft Vendor
3 answers
One of the answers was accepted by the question author.
If I have OpenText Application and SQL running in azure VM 2008 Windows OS, these two are old versions and can't be updated with TLS1.2 . Will it continue to work after 31st October with TLS1.0 / TLS 1.1. ? Is there any workaround you can SUGGEST
Hi TP,If I have OpenText Application and SQL running in azure VM 2008 Windows OS, these two are old versions and can't be updated with TLS1.2 . Will it continue to work after 31st October with TLS1.0 / TLS 1.1. ? Is there any workaround you can SUGGEST
asked 2024-10-22T14:16:19.24+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 84%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA3%3C/text%3E%3C/svg%3E)
AnantAditya-3219
20
Reputation points
edited the question 2024-11-06T15:29:36.8133333+00:00
Prrudram-MSFT
25,156
Reputation points
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…
asked 2024-11-06T08:14:30.0266667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(44.800000000000004, 28.000000000000004%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN4%3C/text%3E%3C/svg%3E)
NavasMiguel-4566
0
Reputation points
edited a comment 2024-11-06T15:16:12.31+00:00
NavasMiguel-4566
0
Reputation points
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…
asked 2024-11-05T13:04:02.9933333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(198.4, 73%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Ayush Singh
0
Reputation points
commented 2024-11-06T14:25:48.6766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(227.2, 46%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENN%3C/text%3E%3C/svg%3E)
NIKHILA NETHIKUNTA
2,950
Reputation points Microsoft Vendor
2 answers
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…
asked 2024-11-05T15:23:31.4733333+00:00
Aparna Manoharan
20
Reputation points
answered 2024-11-06T14:15:04.9366667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(35.2, 49%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVK%3C/text%3E%3C/svg%3E)
Vijayalaxmi Kattimani
405
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…
asked 2024-11-06T07:54:24.8666667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(313.6, 84%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJK%3C/text%3E%3C/svg%3E)
Jerald K Philip
0
Reputation points
commented 2024-11-06T13:31:47.37+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(268.8, 8%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EST%3C/text%3E%3C/svg%3E)
Smaran Thoomu
16,730
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
Azure SQL DB DTU Increasing
I have to Increase my Azure SQL Single database DTU from Standard S2 (50 DTU) to Standard S3 (100 DTU). How much time it will take and is there any Downtime required for that?
asked 2024-11-05T06:53:35.6066667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 28.999999999999996%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESP%3C/text%3E%3C/svg%3E)
Sudhakar P
20
Reputation points
edited a comment 2024-11-06T12:11:17.1366667+00:00
Sudhakar P
20
Reputation points
1 answer
Cannot connect to SQL Database. Please contact SQL server team for further support. Server: 'sql.propvivo.com', Database: 'MicrosoftDynamicsAX', User: 'corpwebapi'. Check the linked service configuration is correct, and make sure the SQL Database firewall
i am trying to login the ax database with sql server in datafactory to store the data in datalake storage, it is showing connection failed where as my server name, username and passwords are correct with this credentials i can easily access the…
asked 2024-11-05T05:14:22.6933333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(3.2, 85%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Anshuman Srivastava
10
Reputation points
commented 2024-11-06T12:10:48.2133333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 4%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
ShaktiSingh-MSFT
15,341
Reputation points
0 answers
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…
asked 2024-10-16T11:17:39.85+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(217.60000000000002, 18%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERL%3C/text%3E%3C/svg%3E)
Rob Lewis
0
Reputation points
commented 2024-11-06T11:29:21.2133333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(198.4, 69%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Sai Raghunadh M
970
Reputation points Microsoft Vendor
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…
asked 2024-11-05T10:49:37.1+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(188.79999999999998, 80%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAN%3C/text%3E%3C/svg%3E)
Akash Narvaria
0
Reputation points
commented 2024-11-06T10:43:01.08+00:00
Vijayalaxmi Kattimani
405
Reputation points Microsoft Vendor
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:…
asked 2024-11-04T15:17:49.8866667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(300.8, 23%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN%3C/text%3E%3C/svg%3E)
nikithakoshy
80
Reputation points
edited a comment 2024-11-06T10:28:58.7933333+00:00
Mahesh Kurva
725
Reputation points Microsoft Vendor
0 answers
Failing to connect to SQL Database from Azure Web App.
I got an ASP.NET Core Web App with Angular and MS SQL. Locally, I run MS SQL via Docker, which works good. I can run migrations and seed data without problem. When I uploaded the web app to an Azure resource group, I created a web app, database server…
asked 2024-11-06T01:31:13.9666667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(64, 24%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENT%3C/text%3E%3C/svg%3E)
Nemanja Tomic
0
Reputation points
edited a comment 2024-11-06T08:43:04.28+00:00
JasonPan - MSFT
5,906
Reputation points Microsoft Vendor
1 answer
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…
asked 2024-11-04T00:57:00.4233333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(313.6, 28.000000000000004%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
jclOnana
5
Reputation points
commented 2024-11-06T08:00:06.1133333+00:00
Vijayalaxmi Kattimani
405
Reputation points Microsoft Vendor
1 answer
how to minimize cost for using Azure SQL database for learning with few tables(may be 10) with less than 100 records
hello I am new to Azure,want to learn SQL database in Azure.I am getting high cost with vCore charges. how to minimize cost for using Azure SQL database(compute charges) for learning with few tables(may be 10) with less than 100 records. Currently my…
asked 2024-11-06T03:41:49.86+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(137.6, 10%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
anupama Madhav
0
Reputation points
answered 2024-11-06T05:03:16.3533333+00:00
NIKHILA NETHIKUNTA
2,950
Reputation points Microsoft Vendor
1 answer
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…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(310.4, 41%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
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
asked 2024-11-05T17:23:07.8533333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(217.60000000000002, 30%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESA%3C/text%3E%3C/svg%3E)
Spaulding, Anthony
0
Reputation points
commented 2024-11-06T02:37:40.3433333+00:00
NIKHILA NETHIKUNTA
2,950
Reputation points Microsoft Vendor
2 answers
Update your scripts to point to a new folder for Server level audit logs
I received this notice from MS and I logged int my Azure portal looking for this but unable to locate. Where can I find this to update the required information? You're receiving this notice because you use Azure SQL Database Server Audit. In February…
asked 2024-06-20T12:33:47.4633333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(275.2, 89%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPN%3C/text%3E%3C/svg%3E)
Phong Nguyen (DA)
15
Reputation points
commented 2024-11-05T21:50:33.8+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 67%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAA%3C/text%3E%3C/svg%3E)
Amal Agwan
0
Reputation points
1 answer
One of the answers was accepted by the question author.
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…
asked 2024-11-04T12:29:03.7233333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(16, 16%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFG%3C/text%3E%3C/svg%3E)
Fernando Gutierrez
220
Reputation points
accepted 2024-11-05T18:34:41.34+00:00
Fernando Gutierrez
220
Reputation points
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.?
asked 2024-11-04T15:36:00.9633333+00:00
Aparna Manoharan
20
Reputation points
edited an answer 2024-11-05T16:33:57.5+00:00
Vinodh247
22,951
Reputation points MVP