Re: Best Practice for multiple servers

From: Doug (anonymous_at_discussions.microsoft.com)
Date: 07/01/04 

Date: Thu, 1 Jul 2004 06:36:00 -0700

>-----Original Message-----
>Doug wrote:
>> Hi All,
>>
>> I wondered if I could get some advice on implementing my
>> system. I will have a SBS 2003 Standard running one of
my
>> businesses.
>>
>> I have a second business that will be on Win2K Server
with
>> separate SQL Server 2000 machine.
>
>Will this be on its own domain?
>>
>> Both businesses are separate with the exception of 1
>> employee, who should be able to access BOTH setups.
>
>Where are the networks/domains? Are you talking about
remote access of some
>sort?
>
>> I
>> wanted separate domains, but SBS2003 won't trust any
other
>> domains. My question is how do I get that 1 employee to
be
>> able to easily access both setups? He will need the
>> functionality of the SBS2003 (email, files, etc.) but
also
>> be able to get into the SQL server via the Win2K server
>> authentication. I was hoping to avoid having the second
>> business authenticate through the SBS2003.
>
>If they're in one office, he can access resources on the
other domain if he
>provides the correct credentials for it when mapping a
drive - for example,
>in a login script (and presuming he can reach the other
network & ping the
>other server by name):
>
>net use x: \\server\share /user:otherdomain\username
<enter>
>
>>
>>> I will eventually have a remote office connecting to
the SBS2003.
>>
>> Thanks in advance for any suggestions.
>
>
REPLIES TO YOUR POST:
>"Will this be on its own domain?"
 It depends. I was hoping to have it in its own domain
because there are 18 clients accessing only the SQL server
and only 10 accessing the SBS2003 (total = 28 users). I
thought it would be better to get CALs for Win2K for those
who will only be using the SQL server. But if I can't use
2 domains in this scenario for the 1 employee then perhaps
I would use 1 domain through the SBS2003.

>Where are the networks/domains? Are you talking about
remote access of some
>sort?
 Both networks are in the same physical location. I have
not set up the network yet. They currently have several
separate peer-to-peer networks that I hope to eliminate.
There will be no remote access other than through Remote
Web Workplace for a couple of users. In the future they
may have a remote office connecting to the SBS2003.

>If they're in one office, he can access resources on the
other domain if he
>provides the correct credentials for it when mapping a
drive - for example...
 Will this affect SQL server access?

Relevant Pages

  • Re: What is the best way to administering two separate forests?
    ... Now that you mentioned a trust relationship, it actually makes sense to do ... development and SQL Server management for them. ... network and network resources i.e. Exchange, SQL Server, applications, etc. ... We will just have a separate logical network with a separate ...
    (microsoft.public.win2000.networking)
  • Re: What is the best way to administering two separate forests?
    ... > Setting up the trust will require that the domains have dns name ... >> our SQL Server guy should be able to access our client's SQL Server ... >> keep our network separate AND protected but in the mean time, ...
    (microsoft.public.win2000.networking)
  • Re: Getting data over to SQL Server CE
    ... >then that IIS and SQL Server *must both be* on the same machine? ... You can keep both separate but it should be in the same network. ...
    (microsoft.public.pocketpc.developer)
  • Re: Design for historical data
    ... > types of visits are really that, 3 separate types of visits, which store ... billion rows of page delivery history in a system I helped build (I know ... Good design is important, decent, well balanced hardware (disk, ... Pro SQL Server 2000 Database Design - ...
    (microsoft.public.sqlserver.programming)
  • ODBC Connection with SQL Managed Provider
    ... on a "network drive". ... database using the Microsoft .NET Framework 1.1 Data Provider for SQL ... authorizing the user against a table in the SQL server database. ... for the app to display the "splash" screen (which is the first thing it does ...
    (microsoft.public.dotnet.framework.adonet)