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 advanceMake the two domains trust each other
Add windows logins of app server domain to SQL Server security. Gaurav
Moderator
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
Twan
]]>