Windows Authentication | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Windows Authentication

We have our App server and DB Server in a different domains. If I intend you use Windows authentication for the SQL Server, how would I go about setting up the user in a different domain to authenticate using the windows credentials. Thanks for your time in advance
Make the two domains trust each other
Add windows logins of app server domain to SQL Server security. Gaurav
Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard

Only a one-way trust is required… DB Server domain needs to trust app server domain. If these are separated by a firewall and the app server is webfacing, then consider using SQL authentication to avoid opening various ports on the firewall, which may allow a piggy back connection from the app server through the firewall into your internal domain Cheers