The version we're running is SQL Server 2008 Service Pack 2 (10.00.4000.00) on Windows Server 2008 R2. This is affecting other versions as well. One other poster indicated he experienced...

I performed EXEC sp_change_users_login 'Report' to determine if, in fact, there were orphaned users. The results were nil.

Nonetheless as I mentioned above, in order to completely eliminate what I...

Looks as though the SQL User Interface is messed up. I opened a Support Case with Microsoft. They confirmed a coding problem and subsequently filed two Bugs for UI changes...

Understandable as to why no one replied before now. Looks as though the SQL User Interface is messed up. I opened a Support Case with Microsoft. They confirmed a coding...

The same issue surfaced in my environment with SQL 2008 after restoring a database taken from SQL 2000. I already tried the ALTER USER WITH LOGIN command to attempt ro...