November 26, 2009 at 10:54 pm
Hi all
I get an error on my 64bit Ent SP1 SQL 2008 windows logins. It failes with state 11 which point to a rights problem with the default database. I checked my logins and they are all pointing to master. The master guest account is enabled. I then made the login dbowner on master, msdb, model and tempdb. This did not work. The only way I get the login to go through is by adding sysadmin rights for it but this is not acceptable. The funny thing is the local loggins work fine with the same rights.
Can anyone tell me if I am missing something or if this is a known issue.
Thanks
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Do not reinvent the wheel.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
November 27, 2009 at 4:50 am
use the "execute as login = " command and impersonate the login that you have issues with, see if you can work out what it is complaining about.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
November 27, 2009 at 5:39 am
Hi
For all those who had the same problem. I found the problem on my side. One of the ad groups that the user belonged to was denied access to the server. I enebled access but only gave the group public access. This worked for me.
As far as i understand it works like this.
Step 1: verify user + password
step 2: check if user is sysadmin if so no need to apply any other rights
step 3: apply group rights
step 4: apply explicit user rights
if one group is denied access the sql server stops.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Do not reinvent the wheel.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply