?
Solved

Windows Server 2003 Domain SQL Authentication

Posted on 2010-01-11
1
Medium Priority
?
254 Views
Last Modified: 2012-05-08
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.
0
Comment
Question by:wbokhary
1 Comment
 
LVL 10

Accepted Solution

by:
lof earned 2000 total points
ID: 26287595
I found this blog very helpful when looking into similar problem. It has a lot of references to MSDN and Technet.

http://blogs.msdn.com/sql_protocols/archive/2006/12/02/understanding-kerberos-and-ntlm-authentication-in-sql-server-connections.aspx

0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article, we’ll look at how to deploy ProxySQL.
Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question