ASK SSC Topic

moving over here as this is more of the discussion forum rather than ASK SSC.

So if all you want is a readable...

Look at "sp_help_revlogin", its a script to download from MS, it will create a output for all the logins on one machine with the passwords hashed and the SID's so when you...

Take it your trying to get to SSMS to connect to the SSRS instance.  IIFC that uses RPC so you need to allow the full RPC port numbers which is...

Have you done any login cleanup recently?

Removing a principal from the server can also cause the above error.

Pudding

Works just the same, sys.database_permissions join to sys.database_principals where the permission class is 3

select perm

Crab