Questions tagged [azure-sql-database]
Azure SQL Database is a relational PaaS database hosted in Microsoft Azure. Azure SQL Database provides predictable performance, scalability, business continuity, data protection, and near-zero administration for cloud developers.
azure-sql-database
9,977
questions
0
votes
0
answers
21
views
Azure Function App Cannot Access the Azure SQL Database
There is an Azure Function App that has the 'system assigned identity' enabled and a 'user assigned identity' (uai) linked. The 'uai' is also created under the Azure SQL database it needs to interact ...
0
votes
1
answer
27
views
Synapse Notebook to Azure SQL Database connection issue
created Linked service to Azure SQL database in Synapse Analytics that uses Authentication type "
System Assigned Managed Identity". Than referencing it in PySpark Notebook. Method ...
0
votes
0
answers
40
views
Azure SQL Database instance is public [closed]
We just created an instance of "SQL Server" in Azure (not Azure SQL) and did a portscan to discover that the server was not private but public - anyone in the world could access port 1433.
...
0
votes
1
answer
40
views
Azure SQL analysts can create views from forbidden cross database data
TLDR Problem
User can view forbidden data by creating a view to the forbidden data in his own personal schema where he has CONTROL permissions.
Introduction
I have a Azure SQL (Managed Instance) ...
0
votes
0
answers
34
views
Power BI Report Builder - Older Version Required
The latest Power BI Report Builder (version 15.7.1811.11) does not allow me to connect to my Azure SQL Database with "Active Directory Password".... Getting the below error.
Could not load ...
0
votes
1
answer
29
views
Langchain cannot connect with Azure SQL Database
Trying to connect with my Azure SQL Database, it contains multiple tables.
Here's a sample of my code
from sqlalchemy import create_engine
driver = '{ODBC Driver 17 for SQL Server}'
odbc_str = 'mssql+...
-1
votes
0
answers
18
views
How to access Azure SQL database from local machine when public access is disabled in Azure? [closed]
I've created the virtual network and subnet.
Disabled the public access for the Azure SQL Server and created private endpoint with virtual network and subnet.
I'm unable to connect the SQL Server from ...
0
votes
2
answers
76
views
Trying to connect to SQL DB - provider: TCP Provider, error: 26 - Error Locating Server/Instance Specified
I have a C# .NET 8 isolated Azure Function App that I am trying to connect to a SQL database, but I am having trouble trying to locate the problem.
The SqlException:
A network-related or instance-...
0
votes
1
answer
76
views
How to connect, using terraform, the Azure Analysis Services Server (AASS) with an Azure SQL Database and Azure Data Factory (ADF)
Im planning to connect, using terraform, the azure analysis services server with an Azure SQL Database and Azure Data factory.
So far, the docs were not that useful, and I was wondering if you can ...
-1
votes
1
answer
38
views
Copy Database - Performance
We need to create a new copy of a database on a different server using the PowerShell command "New-AzSqlDatabaseCopy".
Will running this command impact the performance of the live database, ...
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 ...
0
votes
2
answers
83
views
Failure When Trying To Connect ADF Linked Service to SQL Server
We have an ADF subscription that we are trying to create a linked service to an azure cloud based SQL Server on. We have an existing subscription that already has this linked service created and need ...
0
votes
1
answer
49
views
SQL Auditing using Log Analytics Workspace [closed]
I need assistance in completing the setup of Log Analytics for my databases.
I have configured monitoring for three databases with the following categories:
All logs
Audits
Diagnostic Settings
Two ...
0
votes
1
answer
115
views
Optimizing SQL query - joining views of views is extremely slow [closed]
Following question pertains to Microsoft SQL Azure (RTM) - 12.0.2000.8. The XML I got from Azure Data Studio does not work on Paste The Plan website, so I am sharing the raw XML instead.
I have a ...
0
votes
0
answers
60
views
Azure SQL returning different output for query with variable and query with hardcoded values
SQL Server is returning different results for the following two queries that I expect to return the same output:
Query 1:
DECLARE @year INT = 2024
DECLARE @month INT = 7
SELECT *
FROM udf_a(@year, @...