Windows Server 2003 Domain SQL Authentication
Posted on 2010-01-11
I have a windows domain where I am slowly migrating our servers (Windows 2008).
I have a lot of servers which are OCS servers and host a lot of production applications. Those applications rely on our database servers which are used pretty heavily
My question is that if I join both the SQL server and the OCS server in our domain, and for the sql user use a domain account in the Web.Confifg, for example, xyzdomain\dbuser1 and lets say for instance, the domain link goes down during calls, will this have any impact on the calls?
How does the SQL authentication protocol work in a domain environment?
Will the SQL login would be cached?
Please feel free to send technical links. I am looking for a technical explanation to support either argument whether the calls would fail, or there would be no impact on calls. The more technical the artical the better. Thanks.