If you have SQL-Server Enterprise Manager (EM) or its newer version
SQL-Server Management Services (SSMS), it should be easy to check the
permission on this table and see why somes of these accounts cannot access
it.
This problem is more a permission problem than an ODBC problem and you
should post your questions in the m.p.sqlserver.server newsgroup if you
don't know what are EM or SSMS or where you can find them.
--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF
"A McGuire" <allen.mcguire[ at ]gmail.com.invalid> wrote in message
news:O9VPuMGnGHA.1280[ at ]TK2MSFTNGP03.phx.gbl...
[Quoted Text] > I'm currently trying to troubleshoot an issue on Windows XP where the user
> is trying to set up a DSN to SQL Server and is getting the following
> error:
>
> [Microsoft][ODBC SQL Server Driver][SQL Server]SELECT permission denied on
> object 'sysdatabases', database 'master', owner 'dbo'. (#229).
>
> Now, the perplexing thing is that he does have access to some of the
> databases - I would think those should show up when setting up the DSN.
> Furthermore, some users have said that they can connect on some computers,
> but can't on others. I've found no common thread to their issues. I've
> logged into the same computer and connected with my profile and
> credentials.
>
> A push in the right direction would be much appreciated.
>
|