SQL Server Performance

Windows Authentication

Discussion in 'General DBA Questions' started by cbarus, Sep 11, 2003.

  1. cbarus New Member

    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
  2. gaurav_bindlish New Member

    Make the two domains trust each other
    Add windows logins of app server domain to SQL Server security.

    Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard
  3. Twan New Member

    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


Share This Page