December 2, 2008 at 2:43 am
My new sql 2005 instance is running on a server that is a domain member, but the service accounts are running as localsystem.
(yes I will change the service accounts to a network user)
I'm trying to add a Windows group, to give members of that group rights on my server.
I select 'DOMAIN\Sql Administrators' as the login name and all appears to be fine.
When i try to apply this, i get >
'Create login failed for login 'DOMAIN\SQL Administrators' (micrsoft.sqlserver.smo)
Windows NT User or group 'DOMAIN\SQL Administrators' not found. check the name ...
Can anyone offer any advice or point me at a resource for debugging AD connectivity please?
(Domain is Windows 2008 & the domain controllers are replicating fine)
r
December 2, 2008 at 7:39 am
Sounds like there is a typo somewhere. Double check the group name.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
December 2, 2008 at 8:55 am
no typos
this happens with any users / groups i select by using the search box and subsequent 'select user or group' dialog.
no typing involved you see 🙂
December 3, 2008 at 11:47 am
A workaround is to create a Windows Local User Group on the server
add the domain users/groups into it, then add the Local User Group to SQL Server
If that works, at least it means server can talk to the domain controller
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply