Questions tagged [azure-sql-server]
548 questions
1
vote
1 answer
How does SqlClient gets 'scope' of Azure SQL Server when using Azure Active Directory as authentication method?
As I understand that for getting selective authorization for a protected resource using Azure AD based OAuth 2.0 mechanism, client application need to mandatorily provide the scope URL for getting access token.
Other parameters usually include…
A. Trivedi
- 33
- 3
1
vote
2 answers
Can't connect to Azure SQL DB - pyodbc Operational Error
Attempting to connect to an Azure SQL database, most other configurations I've tried result in an instant error:
Client unable to establish connection (0) (SQLDriverConnect)')
But this one I'm currently trying times out and is the closest I've…
dswire
- 21
- 1
1
vote
1 answer
Automatically trigger Azure SQL database to be "online"
I am using an Azure Serverless SQL database that goes to a "paused" state after 2 hours - this is all working as "auto-pause" is enabled (this I don't want to change).
Is it possible to somehow automatically trigger the SQL database to be "online"…
Ian Carrick
- 242
- 3
- 18
1
vote
1 answer
SQL Server/ Azure SQL - For JSON
I am writing a number of SQL Procedures that return JSON to my application using the for Json option on select queries. Some of the queries are lookups into the database - these need to return the row count back to the application so it can handle…
u07ch
- 13,324
- 5
- 42
- 48
1
vote
2 answers
VNet whitelisting for Azure SQL Server across azure tenants
I have an Azure SQL Server residing in tenant A and I need to add a Virtual network rule for a subnet residing in tenant B.
For this, I have created a service principal and given it multi-tenant access. I am also able to see the SP in both tenants.…
Subha_26
- 440
- 4
- 14
1
vote
2 answers
Is there any way to convert an entire snowflake create table script to azure sql script?
I am trying to load data from a couple of snowflake tables [200-300 columns] into azure sql server. Is there a way to convert the datatypes automatically or to convert the entire table creation script ?
Ashwin Mohan
- 108
- 9
1
vote
1 answer
What's permissions should be added to Azure SQL server to get active directory user the ability to automatically set your own firewall IP exception?
I have an Azure SQL server where I have the contributor role under the Resource Group that contains it. I have set my own user as Azure Active Directory admin.
I guess that's what give me the ability to add my own IP as firewall exception…
gsubiran
- 2,012
- 1
- 22
- 33
1
vote
1 answer
Azure SQL failover groups and potential data loss
I am trying to understand the behavior of failover groups for Azure SQL. It feels like I am missing something obvious.
Imagine the following scenario:
I have a database with a configured failover group in RegionA and RegionB. RegionA is primary
I…
adlanelm
- 31
- 2
1
vote
1 answer
PYODBC connection going to sleep mode
I am trying to execute stored procedure from data bricks by using PYODBC connection, after all transactions happened, status is going to sleep mode. Please help me on that,
I tried all the possibilities auto-commit and connection timeout etc. but…
Suneel Kumar
- 127
- 1
- 2
- 8
1
vote
1 answer
Azure SQL Database either too slow or too expensive
We are a small family run business in Miami and currently use a few products in the Azure Cloud. We have a standard Azure SQL database but the performance is poor.
We run a daily report over a transactional table of 50 million rows but this can take…
TheCloudy
- 11
- 2
1
vote
0 answers
Azure SQL to DB2 data migration via SSIS
I want to create an SSIS package with source as azure sql and destination as DB2 table.
I have to check if Id (int) in sql matches with Id (X12 basically varchar) in DB2, if it matches, I have to update name in db2 with the name in SQL
else insert…
Ritu
- 31
- 1
1
vote
1 answer
Concatenates the values of string expressions in azure synapse serverless pool
I would like to write a query in serverless pool for concatenation of string values from multiple rows into single row with comma separated values. I am getting below error when I use COALESE function which I am unable to fix "Queries referencing…
Pakard
- 39
- 1
- 4
1
vote
1 answer
Spring Batch & Azure SQL Server: Could not get JDBC Connection
We are in the process of moving to Azure SQL Server from Oracle DB for our Spring Batch application.
I am getting the following error intermittently
ERROR : 01.03.2022:1458 (40.269) [[]main] CommandLineJobRunner: Job
Terminated in error: Error…
One Developer
- 99
- 5
- 43
- 103
1
vote
1 answer
Wants to move the Azure elastic pool (configured in failover groups) from one subscription to another subscription(different tenant)
We have Azure SQL databases in the Azure Elastic pool which are configured in the failover groups. We are planning to move the elastic pool from one subscription to another subscription(to different tenant).
Is it possible to move the elastic pool…
Shannu
- 13
- 2
1
vote
1 answer
Active Directory Service Principal is giving Invalid value for key 'authentication'
I am trying to execute a SSIS package where source is SQL Server and destination is Azure SQL with authentication "Active Directory Service Principal". ODBC driver is 17.8 and OLEDB driver is 18.5.
While executing the SSIS package, it fails for a…
user3934763
- 23
- 7