none
What is a Domain account in Sql server. How do i create a Domain account? RRS feed

  • Question

  • Hi All,

    What is domain account ?. Why in companies Domain account is being   used. How do i create a domain account in my local machine ?

    Regards

    Chaithanya M 


    Regards Chaithu.. If it is usefull,Mark this as Answer.

    Tuesday, November 27, 2012 4:11 AM

Answers

  • Damain Account is the Active Directory account created under your company domain. By using the windows domain account is easier to manage and much secure. Windows integrated security model for SQL server is a recommended way for SQL server security and by using the Kerberos authentication you can perform the dynamic security. 

    You can't create a domain account in your local machine(if you are not a domain administrator), as only the AD administrator can create the windows domain account. But you can create your SQL logins from the Windows domain account when they are already in the AD.


    View Steven Wang's profile on LinkedIn | Blog: MSBICOE.com | MCSE: Data Platform | MCITP: BI, SQL Developer & DBA

    Hate to mislead others, if I'm wrong slap me. Thanks!

    Tuesday, November 27, 2012 4:24 AM

All replies

  • In Enterprise manager, on the server name, you right click properties, and authentication (or security - it's been a while since I've managed SQL Server), and set authentication modes to "mixed".

    Note that you can only add users to the database from Domains that are trusted/accessible by whatever domain the SQL server is a member of.

    Once you've done that, you can add users by DOMAIN\Username in the Add Users collection. Simply specify their domain username instead of a custom SQL name.


    Many Thanks & Best Regards, Hua Min

    Tuesday, November 27, 2012 4:20 AM
  • Damain Account is the Active Directory account created under your company domain. By using the windows domain account is easier to manage and much secure. Windows integrated security model for SQL server is a recommended way for SQL server security and by using the Kerberos authentication you can perform the dynamic security. 

    You can't create a domain account in your local machine(if you are not a domain administrator), as only the AD administrator can create the windows domain account. But you can create your SQL logins from the Windows domain account when they are already in the AD.


    View Steven Wang's profile on LinkedIn | Blog: MSBICOE.com | MCSE: Data Platform | MCITP: BI, SQL Developer & DBA

    Hate to mislead others, if I'm wrong slap me. Thanks!

    Tuesday, November 27, 2012 4:24 AM
  • Hi Hua Main,

                                Thanks for your reply. But i Dont understand what is Domain and what is it's use before going to how to create it.could you please help me by brefing a little about what and how ?

    Thanks

    Chaithanya M


    Regards Chaithu.. If it is usefull,Mark this as Answer.

    Tuesday, November 27, 2012 4:28 AM
  • Read

    http://www.elmajdal.net/win2k8/setting_up_your_first_domain_controller_with_windows_server_2008.aspx

    http://www.sharepointgenius.com/create-user-windows-server/


    Many Thanks & Best Regards, Hua Min

    Tuesday, November 27, 2012 4:43 AM
  • Hello,

    That's not explained with a few words, it's some more complex. You may ask your network guy's in your company how it works.

    See also TechNet Active Directory Domain Services


    Olaf Helper

    Blog Xing

    Tuesday, November 27, 2012 4:46 AM