2nd sql server server

I'm running Small Business Server 2000 but I need to move my SQL server
database onto its own box. Purchasing all needed licenses, can I add a
second server to my domain to act as a SQL server only. It will not have
any rights/responsibilities for the domain... it won't be a BDC. Can I do
this on my SBS network??

TIA, Ari

Henry
Wed Jan 14 01:32:05 CST 2004

Yes.
Just add another Windows 2000 server as a member server and install the
Full Packaged Product SQL Server and it's ( per Processor or User ) CALs
on it.

The Member Server will consume 1 SBS CAL for accessing the SBServer but
if it's a Win2000 server you will be covered for User Access to the
Member server by the SBS CALs. If you use a Win2003 server you will need
to also purchase Win 2003 CALS for User Access to the Member server.

--
Henry Craven.

========= Post It Appropriately: ============
SBS 4/4.5 : microsoft.public.backoffice.smallbiz
SBS 2000 : microsoft.public.backoffice.smallbiz2000
SBS 2003 : microsoft.public.windows.server.sbs
=====================================

"Coban" <HATES-SPAMguru@sbroome.com> wrote in message
news:OBc%23$Pe2DHA.540@tk2msftngp13.phx.gbl...
> I'm running Small Business Server 2000 but I need to move my SQL server
> database onto its own box. Purchasing all needed licenses, can I add a
> second server to my domain to act as a SQL server only. It will not
have
> any rights/responsibilities for the domain... it won't be a BDC. Can I
do
> this on my SBS network??
>
> TIA, Ari
>
>

Merv
Wed Jan 14 04:49:42 CST 2004

Yes but you will need to buy SQL as you can't use SQL from you SBS to
install on a second Server. Your can run win2Kserver from you SBS disk set
as a member server.

Regards

Merv N



"Coban" <HATES-SPAMguru@sbroome.com> wrote in message
news:OBc%23$Pe2DHA.540@tk2msftngp13.phx.gbl...
> I'm running Small Business Server 2000 but I need to move my SQL server
> database onto its own box. Purchasing all needed licenses, can I add a
> second server to my domain to act as a SQL server only. It will not have
> any rights/responsibilities for the domain... it won't be a BDC. Can I do
> this on my SBS network??
>
> TIA, Ari
>
>

Dclay
Sat Jan 17 18:11:05 CST 2004

An additional question, I have added the second server, but when I try to access the SQL server through my odbc connection using .asp pages I get an error telling me I was unable to log on to the SQL server using NT authentication/anonomus login? any suggestions will be greatly appreciated.

Henry
Sun Jan 18 16:07:40 CST 2004

That will depend a lot on your schema ... where the SQL Server is
located, where the Web Server is located ( hopefully, for securities
sake, both are in a DMZ outside the SBS Domain unless the app is only for
internal use), the Ports you assigned and opened in the firewall if you
needed to pass through it and the connection string you are using.

It's more appropriately a question for your .asp/programming Newsgroups

--
Henry Craven.

========= Post It Appropriately: ============
SBS 4/4.5 : microsoft.public.backoffice.smallbiz
SBS 2000 : microsoft.public.backoffice.smallbiz2000
SBS 2003 : microsoft.public.windows.server.sbs
=====================================
"Dace Clay" <Dclay@aerocoatings.com> wrote in message
news:C39E40A7-F7A5-4AEF-ADC1-1013348623F7@microsoft.com...
> An additional question, I have added the second server, but when I try
to access the SQL server through my odbc connection using .asp pages I
get an error telling me I was unable to log on to the SQL server using NT
authentication/anonomus login? any suggestions will be greatly
appreciated.