Stack Overflow
Stack Overflow

Questions tagged [azure-sql-server]

548 questions
0
votes
2 answers

Avoid "The SqlParameter is already contained by another SqlParameterCollection" exception when use retryPolicy with SqlAzureExecutionStrategy

I've read various questions/suggestions about this exception. However what I am supposed to do in order to avoid it when I use retry policy? Connection might not end up closed and so parameters could not be reused? public class ReliableSqlCommand { …
Alexa Adrian
  • 1,778
  • 2
  • 23
  • 38
0
votes
1 answer

Can you add Defender to an Azure Sql Database with the CLI, ARM or Powershell?

I found this connect request to add it, but it doesn't say anything about Powershell. I'm guessing it's not available yet, but can anyone confirm…
randy
  • 253
  • 4
  • 17
0
votes
1 answer

Azure Purview sees On-Prem SQL Server db and tables, but fails to scan with message: invalid client secret is provided

I have successfully set up a scan for an on-prem dev sql instance. However, i am trying to set up scans on multiple on-prem sql instances. I have successfully installed the integration run time agent on a server I want to scan. When I double check…
MJGJr
  • 1
  • 4
0
votes
1 answer

Azure SQL - GEO-REPLICATION : Data loss?

I have an Azure SQL in WEST US with GEO-REPLICATION enabled to sync with EAST US. and I want to know How often Geo-Recovery sync gets executed to keep the EAST US up to date? In case of WEST US regional failure and happen to failover to EAST US,…
One Developer
  • 99
  • 5
  • 43
  • 103
0
votes
1 answer

How to add the Azure Active Directory Administrator on a SQL Server to an Azure group once the SQL server deploys

I am trying to create an automated process that adds the Azure Active Directory on a SQL Server to an Azure group once the SQL server deploys. The group I want to add too is a security group. I am thinking about using Azure policy to implement this.…
Dimeji Olayinka
  • 71
  • 3
  • 12
0
votes
2 answers

What is the equivalent configuration for Azure SQL database for an on-premise server of 2 TB RAM?

I am new to Azure and we are working on migrating from on-premise to Azure SQL Database. In the on-premise we have server with 48 cores and 2 TB RAM. What would be the corresponding configuration on Azure? or How to determine the correct…
Ashan
  • 13
  • 5
0
votes
1 answer

Azure Datafactory: Dataflow can't access database

I've been building a nice ETL solution with Data Factory. We're bound to go to the production stage and now security becomes a real concern. Somehow I can't seem to get this right.... I've set up a CosmosDB and SQL Server/DB in Azure. I've added…
Croga
  • 98
  • 8
0
votes
1 answer

Azure AD Authentication for Entity Framework 6 in DB first approach

I am trying to configure the connection string to use Azure AD Authentication. I am able to connect to SQL Server using standard SQL Connection with Azure AD Authentication. My application uses Entity Framework 6 DataBase first approach. I have…
user1696555
  • 83
  • 2
  • 12
0
votes
1 answer

NoRegisteredProviderFound while deploying the azure sql server

The deployment 'template-mssql-serverless-main' failed with error(s). Showing 1 out of 1 error(s). Status Message: No registered resource | provider found for location 'southcentralus' and API version '2017-12-01' for type 'servers'. The supported…
Basavaraj Biradar
  • 23
  • 1
  • 8
0
votes
0 answers

Unable to connect to Azure SQL Server using ODBC ( The function is unfamiliar with the certificate authority that generated the server's certificate)

I am trying to connect to Azure SQL Server using ODBC. I am getting an error when connecting as " The function is unfamiliar with the certificate authority that generated the server's certificate", the username and password are not getting…
kishore.jannarapu
  • 41
  • 1
  • 4
0
votes
1 answer

Azure SQL Server firewall configuration using PowerShell not working

When executing New-AzSqlServerFirewallRule -ResourceGroupName $ResourceGroupName -ServerName $SqlServerName -AllowAllAzureIPs I get this error: New-AzSqlServerFirewallRule : Could not load type 'Microsoft.Azure.CertificateCloudCredentials' from…
Felix Bodmer
  • 291
  • 2
  • 16
0
votes
1 answer

tedious: Azure AD with accessToken Connection lost - read ECONNRESET

I am working on an App that is authenticating user using Azure AD, extracting his accessToken and then using this token to connect to the Azure SQL server using below setting. But unfortunately, I am getting ESOCKET "Connection lost - read…
rohit12sh
  • 827
  • 2
  • 11
  • 24
0
votes
1 answer

Insert New Primary Key to Table with data already inside

I have table with million of records and is requirement to add new int field 'Id' as primary key with auto incremental. Now I have manage to do to tables with reasonable small amount of data but some of table holds million of records and throw time…
K.Z
  • 5,201
  • 25
  • 104
  • 240
0
votes
0 answers

User login failed for in production but same connection string works from local client

I have an Azure database setup of which I have included the below connection string as I believe it should be. Problem is when I try to run my client app in production, the server returns a 500 internal error. After investigating it through remote…
Highspeed
  • 442
  • 3
  • 18
0
votes
2 answers

Azure SQL managed instances

If we opt Azure SQL managed instances in DEV,QA and PROD environment . Will Microsoft take care the DB maintenance in terms of index rebuild or reorganize periodically etc. ?
Codehunter
  • 69
  • 5
1 2 3
…
36 37