Stack Overflow
Stack Overflow

Questions tagged [azure-sql-server]

548 questions
0
votes
0 answers

Is there any circumstance in which the DbConnection.ConnectionTimeout can be exceeded when executing Open() method?

I was monitoring my web application (hosted on azure with db azuresql) I found that, occasionally, there is a failure to establish the connection to the database, and the Open() method can take up to 40 seconds to fail (with a timeout exception). It…
Ângelo Moreira
  • 186
  • 6
0
votes
1 answer

In Azure SQL Server How do I Query a table in db_1 from db_2 and insert records in table in db_2

I need to identify fields in tbl_1 (2+ x 10^6 rows) in db_1 that do not match what is supposed to be the same field in tbl_2 in db_2 and insert an error log record in a tbl_3 in db_1 when a mismatch is found. Azure SQL Server does not allow me to…
merb
  • 3
  • 2
0
votes
2 answers

Azure Sql database export to Azure blob storage failed

I tried to export an azure Sql database to an azure blob storage via the Azuer portal and got an error: Error encountered during the service operation. ; Exception Microsoft.SqlServer.Management.Dac.Services.ServiceException:Unexpected exception…
MartinAy
  • 53
  • 8
0
votes
1 answer

How to save a stored procedure into Azure SQL Server

I am writing a test stored procedure on visual studio code (I cannot install SQL Server Management Studio or Visual Studio as I don't think its available on Linux Ubuntu). I need to save this stored procedure on my Azure SQL Server because I am…
Shuti
  • 169
  • 1
  • 4
  • 18
0
votes
1 answer

Calling Azure SQL Database REST API gives the error: The authentication scheme of Basic is not supported

In the following code of my WPF Core client app , I am trying to use this Azure SQL Database REST API to delete a database in my Azure subscription. But I am getting the error shown below: Question: What I may be missing, and how can we resolve the…
nam
  • 21,967
  • 37
  • 158
  • 332
0
votes
1 answer

Unable to connect to Azure SQL through Virtual Network Gateway

I have SQL Azure Database Server (not managed instance). When setup last year, I added Azure Virtual Network Gateway, and I could access the database via the VPN connection, without whitelisting the IP. We didn't use this connection via gateway…
Randeep Singh
  • 998
  • 2
  • 11
  • 31
0
votes
1 answer

MS SQL trigger not inserting records for bulk insert

One of the external application is inserting more than 40K records in the SQL Azure table. I have a trigger to process all of the required rows which matches the column value for the unique column value for the distinct record Whenever the 40K+…
Dinesh Tripathi
  • 196
  • 3
  • 17
0
votes
1 answer

How to configure connection string for ASP.NET Core and azure, netcoreapp3.1, with VS2019?

I followed the basic example tutorial from Microsoft on how to publish an ASP.NET Core app to Azure with visual studio (https://learn.microsoft.com/pt-br/aspnet/core/tutorials/publish-to-azure-webapp-using-vs?view=aspnetcore-3.1) There is this part…
rdprado
  • 173
  • 2
  • 7
0
votes
2 answers

How to import a local SQL database back-up file to an Azure SQL server database?

I have a project that is running on a local SQLExpress server. I have exported my database to a .bacpac file. I am trying to restore that DB to an Azure SQL server. So what I am trying to do is to create a DB on Azure using this back-up file. How…
Hussam Ahmed
  • 413
  • 1
  • 5
  • 17
0
votes
1 answer

Connection String for JDBC when adding failover groups on azure sql server

I have a primary sql server1 (server1.database.windows.net) in region A with a single db("demo"). Then,I set up auto failover group for server 1 by creating a secondary server 2 (server2.database.windows.net) in region B for the same db. When I…
user2594
  • 386
  • 1
  • 5
  • 18
0
votes
1 answer

sequelize azure sql database rollback

I am using sequelize with microsoft azure sql database. I am using following to connect to the database let sequelize = new Sequelize(, , , { dialect: 'mssql', host: 'xxxxxx.database.windows.net', …
Anshul Jain
  • 103
  • 6
0
votes
1 answer

Azure SQL managed Instance - why should I use Azure Data migration service?

Why should I use Azure Data migration service? Why can't I directly restore the database backup using Azure managed instance?
One Developer
  • 99
  • 5
  • 43
  • 103
0
votes
0 answers

Is there any way to configure the “ADVANCED DATA SECURITY” option in Azure SQL through Terraform?

I would like to add the “ADVANCED DATA SECURITY” option in Azure SQL through Terraform. Is it possible to do that?
Anand
  • 95
  • 3
  • 5
0
votes
1 answer

Azure SQL Database traffic migration to newer Gateways when using Webapp-->Azure SQL

I have received an email from Microsoft regarding "Azure SQL Database traffic migration to newer Gateways". These changes are highlighted on this page. In that page it says that you will not be impacted if you have: Redirection as the connection…
Stackedup
  • 680
  • 2
  • 9
  • 26
0
votes
2 answers

Unable to connect SQL Azure through Access Token generated through bearer token

I was trying to connect my SQL Azure Queries through Bearer token which is generated through this query $token= & az account get-access-token --resource=https://database.windows.net/ --query accessToken Since today it says "Login failed for user…
user1037747
  • 1,307
  • 2
  • 18
  • 38
1 2 3
…
36 37