SBS Premium:Install SQL 2000 now or wait for SQL 2005?

Hello. I'm looking for advice on installing SQL 2000 in the premium edition
of SBS 2003 now, or waiting for SBS 2003 R2 which includes SQL 2005. We have
recently set up a new SBS 2003 box, but I have not yet installed the premium
apps. We would like to get started with some simple database development for
some simple web based interfaces, but I'm trying to decide wether it would be
better to just wait a few more months and upgrade to SBS 2003 R2 so I
wouldn't have to migrate data from SQL 2000 to SQL 2005.

Thanks.

Sol Rodriguez

 

Hello Sol,

Thank you for posting to the SBS Newsgroup.

I understand that you are SBS 2K3 Standard Edition now and you want to know
some information about SQL 2005 Workgroup in the SBS 2K3 R2. If I have
misunderstood your concern, please let me know.

Please take your time to read through my reply:

============

Actually, you can either

a. Purchase and install SBS 2K3 Premium to have SQL 2K. After R2 release,
and continue installing R2.

OR

b. Wait for SBS 2K3 R2 to be released for SQL 2005 Workgroup.

============

SBS 2003 R2 Premium now includes 2 CDs for Premium Technologies, SQL 2005
Workgroup Edition is in Disk 2. From your decryption, it seems that you
have not installed SBS 2K3 SP1 yet, so you need to install SBS 2K3 SP1 and
then install SBS 2003 R2.

For detail instructions to install SBS 2003 SP1, please refer to the
following SBS 2003 SP1 download page.

[Note]: Please read and follow the instructions carefully to complete the
installation.

Downloading and Installing Windows Small Business Server 2003 Service Pack
1
http://download.microsoft.com/download/e/0/f/e0fee8ce-768d-41c0-8871-9bc48e0
b3fc3/ToDownLoadFilesandReadInstructions.htm

For the Windows Small Business Server 2003 Premium SP1 which includes ISA
2004/SQL SP4, you need to order it.
http://go.microsoft.com/fwlink/?LinkId=45336

For the detailed steps to install ISA 2K4 and SQL 2000 SP4 (and W/MSDE
SP4), please see following document:

Completing Setup for Microsoft Windows Small Business Server Premium
Technologies
http://www.microsoft.com/downloads/details.aspx?FamilyId=87A48D35-54AB-4F63-
90A3-A884311202E1&displaylang=en

============

For your additional information:

1> From a support lifecycle perspective, SQL Server 2000, which was
available with SBS 2003 Premium will exit standard support at the end of
2007, while the standard support for SQL Server 2005 will be 2 years after
the release of next version of SQL Server.

2> Most applications designed for SQL Server 2000 Standard Edition will be
compatible with SQL Server 2005 Workgroup Edition. However it is important
to review the backward compatibility documentation for SQL Server 2005
available at this link:

Backward Compatibility
http://msdn2.microsoft.com/en-us/library/ms143232.aspx

Thoroughly testing your application in a test environment with SQL Server
2005 is recommended before upgrading your existing production application
installation to SQL Server 2005

3> I also found following Documents for your reference, please see:

Windows Small Business Server 2003: R2
http://www.microsoft.com/windowsserver2003/sbs/evaluation/faq/r2.mspx


Windows Small Business Server 2003 R2: Powering Small Businesses
http://www.microsoft.com/windowsserver2003/sbs/r2/default.mspx

Hope it helps! If you have any further questions or concerns, please feel
free to let me know. I am looking forward to hearing from you!

Best regards,

Brandy Nee

Microsoft CSS Online Newsgroup Support

Get Secure! - www.microsoft.com/security
======================================================
This newsgroup only focuses on SBS technical issues. If you have issues
regarding other Microsoft products, you'd better post in the corresponding
newsgroups so that they can be resolved in an efficient and timely manner.
You can locate the newsgroup here:
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx

When opening a new thread via the web interface, we recommend you check the
"Notify me of replies" box to receive e-mail notifications when there are
any updates in your thread. When responding to posts via your newsreader,
please "Reply to Group" so that others may learn and benefit from your
issue.

Microsoft engineers can only focus on one issue per thread. Although we
provide other information for your reference, we recommend you post
different incidents in different threads to keep the thread clean. In doing
so, it will ensure your issues are resolved in a timely manner.

For urgent issues, you may want to contact Microsoft CSS directly. Please
check http://support.microsoft.com for regional support phone numbers.

Any input or comments in this thread are highly appreciated.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.



--------------------

 

Thanks for the reply Brandy. I actually have the Premium edition of SBS 2003
already, I just haven't installed SQL or ISA yet. That's why I'm wondering
IF I should install SQL now, or just wait for SQL 2005 in R2.

Any thoughts?

Sol

 

Hello Sol,

Thank you for posting back!

I am sorry for the delayed response due to the weekend. Please understand
that the newsgroups are staffed weekdays by Microsoft Support professionals
to answer your systems and applications questions. Your understanding is
greatly appreciated!

Actaully, it depends on your business needs if install SQL 2K now or waiti
for SQL 2K5 Workgroup in R2. From your reply, I understand that you have
Premium Edition, in this case, you can try and install the Premium first.

If you have any further questions or concerns, please feel free to let me
know. I am looking forward to hearing from you!

Best regards,

Brandy Nee

Microsoft CSS Online Newsgroup Support

Get Secure! - www.microsoft.com/security
======================================================
This newsgroup only focuses on SBS technical issues. If you have issues
regarding other Microsoft products, you'd better post in the corresponding
newsgroups so that they can be resolved in an efficient and timely manner.
You can locate the newsgroup here:
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx

When opening a new thread via the web interface, we recommend you check the
"Notify me of replies" box to receive e-mail notifications when there are
any updates in your thread. When responding to posts via your newsreader,
please "Reply to Group" so that others may learn and benefit from your
issue.

Microsoft engineers can only focus on one issue per thread. Although we
provide other information for your reference, we recommend you post
different incidents in different threads to keep the thread clean. In doing
so, it will ensure your issues are resolved in a timely manner.

For urgent issues, you may want to contact Microsoft CSS directly. Please
check http://support.microsoft.com for regional support phone numbers.

Any input or comments in this thread are highly appreciated.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.



--------------------