Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Unable to see non-default db in system dsn
0 views
Skip to first unread message
Todd777
Oct 30, 2009, 12:54:01 PM10/30/09
to
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.
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
Todd777
Nov 10, 2009, 1:36:01 PM11/10/09
to
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
0 new messages