Azure SQL Database
An Azure relational database service.
6,842 questions
1 answer
Can't Create Database Scoped Credentials in Serverless synapse Database
When I run the below script, I am getting an error saying Incorrect syntax near IDENTITY
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.
5,573 questions
asked
2022-08-15T22:57:56.153+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(115.19999999999999, 67%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETG%3C/text%3E%3C/svg%3E)
Teja.Gudipati
31
Reputation points
answered
2026-11-13T05:57:17.6+00:00
Vinodh247-1375
44,281
Reputation points
Volunteer Moderator
0 answers
Database user password change in Azure SQL after Import bacpac
On Prem:\ I have a db called db1 User test is having access to db1 Now I have exported bacpac in Azure SQL Single DB: Import bacpac file Able to Connect with server admin and able to see db1 in Azure. Issue: I wanted to…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,842 questions
asked
2022-07-28T18:21:14.573+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, 51%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPM%3C/text%3E%3C/svg%3E)
Prakash M, Bhanu
211
Reputation points
0 answers
Is it possible to deploy a an Azure SQL database + server with only Azure Active Directory authentication via an ARM template?
Hi all, I am wondering whether I can deploy a Azure SQL server + database and assign a Azure Active Directory admin at the same time. I saw someone asked this question 5 years ago and I was wondering whether it is possible now.
SQL Server on Azure Virtual Machines
SQL Server on Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
461 questions
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,842 questions
asked
2022-07-19T16:12:57.49+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(22.400000000000002, 28.000000000000004%, 12%)' 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)
John
81
Reputation points
1 answer
Create Audit Trail from SQL CDC
I have a few tables on which I have enabled CDC. As each row in CDC table contains all the columns regardless if they were changed or not, so it becomes difficult to figure out only the changed data. Is there a way to create a single Audit Table with…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,842 questions
asked
2022-03-21T23:35:58.377+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(48, 68%, 14%)' 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)
Ajeet Singh
51
Reputation points
edited an answer
2026-11-13T04:55:15.68+00:00
Ajeet Singh
51
Reputation points
0 answers
Connecting RStudio Workbench Standard for Azure to an Azure SQL database.
If I use RStudio Workbench Standard for Azure. Is it possible to connect this to my Azure SQL database.
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,842 questions
asked
2022-03-07T17:31:38.45+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(310.4, 55.00000000000001%, 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)
derry
6
Reputation points
0 answers
Is that possible to trigger SQL Managed Instance Backup Manually by a script?
Hi everyone, We are going to build a SQL Managed Instance, as I known, the backup of SQL MI is automatically managed by Azure. How could we control the timepoint of SQL MI backup? Is there anyway to trigger the SQL MI backup by powershell, that…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,842 questions
asked
2021-12-03T11:57:47.213+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(150.4, 68%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEC%3C/text%3E%3C/svg%3E)
Eric Chen
96
Reputation points
0 answers
Azure sql and Visual Studio
how can i connect a database that is on azure servers to my visual studio uwp project. the goal of the project is to make the application work on different PCs from 1 database over the network
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,842 questions
asked
2021-10-19T21:11:48.403+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(22.400000000000002, 23%, 12%)' 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)
Руслан Савченков
1
Reputation point
0 answers
External table creation based on table from another server
Hi, I am trying to create an External table in one database server , by accessing some table from another Remote Database server. Creation of External Data source as well as External table was successful. But when I try to query the External…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,842 questions
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.
5,573 questions
asked
2021-08-16T13:20:42.01+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, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGS%3C/text%3E%3C/svg%3E)
Gowri Shankar
211
Reputation points
2 answers
Visual Basic app to connect to an online database
Hey Microsoft Community, I have an app with a login (name, email, and password) form and since it's hard to keep track of how many users are using the app, I want to know if it's possible and how to connect my Visual Basic application to an online…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,842 questions
Developer technologies | VB
Developer technologies | VB
An object-oriented programming language developed by Microsoft that can be used in .NET.
2,913 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(131.20000000000002, 78%, 22%)' 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)
1 answer
SQL login for DTU database
HI I am trialling creating a SQL database on Azure and I am trying to create a SQL login for a user but I am not sure how to do so. I can log in using my email ID and Azure authentication but some of my end-client applications allow only SQL…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,842 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(121.6, 43%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
4 answers
Invalid Object Name when attempting to insert data from a table in one DB to a table in another DB on the same server
I am attempting to perform an insert from a table in one database to a table in another database on the same server I have tried this: INSERT INTO SDCS_AUDIT.BMA_FORM_DATA (.....) and this: INSERT INTO [SDCS_AUDIT].[BMA_FORM_DATA] (...) as well as…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,842 questions
Developer technologies | Transact-SQL
Developer technologies | Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,702 questions
asked
2021-04-12T19:38:47.667+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' %3EJH%3C/text%3E%3C/svg%3E)
James Hackney
61
Reputation points
edited an answer
2026-11-13T04:27:48.13+00:00
James Hackney
61
Reputation points
1 answer
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.
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,842 questions
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
edited an answer
2026-11-13T04:26:37.34+00:00
Lawrence080-MSFT
46
Reputation points Microsoft Employee
0 answers
about permission, view server performance state denied in paas server database
i have read write permission to particular database in paas server, but while user run the update statement, it was throwing an error, like view server performance state denied, but when i try to give server performance state permission, throwing an…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,842 questions
asked
2025-05-07T13:17:12.07+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(134.4, 42%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3END%3C/text%3E%3C/svg%3E)
Naga Durga Devi Kannuri - Admin
20
Reputation points
0 answers
How to Retain User Logins & Passwords When Migrating Azure SQL Database via BACPAC
I have a production application running on Azure with an Azure SQL Server and a SQL Database inside it. In my application, all users are created at the database level with their passwords. I need to migrate this database to another Azure tenant by…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,842 questions
asked
2025-02-22T09:15:44.4733333+00:00
Raj Kadhi
20
Reputation points
0 answers
How to fix code throwing exception : Microsoft.Data.SqlClient.SqlException: 'Login failed for user '
Hi All, I'm encountering an issue while trying to connect to an Azure SQL Database using Microsoft Entra Authentication (formerly Azure AD). I am using DefaultAzureCredential in my .NET application to authenticate and retrieve the access token, but…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,842 questions
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
10,018 questions
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,660 questions
Developer technologies | C#
Developer technologies | 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.
11,580 questions
asked
2025-01-03T00:29:43.2+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(236.8, 13%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKB%3C/text%3E%3C/svg%3E)
Krishna Basavaraj K S
20
Reputation points
0 answers
How to publish a blazor website with sql sever that is giving the error HTTP Error 500.30 - ASP.NET Core app failed to start
hi, im trying to publish my blazor web app on azure however it fives me the error HTTP Error 500.30 - ASP.NET Core app failed to start. when i try to debug it and go into the diagnose page of the websever i get this error…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,842 questions
Developer technologies | .NET | Blazor
Developer technologies | .NET | Blazor
A free and open-source web framework that enables developers to create web apps using C# and HTML, developed by Microsoft.
1,663 questions
Microsoft Security | Microsoft Entra | Microsoft Entra ID
Microsoft Security | Microsoft Entra | Microsoft Entra ID
A cloud-based identity and access management service for securing user authentication and resource access
30,974 questions
asked
2024-11-18T11:43:25.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(118.4, 57.99999999999999%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAW%3C/text%3E%3C/svg%3E)
Aidan Waterford
20
Reputation points
0 answers
AzureSQLDataBaseでクエリタイムアウトを設定したい。/ I want to set QueryTimeOut in AzureSQLDataBase.
教えてください。 AzureSQLDatabeseでQueryTimeOutを設定したいです。 30秒でタイムアウトとなるようにするにはどうすればよいでしょうか？ =================== Translation to English. I want to set QueryTimeOut in AzureSQLDatabase. How can I make sure that the timeout will be 30 seconds?
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,842 questions
asked
2024-07-31T07:50:19.35+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(73.60000000000001, 19%, 17%)' 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)
亮二 引地
20
Reputation points
0 answers
synapse pyspark write dataframe to sql azure
I want to use Pyspark datawrite.write method to write dataframe to sql azure database with linked service. How can I achieve it?
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,842 questions
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.
5,573 questions
asked
2024-07-26T23:35:52.9533333+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, 49%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESZ%3C/text%3E%3C/svg%3E)
Simon Zhang
6
Reputation points Microsoft Employee
0 answers
Rewriting Code to call a remote SP
All, We are planning to migrate our On-Prem SQLServer databases to Azure SQL PaaS DBs with the databases being placed an in Azure Elastic Pool. In the On-Prem database code, in several Stored Procedures, we call a SP in other databases , ie, Exec…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,842 questions
asked
2020-11-10T02:54:01.047+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, 51%, 23%)' 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)
grajee
331
Reputation points
0 answers
How to create service principal, link to the azure sql database in the azure portal.
I want to know how to create service principal to connect to azure SQL server database. (I tried by creating user assigned identity. But this also not succeeded.) The user assigned manage identity is configured by, *create user assigned manage identity…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,842 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
12,111 questions
asked
2024-05-12T04:20:51.1966667+00:00
Athula Chandrawansha
20
Reputation points