Re: SQL Server Std over SBS 2003 std
- From: "Henry Craven {SBS-MVP}" <sme@xxxxxxxxxxxxxx>
- Date: Mon, 28 May 2007 22:24:44 +1000
To a degree, this depends on your needs and business strategy for the future.
You could just install SQL Server std on the SBS Box ( that is what an upgrade to SBS 2003 Premium SP1 would do - the path for this is via SBS 2003 Premium with downgrade rights )
You could also upgrade to SBS 3002 R2 Premium with SQL Server 2005 (Workgroup Edition )
The analysis services in SQL 2005 are pretty amazing - http://www.sqlserverdatamining.com/DMCommunity/FAQ/default.aspx
- but you'll want to install the analysis services on a separate server - The performance hit is pretty severe and not something you'd want to do to the SBS Box.
SBS "Premium" versions come with ISA as well as SQL, which you may or may not want.
Additional consideration would be as to whether you want external users to connect to the SQL Server, in which case they would need either Domain Accounts and SBS CALs ( with the premium upgrade ) or you'd buy SQL Server as Per Process License.
( hope you can pan out a bit of colour from amongst that shale )
--
Henry Craven {SBS-MVP}
"Charles" <Charles@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:C78B675D-1E54-48AE-8778-4FAA07B154E5@xxxxxxxxxxxxxxxx
We have SBS 2003 std and would liketo use the data mining facilities of SQL
Server std, as opposed to SQL Server for Workgroups. So it appears that
simply upgrading to SBS 2003 premium would not do the trick.
What is the best route?
For instance , is it possible and advisable to simply install SQL Server STD
over SBS 2003 std? Or should we first upgrade to SBS 2003 premium and then
upgrade SQL Server to std?
Many thanks in advance,
Charles
.
- Follow-Ups:
- Re: SQL Server Std over SBS 2003 std
- From: Charles
- Re: SQL Server Std over SBS 2003 std
- Prev by Date: Re: Remote workplace - recomeneded setup ?
- Next by Date: Re: Vista and SBS 2003
- Previous by thread: RE: Kerebros Errors
- Next by thread: Re: SQL Server Std over SBS 2003 std
- Index(es):
Relevant Pages
|
