I was finally able to resolve the hand-shake error. The issue was related to register the SPN for the new service account manually fore both server on the always on...

Hi Perry,

Thanks for the response, no way I was implying that I need answer right away. Was just  adding comments to keep the thread going.
To answer...

Based on what I see it seems for what ever reason the Quorum drive is losing connectivity in your node.. to avoid this, I have been using file witness quorum...

Well since no one answered yet, let me explain my plan so far.

I have two nodes always on AG

node1
node2
change the owner of the...

Hi Grant,

Thanks for the link. The article is talking about setting up AG between two Azure VM's whereas in my case I am looking for one on-premises to...

For clarity, let m explained in simple terms.... In replication, if the subscriber has data already ( from back and restore or bacpac option). Can I setup replication and sync the data...

Hi Steve,

I understand the security implications of not being able to know the password. However, this is the joy of working as a contractor, you come in and find out...

Hi,
we can try few things. Please download SSMS 2017 version. It will just install the client tool and try the import from there. It has worked in my case.

Thanks

If you are using Azure SQL VM than just it is just like have a VM in which you can install drivers and migrate SSIS packages to. For Azure SQL DB,...

Update- Even though the upload failed few times, however, ( third time the charm) it worked the third time. So I can safely say for blob storage there is not a...

Hi,
So let me take a crack at answering this. Please be mindful that I am no way azure expert here but have worked on it. In Azure, there is...