November 3, 2009 at 9:12 am
I am trying to set up a system dsn to a SQL Server 2005 db and when I check
the box to select a non-default database, I am unable to see other
(non-default) databases that I do in fact have access to.
I am using Windows auth.
Sql Server driver version 2000.85.1117.00.
Thanks!
-Todd
November 3, 2009 at 1:59 pm
Hi,
There is a checkbox "Connect to SQL Server to obtain default settings for the additional configuration options" on the second page of the "Create a New Data Source to SQL Server" wizard, after you select the driver (I used 2005.90.4035.00)
If this checkbox is unchecked, the list of databases is not retrieved from the server.
Regards
Piotr
...and your only reply is slàinte mhath
November 10, 2009 at 2:08 pm
Finally found the anwswer.
Someone had removed permission for public to view the databases:
USE Master
REVOKE VIEW ANY DATABASE FROM public
Re-granting view to public resolved the issue.
-Todd
November 10, 2009 at 5:35 pm
Thanks for sharing this.
Piotr
...and your only reply is slàinte mhath
November 10, 2009 at 8:50 pm
Hi Piotr,
You are welcome. And thank you for the idea you posted earlier!
-Todd
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply