Add AD Group to Sql Server 2005
Posted on 2008-10-03
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?