Hi.

Successfully configured Publisher as a standalone server and Published database too.

Server1 - publisher database has been synchronized to AO availability group  setup as a subscriber Server1 and Server2.

As below commands...

• This reply was modified 2 years, 7 months ago by  SQL Galaxy.

Hi Ant-Green, Thanks for mentioned URL for how replication configured in AOAG setup and send transactional records to another server. but my requirements is receiving records in AOAG from another...

Error:

ConStatus Error [DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error.

In Application server does not connected to database server due to SQLOLDB driver, how to resolve this error?

Please suggest.

Thanks

Thanks.

Quarantined state cleared now after 5 hours.

what could be reason why node status changed to Quarantined state?

Does it need to change parameter WFC instance side?

Thanks

Hi Ant-Green thanks for update.

Yes. AOAG setup be a subscriber to a transactional replication publication. and Subscriber receiving records at every seconds from publisher. So please suggest if any what...

Checked TLS 1.0 version , this value is 0, it was disabled in server this location - Computer\HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.0\Client

1. system DSN working by using native client 11.0 and got connected...

Hi Mr. Brian Gale. Thanks a lots for sharing link. It is working as expected and SQL server connected as expected. once again thank you..!

Step 1: SQL instance changed...

• This reply was modified 2 years, 11 months ago by  SQL Galaxy.

Hi.

Let me explain. actually SQL and OS installed from template in new host.

if new server commissioned just applied template in new host. after that assigned new host name and new...

Thank you ANT_Green.

How do we maintain SQL jobs in secondary replica? how to set jobs execute primary and secondary AG when failover/switchover two nodes.

Thanks

Hi

Thanks for your reply

windows 2016 STD edition, SQL 2016 Enterprise edition.

1. MultiSubnetFailover=True this switch already mentioned application connection string.
2.  Application using 4 .2 version dotnet version - checked with apps...

Thank you Ant-Green for your reply.

Thanks for sharing troubleshooting TEMPDB growth in database setting in RCSI.

I checked TEMPDB row versioning is 160GB but  row versioning  cleanup showing zero values always in performance monitor. checked oldest...

• This reply was modified 3 years, 7 months ago by  SQL Galaxy.

if it is same domain, DNS in another subnet , try to update new IP address at Nodes, cluster, listener objects .

Thank you Antony.

New SQL User connected to snapshot database in Mirror instance.

Thanks.

This is existing Database mirror setup.

Followed as per your suggestion.

1. Created one new user/login at Principal Instance, it is reflected to Snapshots database also in Mirror instance after create Re-Snapshot...