Atradius (1/2/2014)
@GregEdwards - there has been no movement of this database nor any change in AD. The database in question was created on that server. The older databases did come from an earlier SQL2005 installation, but they do work.What would I have to look for when comparing the SIDs? As mentioned, the SID seems fine as I can share folders within with proper behaviour for the group. Seems rather an SQL Server issue, isn't it?
In the db that works, and the one that does not -
go to views, system views, and look at the records in sys.login_token
see if the SID's match for the Windows Group in question.
If they do not match, my guess is that what is in msdb will match what's in the db's that work, not the one that does not.