Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I am having my application on one domain and SQL server on different domain. How to link up them ?

share|improve this question

migrated from stackoverflow.com Apr 27 '10 at 0:11

This question came from our site for professional and enthusiast programmers.

    
Not programming-related - really belongs on Serverfault –  marc_s Apr 25 '10 at 20:15

3 Answers 3

You could just use SQL Server Authentication instead of Integrated Security (Windows Authentication). Then you can Access your DB across domain boundaries.

share|improve this answer

More complex solution is to establish trust between your domains using AD.

share|improve this answer

At worst, you can use NTLM Mirrored Accounts:

Mirrored accounts are not recommended, but are a workaround if you need to use Windows authentication and your Web server and database server are not in the same or trusted domain or if Windows authentication is blocked by a firewall. To use mirrored accounts, create a local account with the same user name and password on each server and then create a SQL Server login for the local account on the database server.

The link describes the process for ASP apps, but the same procedure applies to any application.

But the true, proper, solution is to establish trust between the two domains.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.