Solved

SQL Server instances, to multiple domains

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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
schema master 5 27
Domain admin accounts get locked out 35 64
SQL Error - Query 6 27
I need to find the GPO setting to change for macros in Excel 4 25
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
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 from a Windows Server 2008 domain controller to a Windows Server 2012 domain controlle…
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 …

825 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