July 29, 2002 at 1:05 pm
When doing a test connect via ODBC to a SQL db, I receive the following error:
Microsoft SQL Server ODBC Driver Version 03.80.0194
Running connectivity tests...
Attempting connection
Connection established
Verifying option settings
[Microsoft][ODBC SQL Server Driver][SQL Server]SELECT permission denied
on object 'sysconfigures', database 'master', owner 'dbo'.
[Microsoft][ODBC SQL Server Driver][SQL Server]SELECT permission denied
on object 'syscharsets', database 'master', owner 'dbo'.
Disconnecting from server
TESTS FAILED!
I am able to ping the server, and the DSN is set to TCP/IP and port 1433.
Anyone have any ideas as to what else I might check? Thanks!
July 31, 2002 at 6:35 pm
I would double check the permissions on those tables. For example, on my machine at home sysconfigures has select permission granted to public. Look for a red X on a permission - that's a deny and you'll need to remove it.
Andy
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy