Azure SQL Database
An Azure relational database service.
5,413 questions
0 answers
How to access database by External Datasource using Service Principal Name(SPN)
I am seeking a solution for cross-database access via an external data source using Service Principal credentials. Specifically, I want to perform Transact-SQL queries from one database to another using Service Principal credentials. To achieve this, I…
Azure SQL Database
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,076 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,324 questions
Microsoft Entra External ID
Microsoft Entra External ID
A modern identity solution for securing access to customer, citizen and partner-facing apps and services. It is the converged platform of Azure AD External Identities B2B and B2C. Replaces Azure Active Directory External Identities.
2,760 questions
Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
20,538 questions
asked 2024-07-21T14:42:53.0533333+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, 65%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDP%3C/text%3E%3C/svg%3E)
Devendra Parmar
0
Reputation points
asked 2024-07-21T14:42:53.0533333+00:00
Devendra Parmar
0
Reputation points
1 answer
Test Connection is getting failed in data factory for Mongo DB
Test Connection is failing in datafactory for Mongo DB. Note, Ips are whitelisted but i am getting the below error. Failed to operate data via MongoDB client. An exception occurred while opening a connection to the server. Exception has been thrown by…
asked 2024-03-01T09:45:38.9033333+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(25.6, 47%, 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)
ADMMMLIFEADFADMIN
0
Reputation points
commented 2024-07-21T10:16:44.8366667+00:00
Vinodh247
13,301
Reputation points
1 answer
When we can get support of Database Watcher for UK South and UK West
Please confirm when we can get the Database Watcher support for UK South and UK West.
![](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, 32%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAB%3C/text%3E%3C/svg%3E)
2 answers
Recover Resource Group and SQL Server and SQL DB within
I deleted an old Resourge Group with SQL DB within, can i recover within Azure Portal? We have no Backups.
asked 2024-04-22T14:16:11.3833333+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(281.6, 97%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
Helpdesk Milestone
0
Reputation points
commented 2024-07-21T10:15:11.4366667+00:00
Vinodh247
13,301
Reputation points
3 answers
Unable to connect to my SQL Server/Database. Listed resources on Microsoft do not address this issue.
Error codeSqlFailedToConnect DetailsCannot connect to SQL Database. Please contact SQL server team for further support. Server: 'blazor-wasm-app.database.windows.net', Database: 'BrandedFoodMacrosContent', User: [...BLANK...] Check the linked service…
asked 2024-05-04T23:34:12.1833333+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(144, 44%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
Albert Kirpach
0
Reputation points
commented 2024-07-21T10:14:26.0166667+00:00
Vinodh247
13,301
Reputation points
2 answers
SQL Server deployment DEV to UAT to Prod
Hi, I would like to know about different deployment options for azure SQL server from dev to higher environments. We are doing ETL in ADF and loading data into Azure SQL server. How do we move the tables/views/sps etc to other environments? Is there an…
asked 2024-07-04T12:42:05.57+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(19.2, 54%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESD%3C/text%3E%3C/svg%3E)
Santhi Dhanuskodi
205
Reputation points
commented 2024-07-21T10:13:00+00:00
Vinodh247
13,301
Reputation points
1 answer
Restore a SQL Server backup to Azure SQL Managed Instance
What is the best way to restore an SQL Server backup file (.bak) from a storage container to Azure SQL Managed Instance, and overwrite the existing database with the backup? I am looking for the appropriate PowerShell Az command to accomplish this task.…
![](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(156.8, 74%, 25%)' 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)
2 answers
Bacpac file won't restore due to columnstore indexes on columns with specific data types.
Situation: We are using Serverless Azure SQL Databases as projects. Afterwards we delete these databases but before we do that we create backups of the databases. We are using SqlPackage.exe (version: 162.3.566) to create bacpac files. Restoring bacpac…
asked 2024-07-19T09:58:51.94+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(259.20000000000005, 99%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMV%3C/text%3E%3C/svg%3E)
Mark van Eck
56
Reputation points
commented 2024-07-20T21:38:15.0566667+00:00
Erland Sommarskog
106.5K
Reputation points
1 answer
Intemittent Login failed for user '<token-identified principal>'.","details":"SqlException: Login failed for user '<token-identified principal>
Hello. We've an API running on Azure App Service that uses user assigned managed identity to authenticate against an Azure SQL DB. The app works most of the time, no problem with authentication, however, we get an intermittent authentication issue like…
asked 2024-07-19T07:35:14.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(128, 6%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMA%3C/text%3E%3C/svg%3E)
mustafa altunok
0
Reputation points
commented 2024-07-20T19:01:36.05+00:00
mustafa altunok
0
Reputation points
1 answer
ADF Copy Activity - Emply col issue
Hi Team, I have a pipeline where I am copying the data from the file to a database. The file had one extra empty column in between, and my copy activity failed with the below error: Message: Invalid Excel header with empty value It failed because the…
![](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, 24%, 19%)' 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 answer
Disaster Recovery setup/High Availbility
Hello again. I need to some help deciding on how to setup a DR solution. We have following things setup in DEV and UAT env: One subscription where DEV and UAT env reside using separate Vnet and subnets. Use Vnet Peering to connect both VPN gateway…
asked 2024-07-20T05:33:12.57+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, 88%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EXM%3C/text%3E%3C/svg%3E)
Xhevahir Mehalla
140
Reputation points
answered 2024-07-20T12:13:07.28+00:00
Amira Bedhiafi
19,706
Reputation points
2 answers
Getting Failed to determine members of SqlServerTarget (server name 'data-engineering-server-rnd.database.windows.net', server location 'data-engineering-server-rnd.database.windows.net'): Login failed for user 'sqladmin'. error with elastic job
I am trying to run a job inside my server. Steps I followed Created a SQL Server Agent on server 1. Ran following queries and also the Elastic job agent is hosted in server1 only and the database is ElasticJobs. CREATE MASTER KEY CREATE DATABASE…
asked 2024-07-10T11:16:45.74+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, 61%, 36%)' 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 Shrivastava
0
Reputation points
commented 2024-07-20T09:52:29.75+00:00
Vinodh247
13,301
Reputation points
2 answers
Column truncate issue - Copy file to DB ADF pipeline
Hi All, I have a pipeline where I am copying data from a file to a database. In the file, I have a few columns with extra spaces that I need to trim or truncate. I am not getting any option to use any transformation or function (dynamic content) on the…
2 answers
How to log from Azure SQL Database
Is there a way to log messages in Azure SQL database directly ? similar to what we do with any springboot application ? log.error or log.info("your message");
asked 2024-07-19T12:06:05.94+00:00
Ayush Shrivastava
0
Reputation points
answered 2024-07-20T00:18:15.21+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, 60%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDM%3C/text%3E%3C/svg%3E)
Deaaalden Mohmed
0
Reputation points
1 answer
Cannot create and start Extended Events session in Azure SQL Managed Instance
Hello, I am trying to create an Extended Events session in Azure SQL Managed Instance. First I am trying to use SSMS GUI: Extended Events -> Sessions -> New Session... Add "error_reported" event, configure fields, select Data Storage as…
asked 2024-06-24T15:08:42.51+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(297.6, 60%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAV%3C/text%3E%3C/svg%3E)
Aleksey Vitsko
20
Reputation points
commented 2024-07-19T21:34:10.5+00:00
Aleksey Vitsko
20
Reputation points
2 answers
Azure for Students Subscription - Unable to create Azure Database for MySQL Flexible Server
I have been attempting to create a Azure Database for MySQL Flexible Server for my assignment but I am unable to do so due to the below error. I have tried multiple regions but I am unable to get a successful deployment. "code":…
asked 2024-07-01T17:50:31.62+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(256, 6%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMZ%3C/text%3E%3C/svg%3E)
Miguel Zepeda
0
Reputation points
commented 2024-07-19T20:42:13.3866667+00:00
Oury Ba-MSFT
17,791
Reputation points Microsoft Employee
2 answers
Charging in the Azure portal
Hey! I'm trying this exercise but get charged for creating an Azure SQL database resource. Is there a way to explore azure without getting…
asked 2024-06-25T19:05:53.48+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(131.20000000000002, 83%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFL%3C/text%3E%3C/svg%3E)
Fanny Lööf
0
Reputation points
edited the question 2024-07-19T20:14:23.6833333+00:00
Oury Ba-MSFT
17,791
Reputation points Microsoft Employee
1 answer
Find the Sql Server Version and the EOL of the version
We received an email from our cloud team that the support for the Azure Sql Server v12 will be stopped by 9th July 2024. Could you please confirm if that is true. If yes , what is the next available version and what should be our next steps to…
asked 2024-07-19T20:07:47.26+00:00
GeethaThatipatri-MSFT
29,017
Reputation points Microsoft Employee
answered 2024-07-19T20:09:25.8566667+00:00
GeethaThatipatri-MSFT
29,017
Reputation points Microsoft Employee
1 answer
Import the SQL Database from Server to Serverless database
Issue with importing a SQL database from an old Azure VM to a new SQL Server. How can I import a .bak file into an Azure SQL Database using SQL Server Management Studio (SSMS). PS - Based on common issues that we have seen from customers and other…
asked 2024-07-19T19:35:56.18+00:00
GeethaThatipatri-MSFT
29,017
Reputation points Microsoft Employee
answered 2024-07-19T19:37:37.2966667+00:00
GeethaThatipatri-MSFT
29,017
Reputation points Microsoft Employee
2 answers
Using Azure OpenAI / Copilot Application Outside of Portal to Answer Natural Language Questions with SQL Queries
I have been experimenting with Copilot on my Azure SQL databases, and I love the functionality of querying a database through plaintext and getting the results. I'm interested in making this available to non-technical users outside of the Azure portal.…
asked 2024-07-19T19:10:49.97+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(32, 55.00000000000001%, 13%)' 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)
hampton123
1,160
Reputation points
answered 2024-07-19T19:18:29.6966667+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(83.2, 67%, 18%)' 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)
hbjytdrsedfc
0
Reputation points