acess a sql server in another domain

Posted on 2005-04-19
Last Modified: 2010-03-19
I have an application that I want to people outside the company to be able to access using MS 2000 terminal server. The application front ends an MS SQL DB, and uses NT integrated security to validate the client login to the DB.

I want to make sure that the people logging on do not have access to anything on the domain that is none of thier business. My first thought was to create a secondary domain, and then create a trust relationship to allow the users on domain 2 to access the sql on domain 1..

The main issue is that I simply don't know if it will work. Validation of the users into the app is based on roles defined on domain 1, and when logged in to the application, the login shows as DOMAIN\username. SO....

Is there anyway to set this up so that the logins from domain 2 can validate on the sql db on domain 1, but not have any other access to domain 1?

Question by:jbalaz
    LVL 14

    Expert Comment

    Put the SQL server in both domains with 2 NIC Cards.  Don't grand domail 2 users any access to the SQL Server, other than the SQL Login access.  SQL Server will then regognize moth domains for users.
    LVL 42

    Accepted Solution

    review DMZ Secure Architecture for an SQL / Web Server:

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Join & Write a Comment

    Suggested Solutions

    International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
    The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
    Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

    734 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

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now