?
Solved

Windows Server 2003 Domain SQL Authentication

Posted on 2010-01-11
1
Medium Priority
?
252 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Percona Live Europe 2017 | Sep 25 - 27, 2017

The Percona Live Open Source Database Conference Europe 2017 is the premier event for the diverse and active European open source database community, as well as businesses that develop and use open source database software.

Question has a verified solution.

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

Recently, Microsoft released a best-practice guide for securing Active Directory. It's a whopping 300+ pages long. Those of us tasked with securing our company’s databases and systems would, ideally, have time to devote to learning the ins and outs…
In this article, I’ll look at how you can use a backup to start a secondary instance for MongoDB.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

800 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