Oh - yes I did run it from the dB in question.

The dB in question.

If I run this in the dB in question the user shows up. I get the 3 result sets.

SELECT * FROM sys.sysusers;

EXEC sp_helpuser;

If I run it...

Because the account is showing up as \Domain\UserName that does not work

The number of orphaned users fixed by updating users was 0.

The number of orphaned users fixed by adding new...

Well I am trying to get the 1 user that has a domain account to show up so I can change the permissions on it. Yes we are using AD,...

I've tried that and double quotes, single.

I've tried stuff I knew wouldn't work.

In SQL 2008 R2 the EXEC sp_revokedbaccess 'domain\UserName' does not remove the user from the sysusers table.

I have tried sp_revokedbaccess,sp_dropuser, and sp_droplogin with and without [], '' and with the...

Yes. It actually looks like it is coming from NetApp. I guess tha if you have a virtual SQL server and running ComVault for backups (netApp in the background) this...

All great info.

I changed the encryption to none, but it made no change.

What I did find out is the SQL Agent was running under the Local System and it...

I read all of this thread and it does not pertain to my situation. Any help would be great!

I am getting the same error "The AcquireConnection method call to the...

Ok, Thanks. I'll tuck that one away for future use.

I found that and tried it - no such luck. http://support.microsoft.com/kb/918992

master..sysxlogins does not exist - syslogins does of course, but the scripts as is does not work.

What I...