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…
![](https://techprofile.blob.core.windows.net/images/pW2bggFAAwAAAAAAAAAAAA.png?8D8ACC)
![](https://techprofile.blob.core.windows.net/images/9CqRWkWyk0WIvV6eSiSD-g.png?8DB6B7)
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…
![](https://techprofile.blob.core.windows.net/images/kjzQAO5Oq0Oj37wdNf6qTQ.png?8D8E42)
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
![](https://techprofile.blob.core.windows.net/images/c4mRkDtLdU6n6fSv2i9uBg.png?8D843C)
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…
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…
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…
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…
![](https://techprofile.blob.core.windows.net/images/UVyLn-Xlr0apNce5TRX1RA.png?8DBA3B)
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…
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…
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.
![](https://techprofile.blob.core.windows.net/images/nU6nYqttiUqkasJ2PMYbbQ.png?8DB643)
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…
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…
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…
||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…
![](https://techprofile.blob.core.windows.net/images/c4mRkDtLdU6n6fSv2i9uBg.png?8D843C)
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 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…
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…
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…
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…
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…