Got it.

There was a different database role that was a member of the role I was trying to remove from the selected db users. I needed those db users...

Check out the suggestions people gave me on my post about the same issue and see if anything helps you. Nothing has resolved my issue so far, but I believe...

There are no database triggers present that would cause this to happen. Also, I'm not quite sure what events I should be capturing in the Extended Events Session to be...

I did another test by dropping the user and re-creating them in the database. This will - of course - remove them from the role. However, when I add them...

Running that query returns the same name as the login that I put in for l.name

Thanks,

JimiHaze

The owner of the database is [sa].

Yes, I changed all of your examples into what I needed.

Certainly. Here's one that I've tried running a few times:

USE [myDB]

GO

ALTER ROLE [DBRole] DROP MEMBER [DOMAIN\serviceAcct]

GO

[DOMAIN\serviceAcct] is what I used for 'where name = ' in the post above.

Thanks,

JimiHaze

LoginSID : 0x010500000000000515...

DBUserSID: returned nothing

It is not in a DMZ, however it is behind more than just a Windows Firewall, there's a firewall appliance in the middle. I will try adding the inbound rules...

Hi, thanks for the response.

I'm trying to connect from one SQL instance to another SQL instance. For simplicity I will call the server initiating the connection the SOURCE and the...

This worked perfectly for what I need! Thank you so much!

Regards,

JH