Keep in mind, everybody that can use the linked server, will have the authority of the given "rmtuser" !

That's the reason I only allow read-only accounts to be used in...

How did you define the security to be followed when using this linked server ?

even on SQLMI there are restrictions for CLR stuff:

is your user profile stored with remote as primary ?

( = wrong implementation of a great concept )

indeed. Thank you for pointing the subtle difference.

Tried it.

Didn't provide the data I aimed for.

It did generate the same error as the debug channel at create time.

However, now I see it accepts the create of the event session.

Time to investigate ( for a short...

doesn't work !!! ( see OP )

did you check for "Cross database ownership chaining" ?

Ref 2: "Understanding Cross Database Ownership Chaining in SQL Server"

I want to restore the DBs to another MI in regular intervals as use to do in traditional SQL. Please suggest how to make it possible to schedule automated...

The only thing you can do - if you  really want your own backup files - is to remove TDE

have a look at "Removing TDE from a Database: Level...

You can, but only "copy_only" backups.

With PAAS solutions (like Azure SQLMI or azure sqldb) you tipically don't have to worry about backups after you have selected (and accepted $$) your...

A pleasure. Let me know...

IT DEPENDS !

Database mirroring is not dead yet! ( Such a shame Microsoft uses that terminology now in its cloud context )

It still works and in some cases outperforms AG's...

check "sql-server-diagnostic-information-queries-detailed-day-17" Query #40!

What is the actual error message ?

Do you have monitoring for succeeded and failed connections ( in this case especially on S2 ) ?

When using a SQLUser, how did you...