[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1139
  • Last Modified:

Add AD Group to Sql Server 2005

On my old (Sql 2000) box, there is an AD group in the Security folder named "ACME\Future Vision".

I want to add this AD group to my Sql 2005 server.  How do I do that, exactly?

When I go about it the way I expect it should be done:

a.  create new login
b.  select user or group -> enter group name and select "Check Names"

I get "The object named "ACME\Future Vision" is not from a domain listed in the Select Location dialog box, and is therefore not valid."

What's wrong here?  I know crap about AD and how it can be made to interact with Sql.

How do I create this group on my new server?

Thanks.
0
bamapie
Asked:
bamapie
  • 4
  • 4
  • 2
2 Solutions
 
J_CarterCommented:
click the search button on the create new login prompt... when the "select User or Group" dialog box comes up click the "Locations..." button. expand entire directory, then expand the domain and select you AD domain that your AD group is in. click OK then try and add the group again.
0
 
bamapieAuthor Commented:
When that "Locations" dialog comes up, I have the name of my server ONLY, in that list.  Cannot be expanded, double-clicked, nothing.
0
 
chapmandewCommented:
create login [ACME\Future Vision] from windows
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
J_CarterCommented:
sounds like that server isn't added to the domain.
0
 
bamapieAuthor Commented:
It's in the domain.  I see evidence of this in Control Panel->System->Network Identification.  Also see it when I execute nbtstat -a.
0
 
chapmandewCommented:
did you try the command i gave you?
0
 
bamapieAuthor Commented:
Sorry, was that a script to execute in sql?  I thought that was a verbal instruction, not a literal script to execute.

0
 
chapmandewCommented:
yep, that is the actual script to run.  :)
0
 
bamapieAuthor Commented:
Comes down to this.  Boneheaded thinking on my part.

I was connecting through mgmt studio...from my laptop.  Which isn't in the domain.  So really, while my sql box IS in the domain, I was experiencing a problem similar to J Carter's diagnosis.  Had I been running mgmt studio from the actual sql box, or had my laptop been in the domain, I would've been fine.

At the same time, chapmandew's recommendation worked.  Once I was told it was a script and not some non-native speaker's broken English (and sorry for that, again).

I'm inclined to give chapmandew the credit for answering, but to split the points evenly with Carter.  Does that give anyone heartburn?  I'm totallly open to suggestions and just want to be fair.

Thanks
0
 
chapmandewCommented:
sounds good.
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 4
  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now