Solved

SQL Server instances, to multiple domains

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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

Suggested Solutions

This article shows how to deploy dynamic backgrounds to computers depending on the aspect ratio of display
Always backup Domain, SYSVOL etc.using processes according to Microsoft Best Practices. This is meant as a disaster recovery process for small environments that did not implement backup processes and did not run a secondary domain controller that ne…
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…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

710 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