5,428 questions with Azure SQL Database tags

Sort by: Updated
5 answers One of the answers was accepted by the question author.

Moving an Azure Sql Server to another subscription in another tenant

We are planning to move a sql server containing a elastic pool with 8 databases to another subsciption in another tenant. So far we have come up with these steps: Create a new subscription (TMP) in the source tenant Move the server to this new…

Azure SQL Database
asked 2021-08-13T07:01:35.177+00:00
Peter Bons 151 Reputation points
edited an answer 2024-07-24T23:02:10.4366667+00:00
GeethaThatipatri-MSFT 29,017 Reputation points Microsoft Employee
0 answers

Database 'DATABASENAME' on server 'server-name' is not currently available.

Hello, I am unable to connect to Azure SQL. This has been going on for the last 48 hours. Error: TITLE: Microsoft SQL Server Management Studio Database '<DBName'> on server '<server-name>' is not currently available. Please retry the…

Azure SQL Database
asked 2024-07-24T15:04:58.4533333+00:00
Artsem Shumski 0 Reputation points
edited a comment 2024-07-24T21:54:01.89+00:00
Oury Ba-MSFT 18,021 Reputation points Microsoft Employee
1 answer

Lift and Shift SQL server database backups on Azure

HI, Can we schedule daily database backups on Azure portal for lift and shift SQL server which is in AZURE. Thank you

Azure Backup
Azure Backup
An Azure backup service that provides built-in management at scale.
1,191 questions
Azure SQL Database
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,346 questions
asked 2024-07-24T17:23:09.0933333+00:00
Newtojob 26 Reputation points
answered 2024-07-24T21:23:34.57+00:00
Erland Sommarskog 107K Reputation points
0 answers

Microsoft Applied Skill 4 - Failure to create Databases 1-4

While attempting the "Migrate SQL Server Workloads to Azure SQL Database" it failed to create Databases: DB1, DB2, DB3, and DB4. While DB5 was a partial. Has anyone else had this happen to them? What steps have you taken to resolve this…

Azure SQL Database
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,346 questions
SQL Server Training
SQL Server Training
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Training: Instruction to develop new skills.
11 questions
asked 2024-07-14T02:43:10.5333333+00:00
Jacob Shuster 0 Reputation points
commented 2024-07-24T20:45:16.85+00:00
Jacob Shuster 0 Reputation points
0 answers

My Azure SQL Managed Instance's Zone Redundancy was disabled without notice in West US 3

My Azure SQL Managed Instance (SQLMI) in the region 'West US 3' was previously configured with Zone Redundancy, but it appears to be disabled now. I can't find a way to enable it again, even though the support matrix still indicates that SQLMI Zone…

Azure SQL Database
asked 2024-07-24T18:32:18.9366667+00:00
Ben Liu 0 Reputation points
2 answers

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…

Azure SQL Database
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,180 questions
asked 2024-07-20T02:14:27.9266667+00:00
ADF_Coder 0 Reputation points
commented 2024-07-24T18:04:01.56+00:00
Chandra Boorla 400 Reputation points Microsoft Vendor
1 answer

ADF Copy Activity - To Remove records where all cols are Blank

Hi All, I have a copy activity that copies the data from an Excel file to a database table. It seems we are getting some blank rows in the source file for all the columns. In the database table, it is reflected as NULL. We need to restrict these rows…

Azure SQL Database
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,180 questions
asked 2024-07-24T15:58:41.5366667+00:00
ADF_Coder 0 Reputation points
answered 2024-07-24T17:40:38.1833333+00:00
Amira Bedhiafi 19,946 Reputation points
1 answer

Configuring Microsoft Entra Access for Specific User Groups to Azure SQL Database

Hello, I require assistance with configuring Microsoft Entra access for specific user groups to my Azure SQL Database setup. My current environment consists of the following: A primary Azure SQL server with a primary SQL database replica. A secondary…

Azure SQL Database
Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
20,598 questions
asked 2024-07-23T16:27:18.4566667+00:00
Zakhar Makarevich 0 Reputation points
commented 2024-07-24T16:24:32.7166667+00:00
Zakhar Makarevich 0 Reputation points
3 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…

Azure SQL Database
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,180 questions
asked 2024-07-19T17:52:29.9766667+00:00
ADF_Coder 0 Reputation points
commented 2024-07-24T16:08:06.92+00:00
ADF_Coder 0 Reputation points
1 answer

How to handle an excel sheet(only 1 tab) with multiple datasets with different columns and ranges

Hi Team, Could you help me out with below Scenario of ADF? I have a single Excel file with just one tab, as displayed below with different columns and that tab contains 2 datasets. We want to move this data to 2 different SQL tables using ADF/data flow.

Azure SQL Database
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,687 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,180 questions
asked 2024-07-24T12:35:32.0766667+00:00
Spandana Mogadala 0 Reputation points
commented 2024-07-24T13:55:41.3333333+00:00
Nandan Hegde 31,511 Reputation points MVP
1 answer

managed instance link between 2 managed instances

Hello, We have databases running on Azure SQL Managed Instance. We would like to move this database instance to another resource group without any interruption. We are considering using the managed instance link for this purpose. My question is: Does the…

