Logic APP connecting to AOAG Readonly
Hi Everyone, I have an Always on availability group with the secondary read-only server configured for read only intent. I noticed that there is no where in logic app where the readonly application intent can be configured as additional parameter. Am I missing something or it is just the way logic APP works. I have been able to connect ADF successfully. Please, can someone advise.
How to connect an Access database to an Always-On Listener?
I follow this instruction for SQL Server and hope it is applicable to the listener https://support.microsoft.com/en-us/office/import-or-link-to-data-in-an-sql-server-database-a5a3b4eb-57b9-45a0-b732-77bc6089b84e I go to EXTERNAL DATA -> NEW DATA SOURCE -> FROM DATABASE -> FROM SQL SERVER -> LINK TO THE DATA SOURCE BY CREATING A LINKED TABLE -> MACHINE DATA SOURCE -> NEW ->SQL SERVER -> then I enter a name and as server the DNS name of my listener, that is listener in my case. -> then I choose SQL server authentication method as authentication method and enter password and user -> then two errors come: SQLState: 0100 SQL Server error: 53 SQLState: 08001 ConnectionOpen (Connect()) SQL Server error: 17 SQL Server does not exist or access is denied. The ping to the listener also exists. With a SQL Server my steps work. What am I doing wrong?
SQL 2019 Enterprise Cluster setup
Hey Guys, I'm in the process of setting up Always on HA cluster on SQL 2019 Enterprise on virtual environment. Cluster will include SQL server instance on two separate Virtual machines with High availability groups - Synchronous replication - Secondary - "Readable Secondary -NO" ? Please help me clarify if; a. Microsoft licensing allows having two SQL instances on two separate VM's with one license? b. if yes, should the other node be Read-Only & Synchronous replication? c. If yes, how will it help incase of DR or if downtime is required on Primary node? d. If (b) is no, and both nodes have writable copy how does license taken into count? thanks