SQL Server and multiple domains

  • Hi,

    We have a separate Windows 2003 server with SQL Server 2005 installed (for example SQL01). This server is connected to Domain XXX.

    A new SQL login with Windows Authentication can be created from domain XXX.

    Now the problem:

    There is also another Domain server in our network, domain YYY.

    Is it possible to add the users from domain YYY to the SQL server (SQL01)?

    When i search for users in SQL i only see the users form domain XXX and not form YYY.

    Thanks.

  • Found solution:

    Make trust connection between windows domain server XXX and YYY. Now the other domain (YYY) is also accessible in SQL server.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply