Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center >
> 
> 
Windows authentication question

Answered Windows authentication question

  • Friday, September 21, 2012 12:14 PM
     
     
    Sign In to Vote
    0

    Hello All,

    just a newbie question: is it possible to configure the server (MSSQL2008R2) to accept only windows authentication and connect to the server remotely without setting up a domain?

    I thought that could be possible setting the same user accounts and password on both the server and the clien PC but it doesn't work.

    Is it possible to get that working without enabling mixed authentication mode?

    Thanks you very much!!!Have a nice weekend!!

    Marc

     

All Replies

  • Friday, September 21, 2012 7:48 PM
     
     Answered
    Sign In to Vote
    1

    Windows authentication is not possible without setting up domain.

    You have to go for SQL authentication in case you are not having domain.

    Mixed mode authentication need to be enabled for SQL authentication. You can not achived it with enabling mixed mode authentication.

    Regards,
    Rohit Garg
    (My Blog)
    This posting is provided with no warranties and confers no rights.
    Please remember to click Mark as Answerand Vote as Helpfulon posts that help you. This can be beneficial to other community members reading the thread.