I am running SQL 2005 on Win2003 server. Active Directory user group DB_All has full permissions on all databases on this server.
When adding an ODBC connection while logged as one of these users, after the first screen where you specify the default database, the database required is not one listed in the dropdown and when they try to connect they get an "Invalid Database error"
I have checked the permissions on these databases and cannot see why they all should not be listed when you click the dropdown.
There is only one database that does show, and I cannot see any difference in that one versus all the others.