Recommendations for adding a 2nd SQL Server

I have an SBS 2000 network set up and running fine.
We use the included SQL Server for a small Intranet...

Scenario:
I need to add a 2nd server (win2k?) with an enterprise version of SQL
installed that a company wide software package will access. Only about 50%
of the users log into the SBS server... the other 50% simply sit on the LAN
(i.e. don't have internet access, e-mail, etc...) but will need to attach to
the 2nd SQL Server (using SQL rights... not the server's).

Does anyone have any input, cautions, recommendations?? I remember PDC and
BDC from NT... but what about w2k and SBS??... What happens with DHCP....

ANY input is greatly appreciated!!!
-Dennis

-----------------------
You can use most any measure when you are speaking of success.
You can measure it in a fancy home, expensive car or dress.
But the measure of your REAL success is the one you can not spend.
It's the way your kids describe you, when they're talking to a friend.
-Martin Buxbaum

Marina
Wed Sep 15 09:34:15 CDT 2004

Hi Dennis,

You are aware of the fact you need a separate license for the memberserver
and a separate license for SQL server and CAL's?

http://members.microsoft.com/partner/salesmarketing/salestools/whitepapers/AddingServersToYourSBS2000Network.DOC

--
Regards,

Marina
Microsoft SBS-MVP

"Dennis" <tylersoldman@hotmail.com> schreef in bericht
news:ejRAF5ymEHA.2948@TK2MSFTNGP11.phx.gbl...
> I have an SBS 2000 network set up and running fine.
> We use the included SQL Server for a small Intranet...
>
> Scenario:
> I need to add a 2nd server (win2k?) with an enterprise version of SQL
> installed that a company wide software package will access. Only about
50%
> of the users log into the SBS server... the other 50% simply sit on the
LAN
> (i.e. don't have internet access, e-mail, etc...) but will need to attach
to
> the 2nd SQL Server (using SQL rights... not the server's).
>
> Does anyone have any input, cautions, recommendations?? I remember PDC
and
> BDC from NT... but what about w2k and SBS??... What happens with DHCP....
>
> ANY input is greatly appreciated!!!
> -Dennis
>
> -----------------------
> You can use most any measure when you are speaking of success.
> You can measure it in a fancy home, expensive car or dress.
> But the measure of your REAL success is the one you can not spend.
> It's the way your kids describe you, when they're talking to a friend.
> -Martin Buxbaum
>
>

Dennis
Wed Sep 15 10:00:59 CDT 2004

EXCELLENT Whitepaper! Thank you Marina!

Yes, I was aware of the additional licenses.

I was just concerned (7P rule) that I would do a lot of work adding the
additional server, installing the SQL Enterprise, adding the ODBC drivers to
each wkstation to access the SQL, editing the HOST file, etc... to find out
that there was an easier, better, (or one that actually works!) way to do
it. The whitepaper answered that for me. Thanks again!

Prior Proper Planning Prevents Piss Poor Performance
-Dennis

"Marina Roos [SBS-MVP]" <marina@roos.nodontwantspam.nl.com> wrote in message
news:OFtvUDzmEHA.648@tk2msftngp13.phx.gbl...
> Hi Dennis,
>
> You are aware of the fact you need a separate license for the memberserver
> and a separate license for SQL server and CAL's?
>
>
http://members.microsoft.com/partner/salesmarketing/salestools/whitepapers/AddingServersToYourSBS2000Network.DOC
>
> --
> Regards,
>
> Marina
> Microsoft SBS-MVP
>
> "Dennis" <tylersoldman@hotmail.com> schreef in bericht
> news:ejRAF5ymEHA.2948@TK2MSFTNGP11.phx.gbl...
> > I have an SBS 2000 network set up and running fine.
> > We use the included SQL Server for a small Intranet...
> >
> > Scenario:
> > I need to add a 2nd server (win2k?) with an enterprise version of SQL
> > installed that a company wide software package will access. Only about
> 50%
> > of the users log into the SBS server... the other 50% simply sit on the
> LAN
> > (i.e. don't have internet access, e-mail, etc...) but will need to
attach
> to
> > the 2nd SQL Server (using SQL rights... not the server's).
> >
> > Does anyone have any input, cautions, recommendations?? I remember PDC
> and
> > BDC from NT... but what about w2k and SBS??... What happens with
DHCP....
> >
> > ANY input is greatly appreciated!!!
> > -Dennis
> >
> > -----------------------
> > You can use most any measure when you are speaking of success.
> > You can measure it in a fancy home, expensive car or dress.
> > But the measure of your REAL success is the one you can not spend.
> > It's the way your kids describe you, when they're talking to a friend.
> > -Martin Buxbaum
> >
> >
>
>