Azure SQL Database
asked 2024-07-22T12:17:17.8533333+00:00
Fatih Korhan 0 Reputation points
commented 2024-07-24T12:38:21.8833333+00:00
Fatih Korhan 0 Reputation points
3 answers One of the answers was accepted by the question author.

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
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,346 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,770 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,598 questions
asked 2024-07-21T14:42:53.0533333+00:00
Devendra Parmar 20 Reputation points
commented 2024-07-24T10:39:48.5633333+00:00
Devendra Parmar 20 Reputation points
1 answer

Customer Best Practices Assessment: exclude checks/false positives

Is there any way to customize the BPA in Azure ARC for SQL to exclude certain checks or to flag issues as false positives? I've got certain issues being flagged by the BPA however these can't be resolved as the application accessing the database requires…

Azure SQL Database
Azure Arc
Azure Arc
A Microsoft cloud service that enables deployment of Azure services across hybrid and multicloud environments.
384 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,346 questions
asked 2024-07-19T09:42:13.16+00:00
Berend Broekhoff 0 Reputation points Microsoft Employee
commented 2024-07-24T09:35:35.1333333+00:00
Berend Broekhoff 0 Reputation points Microsoft Employee
3 answers

||Execution fail against sql server. Please contact SQL Server team if you need further support. Sql error number: 121. Error Message: A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The sem

Hi, We have azure data factory pipeline and got error message below couple of times over week-end. ADF pipeline calls azure sql database stored procedure which failed with the message - stored procedure just removes rows from table. Intermittent and…

Azure SQL Database
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,180 questions
asked 2024-07-22T14:30:09.2033333+00:00
Philip O'Rourke 111 Reputation points
commented 2024-07-24T08:08:55.44+00:00
Erland Sommarskog 107K Reputation points
1 answer One of the answers was accepted by the question author.

How to create user in remote database using elastic query ?

I am trying to use elastic query to connect to remote database and create user there. I have used total three ways to create Database scope credentials: Using SQL users: CREATE DATABASE SCOPED CREDENTIAL ElasticDBQueryCred WITH…

Azure SQL Database
asked 2024-07-23T19:08:45.07+00:00
Palash Mathur 20 Reputation points
accepted 2024-07-24T05:16:02.8+00:00
Palash Mathur 20 Reputation points
3 answers

Azure Data Studio - Azure SQL Migration extension thinks the Managed Instance is still in 'Creating' state.

In step 3 of the Azure SQL Migration where the user chooses the managed instance: Error: The managed instance 'managedinstance' is unavailable for migration because it is currently in the 'Creating' state. To continue, select an available managed…

Azure Database Migration service
Azure SQL Database
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
517 questions
Azure Data Studio
Azure Data Studio
A cross-platform database tool for data professionals using on-premises and cloud data platforms on Windows, macOS, and Linux.
106 questions
asked 2023-02-28T11:28:45.1133333+00:00
Vlasopoulos V 10 Reputation points
answered 2024-07-23T21:33:54.5266667+00:00
Ronald Duenez Ortiz 0 Reputation points
1 answer One of the answers was accepted by the question author.

How to figure out the total number of doses within a time span given to a client as dose are being added and stopped.?

If the cadence values are different, even if the dates overlap the records must be separate. If an order for the same dose and cadence value (including nulls) starts on the same day or the next day (+or-1 day) the record should continue. outlook of…

Azure SQL Database
SQL Server Transact-SQL
SQL Server Transact-SQL
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Transact-SQL: A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
67 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,599 questions
SQL Server Training
SQL Server Training
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Training: Instruction to develop new skills.
11 questions
asked 2024-07-22T22:24:04.8633333+00:00
andrew omofonma 61 Reputation points
accepted 2024-07-23T17:36:56.54+00:00
andrew omofonma 61 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…

Azure SQL Database
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,346 questions
asked 2024-06-24T15:08:42.51+00:00
Aleksey Vitsko 25 Reputation points
commented 2024-07-23T16:18:19.89+00:00
Joby Mathew 5 Reputation points
1 answer One of the answers was accepted by the question author.

Connect to an Azure SQL server from Microsoft Fabric

I am trying to connect to an Azure SQL server using Dataflows on Fabric, however whenever I try connect i get the error "Reason: An instance-specific error occurred while establishing a connection to SQL Server. Connection was denied since Deny…

Azure SQL Database
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,180 questions
Microsoft Fabric Training
Microsoft Fabric Training
Microsoft Fabric: A Microsoft unified data platform.Training: Instruction to develop new skills.
28 questions
asked 2024-07-23T11:07:09.05+00:00
Mcmahon, Amy [GPSIE NON-J&J] 20 Reputation points
accepted 2024-07-23T12:28:34.2566667+00:00
Mcmahon, Amy [GPSIE NON-J&J] 20 Reputation points
1 answer

Failed to connect to Azure SQL server from android due to TLS version mismatch using jtds connection

Also tried added ssl=require in connection string it returned error as "Network error IOException: SSL handshake aborted..." if I added sslProtocol=TLSv1.1 since in Azure server it set as 1.0, but it return message as "Reason:Login…

Azure SQL Database
asked 2024-07-23T03:11:54.86+00:00
Daiya 0 Reputation points
answered 2024-07-23T07:52:15.4066667+00:00
ShaktiSingh-MSFT 14,406 Reputation points Microsoft Employee