Solved

SQL Server instances, to multiple domains

Posted on 2007-04-05
1
299 Views
Last Modified: 2008-05-30
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.  
0
Comment
Question by:Michael Hale
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 33

Accepted Solution

by:
NJComputerNetworks earned 125 total points
ID: 18860132
you can configure either choice...

SQL supports local database security (created user names and passwords per database)  or integrated security ---using domain based ID's for secure access to the database.

0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
This process allows computer passwords to be managed and secured without using LAPS. This is an improvement on an existing process, enhanced to store password encrypted, instead of clear-text files within SQL
This tutorial will walk an individual through the process of configuring their Windows Server 2012 domain controller to synchronize its time with a trusted, external resource. Use Google, Bing, or other preferred search engine to locate trusted NTP …
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

622 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question