We are still looking into options and have not decided one way or other.

From what I have seen so far, Azure SQL DB is less expensive and easier to manage,...

We run CHECKDB job every week and also ran CHECKDB manually after this error, there were no errors.

There is an error logged in SQL log (Error 684 Severity 22). I...

I'm adding this for anyone here who are stuck with same issue.

I created a linked server on SQL MI (to connect to same SQL MI) and used it in the...

I'm adding this for anyone here who are stuck with same issue.

I created a linked server on SQL MI (to connect to same SQL MI) and used it in the...

Sorry if my post is not clear. I'm not having any issues setting up with Replication.  Only with running " sp_replmonitorsubscriptionpendingcmds" in openrowset, I was getting the error. As there's...

• This reply was modified 1 year, 5 months ago by  cooldude001.

Thanks Grant.

Yes, Querystore was enabled.

I have gone through the link you shared, it's actually listed as not supported for SQL MI and SQL Database.

For some reason, Microsoft doesn't allow these...

• This reply was modified 1 year, 8 months ago by  cooldude001.

Thankyou, is there a way to enable "Both Successful and Failed Logins" under server/instance properties for SQL Managed Instance.

For SQLserver, enabling this would require a restart. In SQL MI, it...

Thanks for the reply, There's only one connection string.

All the connections are only coming thru app and settings should be consistent for all the sessions.

• This reply was modified 2 years, 8 months ago by  cooldude001.

Thanks, Do you have any links for this setup of continuous sync from MI to MI using DataFactory

Thanks for your reply. We are looking for a database size of over 500GB and need all the tables to be replicated. I dont want to recommend Transactional replication as...

Thankyou for the reply.

We are using 4tb disk as the db size is 3tb. Regardless of the disk size it says in the link, latency for general purpose tier should...

• This reply was modified 3 years, 1 month ago by  cooldude001.

Thankyou, Do you happen to have any links for whitepaper on Azure Managed Instance (like best practices and guidelines for db setup).

• This reply was modified 3 years, 6 months ago by  cooldude001.

Update:

This has been fixed. I've installed latest Cumulative update on both SQL instances, rebooted the servers and it is working now.

Thankyou all for your help.

I tried with granting sysadmin role to Nt Authority\System, getting same error.

Also modified the owner of hadr_endpoint to sa, same error.

I see this error, when I checked eventlog on PrimaryReplica...

• This reply was modified 4 years, 5 months ago by  cooldude001.

Yes, SQL server instance starttup account is a domain service account. I've added that account to both servers as local admin and to the instances as Sysadmin.  Hadr endpoint port...

• This reply was modified 4 years, 5 months ago by  cooldude001.