Friday, September 21, 2012 12:14 PM
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!!
Friday, September 21, 2012 7:48 PM
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.
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.