I recently encountered this error while trying to connect to my Azure SQL database from the Azure Data Studio. An instance-specific error occurred while establishing a connection to SQL server After entering all the details in the below pop-up and then I clicked on the Connect button, but all of a sudden, I got this … Read more >>
This Azure tutorial will discuss multiple approaches to export Azure SQL Database. Export Azure SQL Database To bak File Here, we will discuss two approaches to exporting the Azure SQL database to a bak file. Approach-1 To export Azure SQL Database, follow the below steps. 3. Now you can see the list of Azure SQL databases that … Read more >>
Once I accidentally deleted my Azure SQL database, after my analysis, I identified a few approaches to restore it. In this Azure tutorial, we will discuss all the approaches to restoring the Azure SQL database. How To Restore Azure SQL Database Using Azure Portal If, by chance, you have deleted an Azure SQL database and want to … Read more >>
In this Azure article, we will discuss the solution for this error. Recently, I was trying to connect to Azure SQL database from Power BI, But after clicking on the connect button, I got this error. The complete error message was as below An error happened while reading data from the provider: ‘Could not load … Read more >>
Before discussing the complete steps for this functionality, consider the prerequisites needed here. Assuming you are ready with all these prerequisites. Follow the below steps 3. Now, you can see a SQL Server icon on the left navigation. Click on the SQL server icon –> click on the + Add connection button, as shown in … Read more >>
I got this error while trying to back up the Azure SQL DB. The screenshot below is for your reference. The complete error message is as below Cause When saving a blob file to a Non-Blob Storage or not using the Blob Storage Endpoint. SQL Server backups can only be saved to a Blob Storage. … Read more >>
Recently, I was working on a critical requirement for one of my clients. At the same time, I got this error running an SQL script that takes the backup of the SQL DB to the Blob storage. Reason I got this error because I didn’t include the WITH credential = ‘name of your SQL credential’ … Read more >>
Recently, while generating the Shared Access Signature (SAS) for the storage account, I encountered that the Generate SAS and connection string button was not enabled or greyed out. Solution What exactly I had done to fix this issue. I selected the desired option for the Allowed resource types option. So, I faced this scenario because … Read more >>
Similarly, we can connect Azure Data Studio to Azure SQL using the below steps. Check out how to create an Azure SQL database if you have not yet created your Azure SQL database. 3. On the Connection window, provide the below details. Note: Navigate to the Azure SQL database in the Azure Portal and click on the Copy to Clipboard button next to the … Read more >>
I got this error while running the script to manage users. Solution My mistake was I had not created the user properly in my Azure SQL database server. To fix this error, you must ensure that you have done it properly while creating a user in the Azure SQL database server. It would be best … Read more >>
Download our free 25+ page Azure Virtual Machine guide and master cloud deployment today!