How to configure the AD authentication when the database located on backend network?

Question

Hi,
 
How to configure the AD authentication when the database located on backend network?
 
The AD server that located on frontend network is cannot reached backend network because network was physically separated.
 
In this situation, If you were me, how to configure the AD on backend network so that the database could AD authentication login?
 
My software version environment is following;
 
OS:Window Server 2008 R2
 
DB:SQL Server2012
 
Netwok:Common network that you think

Regards,
 
David

Answer 1

David,

I'm not sure what your question really is. Aer you asking how to setup a domain controller or domain services from a windows infrastructure perspective or are you asking how you can get SQL Server to use AD authentication when no domain controller is available?

If it's the second part, the answer is that you can't. If your network access does not allow you to talk to a DC then windows authentication is not possible except for local accounts.

If the quesiton is the first part, you may want to ask it in a windows forum as I believe you'll get more responses of better quality.

-Sean

---

Sean Gallardy | Blog | Twitter

Answer 2

Sean,

Sorry for ambiguously question.

As you said that how I can get SQL Server to use AD authentication when no domain controller is available was more similar with my question.

As I could more exactly expression to my question, how could SQL Server to use AD authentication when two separated network by front-end network and back-end network, the domain controller that existed on front-end network is couldn't reached back-end network environment, and I hope to connect with the domain controller that exsited on fron-end netwok because it'll more easy management for servers.

Many people using the database located on back-end network environment. so that I've question that how could using it? just using without AD authentication and using SA login?

David

Answer 3

I found the way to use AD authentication when back-end.

Using KCD.

See the detailed infromation is following;

http://technet.microsoft.com/en-us/library/hh831477.aspx#BKMK_kerb_const_del_domains

And I reconized this question proper to Windows Server forum.

Sorry that I confused it.

David