August 21, 2003 at 9:23 am
Any ideas on what the following means when running an ODBC connection test:
Attempting connection
Connection established
Verifying option settings
[Microsoft][ODBC SQL Server Driver][SQL Server]SELECT permission denied on object 'syscharsets', database 'master', owner 'dbo'.
Disconnecting from server
The only change I can think of recently made was the network folks changed the IP address for the SQL cluster (due to a domain controller server problem).
Thanks for any help.
August 21, 2003 at 9:39 am
Did you remove 'guest' user from master database?
August 21, 2003 at 10:38 am
quote:
Did you remove 'guest' user from master database?
Whoever you are, you're wonderful! Thank you. It got me on the right track. The guest account on the master had db_denydatareader and db_denydatawriter checked in its properties so I unchecked and it connects. Duhhh!! Can you explain how the guest account works or refer me to good literature on it - I've removed it from all my dbs but understand it can't be removed from the master.
Thank you again!!!
August 21, 2003 at 12:16 pm
Look up "guest user" in BOL. It has a pretty decent explanation.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply