Bear in mind that the user who owns the database maps in via the dbo database user and can do all that members of db_owner role can do

The databases are using TDE or column level encryption?

also run the following and supply the query results

select name, is_master_key_encrypted_by_server
from sys.databases
where name='ssisdb'

have you created a security policy, cant see code example below, might be worth reading this before you go any further

https://learn.microsoft.com/en-us/sql/relational-databases/security/row-level-security?view=sql-server-ver16

need more info on the source A database, anything obvious in the logs?

Here are some articles on 824 and 825 error that may help

824 err

825 err

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 related...

Recommend you try again and go through in detail following the relevant sections

Hi Perry,

Thanks for the reply. I'm not much of a SQL guy so I'm not sure how to go about "query the sys.credentials catalog for any backup to URL...

Which guide you use

Seems to be steps missing there.

have you confirmed you can open the master key on the source and the destination

The only custom CDC alerting I have done for sql agent jobs is around AG failover what parameters are you currently targeting

important to understand the encryption hierarchy, each time a project\package is created and...

• This reply was modified 1 day, 11 hours ago by  Perry Whittle.

So we have no issue logging into the the instance at all, the setup is pretty much as it was before i migrated.  The issue only arises when I...

the kerberos SPN tool is very useful here, heres the link for future reference

https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/connect/using-kerberosmngr-sqlserver

I have a 3 terabyte database that is taking over 5 hours to backup and restore. I'm utilizing multiple files to do the backup. We are on an Azure...