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.

    Gaurav
    Moderator
    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

    Cheers
    Twan

Share This Page