10,064
questions
0
votes
0
answers
8
views
Login failed for user '<token-identified principal>' Error 18456 On Deploy Database
From MMSS 2017 I right click the database, then select Tasks->Deploy Database to Microsoft Azure Sql Database
In the Wizard Deployment Settings Screen I click Connect and login to my Azure SQL ...
- 17.8k
-2
votes
0
answers
15
views
Azure SQL owner role and server permissions [closed]
I'm a SQL Server guy, not an Azure expert. The Azure admin is not a SQL Server expert, just infrastructure.
He added my account to the Owner role of an Azure SQL server in the Azure portal, and said ...
- 609
-1
votes
1
answer
83
views
MERGE runs WHEN NOT MATCHED clause unexpectedly
I'm running a MERGE statement in SQL Server where the source table has a single row with a requestMaterialId that matches with a row in the target table. My expectation is that the WHEN MATCHED clause ...
- 4,289
0
votes
1
answer
57
views
SQL Connection Failed after switch the Azure SQL failover group
I use Entity Framework to connect to an Azure SQL database. Recently I needed to switch the failover group, but I found there will be lots of SQL connection issues. After a few hours, I switched the ...
- 1
0
votes
1
answer
49
views
Azure SQL trigger takes 36 times longer when surpassing 6200 rows
I have created a trigger that is supposed to update a table (clients_kv) with a foreign key on updates in the table regions_kv. To avoid updating for all values in regions_kv, I'm doing some extra ...
0
votes
1
answer
33
views
HAS_DBACCESS in SQL Azure not working from master
When I run the following query against master in an on prem or managed instance, I get a 1 or 0 result.
select HAS_DBACCESS(N'MyRep')
However, when run against SQL Azure against master I get NULL.
If ...
- 2,310
0
votes
1
answer
39
views
DBT Snapshots Erroring With "[42S01][ODBC Driver 18][SQL Server]There is already an object named 'table_name__dbt_tmp' in the database."
When running "DBT snapshot" after the initial run I get the error in the title. The object does already exist as it should, because isn't that the point of DBT snapshots. To check the source ...
- 53
0
votes
0
answers
23
views
Possible Reasons For Azure Cache for Redis Occasionally Not Returning All Data When Query
As the title states, sometimes when the front end of our application sends a query to the backend the cache does not return all of the data it normally would by quite a large amount.
If the cache is ...
- 53
1
vote
1
answer
55
views
How create external table in Azure SQL to access a table in local SQL Server on same subnet. Getting error on select
I have a number of Azure SQL databases that I would like to have access an external table in a local SQL Server database (not named instance). The local SQL Server table has a trigger that can send ...
- 1,405
0
votes
1
answer
49
views
Authorithy URL format when creating database scoped credential in Azure sql
I'd like to create a database scoped credential using an Entra Service Principal.
We want to use this credential to mount an external table from another Azure SQL database.
Is this functionality ...
- 113
0
votes
2
answers
122
views
Merge rows in a specific sequence in SQL (Azure SQL)
Here is my sample data set:
ID
Timestamp
Duration
State
17
05.11.2024 00:00
0
Auto
16
04.11.2024 23:59
0
Auto
15
04.11.2024 23:58
1,47
Auto
14
04.11.2024 23:52
5,72
Manual
13
04.11.2024 23:...
- 3
0
votes
1
answer
54
views
Unable to 'Deploy Database to Microsoft Azure SQL Database' from SSMS 20.2
Hi have attempted to deploy our on-premise SQL Database to an Azure SQLDB using SQL Server Management Studion 20.2
However, I getting the following errors:
Error SQL71627: The element User: [topbs\...
- 2,703
0
votes
0
answers
78
views
How find default Azure SQL Server password on Azure for a .Net Aspire Deployment [closed]
I have created a .Net Aspire application which is deployed to Azure. I am using .Net 9.The startup code can be seen below.
var builder = DistributedApplication.CreateBuilder(args);
var ...
1
vote
0
answers
112
views
+50
Unable to link Azure SQL Database to Static Web App
I have an Azure SQL Database running. I've created a database blog and table Test.
Using the Azure Portal I've linked my database to the SWA.
Inside my app I have a directory swa-db-connections with ...
- 465
0
votes
0
answers
39
views
Impact of db_owner Permission on distributed transactions in ASP.NET Core 8 Web API using Entity Framework Core
I am working with an ASP.NET Core 8 Web API that performs Insert/Update/Delete operations across two different databases hosted on separate Azure SQL servers. The API uses a repository-level method to ...
- 8,071