Re: SQL Server Std over SBS 2003 std
- From: "Claus" <cjobes@xxxxxxxxxxxxx>
- Date: Mon, 28 May 2007 12:10:51 -0400
Charles,
What Henry is referring to is that SBS2003 Premium comes with SQL2000
Standard. SBS2003R2 Premium comes with SQL2005 Workgroup. If you buy the R2
upgrade with "downgrade rights" you can stick with the SQL2000. We have done
that quite a few times because clients had applications that wouldn't run on
SQL2005.
--
Claus
"Charles" <Charles@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5398CBC1-BB12-4454-889B-EDEEFD16F876@xxxxxxxxxxxxxxxx
Thanks Henry for this.
Sorry if I sound dumb but SQL is a whole new topic for me.
First, you seem to imply that upgrading to SBS 2002 Premium would bring
SQL
Server Std, which I don't think is the case, SBS Premuim only carries SQL
Server Workgroup Edition -- and that one does not come with the nice
Analyses
Service that we are interested in. But perharps (probably) I am missing
something since you also refer to "downgrade" rights which I am not sure I
understand.
But apart from the licensing aspect of the question, you also raise a very
important issue: that we would need another box to run those Analysis
Services. wow, that is a major complication for us. Just to make sure that
I
understood correctly: we would then need to install SQL Server Std on a
separate box, that would somehow be joined to our domain, correct? Sorry
to
ask a probably very basic question but on that separate box, what
operating
system would be running ? Another SBS 2003? As I am sure you can see, I am
quite confused about this.
One last thing on this, could'nt we just download and install the trial
SQL
Server std on the SBS 2003 std that we have now (MS offers a 180-day
trial)
to see whether our current box can take the extra work load?
Thanks again for your help
"Henry Craven {SBS-MVP}" wrote:
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
.
- References:
- Re: SQL Server Std over SBS 2003 std
- From: Henry Craven {SBS-MVP}
- Re: SQL Server Std over SBS 2003 std
- From: Charles
- Re: SQL Server Std over SBS 2003 std
- Prev by Date: Re: Vista and SBS 2003
- Next by Date: Re: Vista and SBS 2003
- Previous by thread: Re: SQL Server Std over SBS 2003 std
- Next by thread: Re: SQL Server Std over SBS 2003 std
- Index(es):
Relevant Pages
|
Loading
