Hello Experts. I hope you find this thought-provoking
My desired scenario- two servers, each a controller for its own domain. Users will connect via Terminal Services to each. A third server will run SQL Server.
My first-choice outcome- The SQL Server would run two instances, each containing the databases for one of the domains. A given domain would see only their instance, and thus, their own databases.
My second-choice outcome- The SQL Server would be visible to each domain. I could then configure their application software to point to the databases in their instance only.