July 14, 2003 at 7:16 pm
Hello.
My group cannot create new logins on one of our servers without adding the logins to the master database. We're running Windows 2000 SP4, SQL Server SP3.
When trying to connect with a new login we get:
select permission denied on object 'spt_values', database 'master', owner 'dbo'
We've found that if we add the login to the master database, and don't choose sp_denydatareader, then the login will work. As soon as we remove rights from master, the login will not work.
Also, we've compared rights on the master database and on the spt_values table to a healthy server and have found no discrepancies.
Any thoughts or ideas?
Thanks.
Everett
Everett Wilson
ewilson10@yahoo.com
July 14, 2003 at 7:23 pm
Did you remove 'guest' user from master database?
July 14, 2003 at 7:25 pm
Sure enough, the guest account had denydatareader.
Thanks a bundle.
Everett
Everett Wilson
ewilson10@yahoo.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply