Azure SQL Database
An Azure relational database service.
5,252 questions
0 answers
403 Forbidden Error When Running SSRS Reports from Azure Web App within VNet
Hello everyone, I’m facing an issue with accessing SSRS reports hosted on a virtual machine from an Azure Web App with the database on a separate managed instance and the SSRS on a VM with access done via URL. Here’s the situation: The reports execute…
Azure SQL Database
.NET
.NET
Microsoft Technologies based on the .NET software framework.
3,485 questions
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
7,079 questions
asked 2024-05-28T00:13:24.8333333+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(243.2, 72%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECB%3C/text%3E%3C/svg%3E)
Chris Boyce
20
Reputation points
edited the question 2024-06-04T11:00:39.5166667+00:00
vipullag-MSFT
25,126
Reputation points
1 answer
Azure Elastic Job execution failing
I have created an Azure Elastic Job following the example here: https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-jobs-tsql-create-manage?view=azuresql However, the job execution if failing with the following: Failed to determine members…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
5,252 questions
Azure
Azure
A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.
1,008 questions
asked 2024-05-23T21:41:42.6033333+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(128, 66%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
Scott Klein
161
Reputation points
commented 2024-06-04T09:22:16.5666667+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
14,081
Reputation points Microsoft Employee
1 answer
Can we execute a Stored procedure(Azure SQL DB) through Databricks Notebook??
I already have a stored Procedure which has Merge Statement logic, I would like to execute this SP through Databricks notebook. Is there a way to do this?
asked 2022-04-20T08:16:44.697+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, 16%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAR%3C/text%3E%3C/svg%3E)
Anusha Rudra
1
Reputation point
commented 2024-06-04T05:25:20.0466667+00:00
Vedant Desai
631
Reputation points
0 answers
SSMS cannot connect to azure sql db using Microsoft Entra MFA
I just recently updated ssms to 20.1 and am trying to connect to the azure sql via pt-dw.database.windows.net. When I press the "Connect" button, it takes a long time for the browser window to pop up and allow me to choose which account to use…
asked 2024-06-04T02:45:12.8466667+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(272, 2%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFT%3C/text%3E%3C/svg%3E)
Ferdinand Tomale
0
Reputation points
commented 2024-06-04T04:58:13.14+00:00
Ferdinand Tomale
0
Reputation points
0 answers
I Got The resource write operation failed to complete successfully, because it reached terminal provisioning state 'Failed'
Hello team. I got the error below when I creating an SQL virtual machine instance: { "code": "DeploymentFailed", "target":…
asked 2024-06-03T09:43:15.31+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, 14.000000000000002%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPP%3C/text%3E%3C/svg%3E)
Plamen Peev
0
Reputation points
commented 2024-06-04T04:50:55.34+00:00
Plamen Peev
0
Reputation points
0 answers
Does the current SQL Database TLS Policy check if nothing is selected?
We recently implemented a built-in Azure Policy, that checks for the minimum TLS Version to be 1.2. -…
asked 2024-06-04T00:35:40.3333333+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(176, 48%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPG%3C/text%3E%3C/svg%3E)
Pooja Goel
0
Reputation points
asked 2024-06-04T00:35:40.3333333+00:00
Pooja Goel
0
Reputation points
2 answers
How to fix "Failure happened on 'Source' side A task was canceled" error
Data load from Salesforce object with 1million records fails with the below error in Azure Data Factory: Failure happened on 'Source' side. 'Type=System.Threading.Tasks.TaskCanceledException,Message=A task was canceled.,Source=mscorlib,' The data load…
asked 2024-05-28T18:42:40.6+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, 64%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETK%3C/text%3E%3C/svg%3E)
thara kollu
0
Reputation points
edited a comment 2024-06-03T19:43:19.8566667+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(12.8, 48%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH%3C/text%3E%3C/svg%3E)
Harishga
4,485
Reputation points Microsoft Vendor
1 answer
Creating new linked services returns SqlFailedToConnect
I'd like to start by first stating that this is a continuation of my efforts to connect an Azure SQL DB to Data Factory via the Linked services. Creating new linked services returns InvalidCredentialReference My new error is below in the azure portal in…
asked 2024-05-20T17:06:25.38+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(278.4, 2%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKP%3C/text%3E%3C/svg%3E)
Kristina Payan
0
Reputation points
commented 2024-06-03T19:01:15.4233333+00:00
Oury Ba-MSFT
16,906
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
Why are users not able to login to restored DB after the backup is restored to another SQL server?
I have restored a sql database in another server, but existing users are not able to access the newly restored database. Please advise.
asked 2021-03-27T01:56:41.99+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(214.4, 38%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELM%3C/text%3E%3C/svg%3E)
Lawrence080-MSFT
46
Reputation points Microsoft Employee
commented 2024-06-03T18:14:11.5166667+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(272, 52%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERU%3C/text%3E%3C/svg%3E)
Robert Urbanek
1
Reputation point
0 answers
Issue Connecting With An Azure SQL Database from .NET WinForms Application
I'm having an issue connecting to an Azure SQL database from a WinForms application after it has been packaged using InstallShield. The database exists on a virtual network and I'm using a virtual network gateway point-to-site connection. The database is…
asked 2024-05-22T16:37:29.1633333+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(224.00000000000003, 13%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET%3C/text%3E%3C/svg%3E)
Tom
1
Reputation point
commented 2024-06-03T18:11:31.2133333+00:00
Oury Ba-MSFT
16,906
Reputation points Microsoft Employee
2 answers
convert pay as you go instance into reserved instance
Hi, I have nearly 12 instances and databases in different regions and I want to change them to Reserved Instances and databases. What is the procedure to implement them as Reserved Instances and databases? Can anybody help me? Do I need to purchase…
asked 2024-05-30T06:19:16.89+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, 37%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERS%3C/text%3E%3C/svg%3E)
Revathi Senthilkumar
0
Reputation points
commented 2024-06-03T16:18:32.8133333+00:00
Oury Ba-MSFT
16,906
Reputation points Microsoft Employee
1 answer
Azure Data Studio - Can we do online migratation of same db on prem sql to two different target(sql manged insance)
Hi Azure Data Studio - Can we do online migratation same db (on prem sql) to two different target(sql manged instance) wiht azure migration extension in azure data studio I am wondering what does the tool do as part of cutover.What activities are done…
![](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(124.80000000000001, 84%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENV%3C/text%3E%3C/svg%3E)
1 answer
%%LOCKRES%% - SQL Server - Row identifier causing Deadlocks
Hi Team, Recently I came across an issue where I am facing deadlocks in SQL Server databases (19.2.56.2) due to the internal hashing mechanism of the Row identifier virtual column - %%LOCKRES%% On analysis I find that the row identifier - %%LOCKRES%%…
asked 2024-06-02T06:24:20.88+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, 67%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EG%3C/text%3E%3C/svg%3E)
Govar1604
0
Reputation points
commented 2024-06-03T12:06:13.89+00:00
Erland Sommarskog
102.7K
Reputation points
1 answer
How do I move an Azure SQL Managed Instance from one resource group to another with in same subscription?
Hello, I have an Azure SQL Managed instance deployed with in a resource group. I need to move my Azure SQL Managed instance from the existing resource group (RG1) to another resource group (RG2). Kindly help me with the procedure to move the Azure SQL…
asked 2024-06-03T10:06:01.3466667+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, 23%, 13%)' 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)
Sharma, Mukul
1
Reputation point
commented 2024-06-03T11:55:17.83+00:00
Sharma, Mukul
1
Reputation point
1 answer
Azure Data Studio - Data Migration Extension
Hi We used the data migration extension in Azure data studio to migrate sql server db to SQL MI We stored all the backups to hte azure blob container We started the migration Once all the backups showed restored. We marked the db as read only. We…
3 answers
Looking for guidance on integrating third-party data into our domain
Hi, My company's transactional system is MS Dynamics 365. We need to import various third-party data into our domain. I'm a Power BI developer but have been assigned this project. I'm looking for guidance on a suitable database and integration tool. …
asked 2024-04-18T16:54:37.4433333+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(67.2, 21%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anon101
51
Reputation points
answered 2024-06-03T10:47:20.6633333+00:00
Pinaki Ghatak
2,480
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
How to identify usage of Azure SQL Database 2014-04-01 APIs
I have a very old windows forms project using azure database and I'm very unsure if this project is affected by the API retirement. The project uses DataSets, TableAdapters and the old library Microsoft.Practices.TransientFaultHandling. Is this going to…
Windows Forms
Windows Forms
A set of .NET Framework managed libraries for developing graphical user interfaces.
1,857 questions
Azure SQL Database
Azure SQL Database
An Azure relational database service.
5,252 questions
Windows 10
Windows 10
A Microsoft operating system that runs on personal computers and tablets.
10,871 questions
.NET
.NET
Microsoft Technologies based on the .NET software framework.
3,485 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,428 questions
![](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(51.2, 69%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBW%3C/text%3E%3C/svg%3E)
1 answer
How do I give a user access to a single App Server, SQL Database, & Azure Storage
Hi; I want to have my QA team do some load testing of the dev slot of our web app. I want to give them full administrative access to the dev slot app service and its associated SQL Database and BLOB Storage. I do not want them to have any administrative…
asked 2024-05-31T22:32:34.61+00:00
David Thielen
2,396
Reputation points
answered 2024-06-03T07:51:19.09+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(185.6, 59%, 27%)' 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)
SnehaAgrawal-MSFT
19,186
Reputation points
1 answer
One of the answers was accepted by the question author.
Use managed identities to connect to a Azure SQL database
I have a question regarding the use of managed identities to connect to a SQL database. Do I need the ‘db_ddladmin’ role for this, or is it only necessary if I’m going to perform operations like CREATE, DROP, etc.? Additionally, if my managed identity is…
![](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(192, 85%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJC%3C/text%3E%3C/svg%3E)
2 answers
Trying to import On Prem sql server into azure managed instance but it's failing
Trying to import On Prem Sql server into azure managed instance but it's failing.What should I do?
asked 2024-05-30T00:36:18.8766667+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(153.6, 44%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET%3C/text%3E%3C/svg%3E)
TymeMachine
0
Reputation points
commented 2024-06-03T05:14:43.19+00:00
ShaktiSingh-MSFT
14,081
Reputation points Microsoft Employee