none
Creating a windows account in Sql Server 2008R2 (account not in local host)

    Question

  • Hello every body,

    The Sql Server 2008R2 is installed in a company net but outside the company domain.

    The windows user that I want to use to login is in the domain.

    The value that I write in the account name in the management studio, when I create the account, is: <domain server name> \ <user name> , with windows authentication.

    When at the end I click OK, Sql Server 2008R2says that cannot find the user.

    Can someone help me, please?

    Many thanks

    Saturday, January 11, 2014 4:02 PM

Answers

  •  Microsoft securty suggestion is better to install SQL Server with Windows authentication and to install it not in a domain control.


    The suggestion is to don't install a SQL Server on the server running the domain controller!!, but of course on a machine which is joined to the domain; otherwise Windows Authentication won't work, you would have to use SQL Logins instead.

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Monday, January 13, 2014 7:48 AM

All replies

  • The computer needs to be added to domain if it has to recognize the user. Otherwise only option is to add user as a local account and use servername\username as username in sql

    Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/VmBlogs

    • Marked as answer by Stefano Soft Sunday, January 12, 2014 5:51 PM
    • Unmarked as answer by Stefano Soft Sunday, January 12, 2014 5:52 PM
    Saturday, January 11, 2014 6:07 PM
  • Hi,

    The Microsoft securty suggestion is better to install SQL Server with Windows authentication and to install it not in a domain control. So, as the matter of facts, are these two suggestions not compatible together?

    Best Regards

    Sunday, January 12, 2014 5:59 PM
  • Yep..I suggested the same thing. SQL Server would be installed with windows authentication only. My suggestion was you need to use local system account (Machinename\XXXX) in this case instead of domain account (DomainName\YYYY) as your computer is not part of the company domain.

    Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/VmBlogs

    Sunday, January 12, 2014 7:05 PM
  •  Microsoft securty suggestion is better to install SQL Server with Windows authentication and to install it not in a domain control.


    The suggestion is to don't install a SQL Server on the server running the domain controller!!, but of course on a machine which is joined to the domain; otherwise Windows Authentication won't work, you would have to use SQL Logins instead.

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Monday, January 13, 2014 7:48 AM
  • Hi Olaf,

    Thank you very much.

    So I have to put the machine, where SQL Server is installed, in the company domain.
    This machine has to be a member of the domain.

    At this point I can put the application in the same machine, where SQL server is, and write the connection string with <local host> and share this app with the clients of the domain.

    Is it right? Do you have any security suggestions? 

    Best Regards

    Wednesday, January 15, 2014 9:17 PM
  • Hi Olaf,

    Thank You very much. I have understood.

    So I have to add the machine, where the SQL server is installed, in the company domain.
    So I can also move the app in the same machine and share it with the clients of the domain. 
    Is it Right? Do you have any security suggestions?

    regards

    Wednesday, January 15, 2014 9:42 PM