All Questions
Tagged with azure sql-server
3,501
questions
0
votes
0
answers
23
views
Azure Pipeline timeout with testcontainers
I have a similar issue as this: Testcontainers: Azure pipeline test stage reach timeout of 1hour
I would have commented there but I can't comment because I don't have 50 reputation.
It's the same case,...
0
votes
0
answers
38
views
Unable to Connect to Azure SQL Server Database Using JDBC Driver in Android App
I'm developing an Android app and trying to connect to an Azure SQL Server database using the JDBC driver. I'm encountering a java.lang.AssertionError related to SSL/TLS communication. Below is the ...
0
votes
0
answers
35
views
Azure hyperscale db delays even when the cpu % is low [closed]
We are using Azure hyperscale DB Gen5 DB to store lots of data.
We have a stored procedure that runs an ETL and transfers data from one table to another.
We're noticing that when having 2/4 vCores, ...
0
votes
1
answer
30
views
Unable to Connect to Azure SQL Managed Instance from Shared Hosting, but Works from Azure App Service
I'm experiencing an issue with my web API connecting to an Azure SQL Managed Instance. Here's the situation:
Shared Hosting Server: My API runs on a shared hosting server. When I use the connection ...
0
votes
1
answer
57
views
Getting error, WebSocket connection to 'wss://website.azurewebsites.net:8080/ws' failed: When making POST Request from React to Azure SQL server
I am having a problem with my azure web app (linux) while trying to add data into my sql database
Here are the errors im getting:
DataAdd.js:26
POST https://website.azurewebsites.net:5000/add-data ...
0
votes
1
answer
46
views
Connect SSMS to Azure SQL Database [duplicate]
I am trying to connect my Azure SQL database to Microsoft SQL Server Management Studio. Getting the error: Connection host has failed to respond
Cannot connect to {my server}.database.windows.net.
A ...
1
vote
1
answer
79
views
SQL Data Migration Assistant fails to produce deployment script due to Triggers
I'm trying to use the Microsoft Data Migration Assistant to migrate my SQL Server DB to SQL Azure.
I have a Delete trigger which references the DELETED pseudo table. When the assistant tries to ...
1
vote
0
answers
45
views
Can SQL Server with Entra Authentication accept pre-Windows 2000 identifiers?
I have a SQL Server on Azure Virtual Machine joined to a Microsoft Entra Domain Services instance that has Enable Microsoft Entra authentication for SQL Server on Azure VMs enabled.
I have a user in ...
0
votes
0
answers
60
views
Connect to Azure SQL Server using windows credentials [duplicate]
I'm trying to connect to Azure SQL using on-prem AD account, which is synched to Azure AD.
I am able to connect using the SSMS when I run as a different user but programmatically it doesn't work.
It's ...
0
votes
1
answer
64
views
Azure Synapse Dataflow - Unable to use a parameter in Pre SQL scripts
In my Sink I'm running a Pre SQL Script to delete data after a certain date but I'm having trouble using parameters in the script.
Here is my date parameter variable inside dataflow and below is my ...
1
vote
2
answers
76
views
Use SQL query to extract data from an external SQL Server database in Azure databricks
I am connecting to an on prem SQL Server database using the code below and it works as expected. I have wrapped the query I want to use in a view and I called the view to read the data into the ...
0
votes
0
answers
28
views
Using a table name as a variable with IF EXISTS [duplicate]
I need to make up a dynamic list of fields to link on for a Merge statement, but the table names must come from a variable.
I want to do the following with the table name as a variable and have tried ...
0
votes
0
answers
98
views
Azure Data Studio Build error SQL70001: This statement is not recognized in this context
Im using the Azure Data Studio to build an .sqlproj which later on I use it it in order to build and deploy a .dacpac file via Azure Pipelines to a Azure Database (SQL Server).
I'm creating user, ...
-1
votes
1
answer
51
views
Easiest way to restore production data onto staging with filters and anonymisation [closed]
I need to restore production data over to our staging environment to get data similarities back in place to facilitate testing.
I have a few requirements though:
I don't need the entire data set from ...