Bug:  The list of databases in the connection dialog is not populated and connection fails if user is a member of db_denydatareader in any database

【相关信息】
Article ID: 40645
Bug Id: NIM085951
Software:
ArcSDE 10.1
ArcGIS for Desktop Advanced 10.1
ArcGIS for Desktop Standard 10.1
Platforms:
Windows Server 2008, Windows 7

【BUG描述】
Attempting to populate the Database drop-down list in the Database Connection dialog box returns an error:

"Unable to connect to database server to retrieve database list; please verify your server name, user name and password info and try again. Invalid database name."

Manually entering the database name returns an error:

"Failed to connect to the specified server. Do you want to continue? Invalid database name."

A connection file may be created but a connection cannot be made successfully.

【BUG原因】
If any of the following conditions are true the database list is not created and the connection fails:

• The connecting user has been added to the db_denydatareader role in any database, not just the one they are attempting to connect to.
• The connecting user is a member of a database role, including public, that has been added to the db_denydatareader role.
• The 'guest' user in any database has been added to the db_denydatareader role.

The built-in database role db_denydatareader exists in every database. Users who are added to this role cannot read any data in that database, regardless of any other explicitly granted or inherited permissions that may exist. Every member of a role added to db_denydatareader inherits this permission and is unable to read any data in the database.

The guest user is a built-in database user. Any permissions assigned to the guest user in a database are inherited by all the logins on the SQL Server instance, even if they are not users in that database.