Recreated this by creating a test SP, queue and service (owned by user test)

Try to drop user and get same message box, this will identify the service name and owning...

.

• This reply was modified 7 months, 1 week ago by  Perry Whittle.
• This reply was modified 7 months, 1 week ago by  Perry Whittle.

.

• This reply was modified 7 months, 1 week ago by  Perry Whittle.

Hi All,

We have 2 x physical servers with windows server installed connected to a SAN via iSCSI.

We then have Failover Clustered Instance (FCI) setup across the 2 physical servers...

Likely referring to a MSMQ service in the database, query the catalogs to find out which, the following should help

https://learn.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-services-transact-sql?view=sql-server-ver16

Definitely don’t restore SMKs across instances, they’re designed to be unique amongst instances and if you have existing objects protected by the original SMK then you lose those.

To downgrade the...

I think we’ve all been there at some point in the past.

As stated you have the risk of security issues arising, undiscovered software issues, aging hardware and OS, etc.

Remaining within...

I’ve used it in the past and it works but there are better dedicated products available but cost is the issue generally

CDC doesn’t play nicely with certain features such as...

If you’ve referenced DMA report and successfully changed and tested in dev and test then you have good level of assurance for prod change. You can always set it back...

Not relative to the amount of data, features support is primarily your concern

if you’ve successfully tested in dev and test then apply to prod

Would strongly advise not to enable that account

What’s the full error for the login failure, err number, severity and state

I created sysadmin user xxx . Now the wizard gives me this error:

Login failed for user 'xxx'

Which is funny because I am logged in as that...

As a test, try a sql account on the server where you’re attempting windows auth

Case by case scenario, running DMA pre migration  will pinpoint issues