Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [read-only-routing]

11 questions
3
votes
1 answer

Availability Group Read Only Routing Not Working for SQL Logins

We have following config of Availability Group: server1.domain.com - primary server2.domain.com - sync secondary server3.domain.com - async secondary sql-listener.domain.com - availability group listener DNS name Recently we have setup Read Only…
Aleksey Vitsko
  • 6,148
  • 5
  • 39
  • 70
2
votes
1 answer

SELECT query in a SP in AlwaysOn Availability Group Read Only Routing

There is a stored procedure which has select statement as well as insert and other statements. What will be the behaviour of the stored procedure in a Read Only Routing configured in AlwaysOn Availability Group? Will the select statement go to the…
SSS
  • 397
  • 1
  • 9
  • 16
1
vote
1 answer

In azure sql db how to enforce the rule users should only connect using applicationintent=Readonly

For sql server availability groups we enforce the rule “users should only read from DR nodes” by first creating logins and users in the primary node and then dropping /disabling the logins on the primary . Is there a way to do the same for azure sql…
yegnasew
  • 497
  • 4
  • 8
1
vote
1 answer

Can we configure logins to only connect to read-only replicas in Azure SQL Database automatically?

For Read-Only routing, rather than explicitly using "ApplicationIntent=ReadOnly" into our application connection string or for individual users to specify it in additional properties, can this be configured while creating a login? For Example: Any…
Venkat
  • 131
  • 1
  • 5
  • 14
1
vote
1 answer

Availability Group Read Only Routing Not Working for Azure App Service that connects over Hybrid Connection

We have following config of Availability Group On-Premise: server1.domain.com - primary server2.domain.com - sync secondary server3.domain.com - async secondary sql-listener.domain.com - availability group listener DNS name Recently we have setup…
Aleksey Vitsko
  • 6,148
  • 5
  • 39
  • 70
0
votes
1 answer

Routing List Empty, and cant add using SQL either

Question: Why is my routing list empty? I have removed the secondary from the AG and re-added back, everything is healthy and synchronized. lets assume for the example that server1 is currently the primary. What can I check or try to…
Mike Kay
  • 1
0
votes
1 answer

always on ha availabity group force read only connection without specifying ApplicationIntent=ReadOnly

We have an AlwaysOn HA sql cluster set up, with read-only replicas in place, and read-only routing in place. We know how to properly route a connection to the read only replica (by specifying ApplicationIntent=ReadOnly connection property). The…
bradvido
  • 101
  • 3
0
votes
0 answers

SQL Server 2019 AOAG - ReadOnly ConnectionString Not working with error 80004005 Invalid connection string attribute

(I hope this is the proper place for posting, as it is about the database and its connection.) SQL Server 2019 / ASP Classic / ASP.NET I followed the information from this page. ReadOnly Routing (sqlservercentral.com) and have everything set up and…
CodingEE
  • 133
  • 2
  • 7
0
votes
1 answer

How to redirect read queries transparently to Secondary replica in Always on

We have Always ON setup for our database. Users are connecting to our database using listener URL. We are currently asking users to use ApplicationIntent = ReadOnly to redirect users to secondary replica. But, still many users are connecting to…
Venkataraman R
  • 117
  • 6
0
votes
2 answers

Always-on Avaialbility Group Secondary replica NOT identical to Primay

Can I have Always-on availability group primary node not identical to secondary? example: Primary Replica RAM 64, Cores 8 Secondary Replica RAM 256, Cores 32 As I estimate read-only queries to be 4 times writes, and I will use read routing to…
Amr Waheed
  • 3
  • 4
-1
votes
1 answer

AlwaysOn Availability Secondary replica not work as read only

We have configured SQL Server - Always On Availability group with SQL SERVER 2022 Enterprise Edition. where there is 2 instance which are also configured with Readable secondary 'Yes'. According to my little knowledge all the read queries should…
user3024056
  • 1