check the sql connection driver you are using, these links detail further

https://learn.microsoft.com/en-us/answers/questions/1029316/ssis-connect-to-azure-sql-database-with-mfa

Or a system\user managed identity

https://learn.microsoft.com/en-us/azure/data-factory/enable-aad-authentication-azure-ssis-ir#run-ssis-packages-using-microsoft-entra-authentication-with-the-specified-systemuser-assigned-managed-identity-for-your-adf

dup post

We're a hosting company but the end-user/customer has a DBA who manages these servers so I'll get him to query the sys.credentials catalog for any backup to URL...

Yes it was clear from the description that this was azure sqldb rather MI, server securables are not available in SQLdb but supported under MI.

With sqldb they are managed at...

I have the user Managed identity <myusermanagedidentity> , granted it carte blanche alter with GRANT ALTER TO <myusermanagedidentity> successfully at the application database level with the intent to give...

Server 1-4 will all have one instance each or multiple instances?

Think about your design carefully and document it, create a POC environment if you need (and recommended).

wishful thinking I would say

nodes in a WSFC with AGs follow the same rules...

Thanks for the reply. Maybe I unnecessarily complicated the question. I wanted to ask if i have a group of servers: server1, server2, server3 and server4, where server1 and...

FCIs can be replicas in an AG but can’t convert to stand alone.

The maximum number of nodes for a WSFC is 64 so you could deploy one WSFC with 40...

I’m a little confused, the topic title states RDS backup and rsstore but you’re citing EC2  backup to url, the 2 are configured differently.

Also, have you tried what AWS support...

I just used a SQL acct for demo purposes, you would need to filter the event trace or have the headache of searching through it, you may have a group...

using the login event from the session category and capturing the relevant global fileds i was able to connect via a sql acct and pull data and see the connections...

can you supply a little more detail on the database and where it's situated, you mention azure

restore the filelist from the backup and report the files found