Solved

SQL Server instances, to multiple domains

Posted on 2007-04-05
1
297 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
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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

This article runs through the process of deploying a single EXE application selectively to a group of user.
Last week, our Skyport webinar on “How to secure your Active Directory” (https://www.experts-exchange.com/videos/5810/Webinar-Is-Your-Active-Directory-as-Secure-as-You-Think.html?cid=Gene_Skyport) provided 218 attendees with a step-by-step guide for…
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

713 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