Tutorial To Add Sql Server Account To Active Directory Domain

Question

Can anyone point me to a tutorial to add a user account from Sql Server to my domain so I can access my database through Windows Authentication?

Tutorial/link/step-by-step directions/etc.

Anything will do.

thanks.

---

chuckdawit

Answer 1

Its the other way around. You setup Mixed Mode Authentication, then add Windows AD groups/accounts as permissions to SQL Server objects.

http://msdn.microsoft.com/en-us/library/ms144284.aspx 

 

 

 

---

Regards, Dave Patrick ....
Microsoft Certified Professional
Microsoft MVP [Windows]

Answer 2

How do I add Windows AD groups/accounts to the be permitted by Sql Server?

---

chuckdawit

Answer 3

Hi.

I'm trying to create a new login by clicking from object explorer -> security -> logins -> new login, selecting windows authentication and typing in the name of my workstation like this (ex. WIN-DSHSH8DKJKS\administrator) and then pressing ok and then I receive a create failed message that says:

"Create login failed 'WIN-blahblah\administrator.

Windows NT user or group "WIN-blahblah\administrator' not found. Check the name again."

So I went to "Active Directory users and computers" console menu and looked up the computers in my domain docjohnson.sf.net and found my workstation with my administrator account added.

Am I missing something here, I see the workstation with admin account added in active directory but when I use the new login menu in sql server to find a user/group I can't find my workstation that I want to add.

---

chuckdawit

Answer 4

WIN-blahblah\administrator is a local account, use your domain account instead.

 

 

 

---

Regards, Dave Patrick ....
Microsoft Certified Professional
Microsoft MVP [Windows]