I have read several posts on SQL upgrades but none that answer all my
concerns. We run SBS 2003 SP2 (not R2) with SQL server 2000 SP4. A post I
read said it is possible to upgrade to SQL 2005 standard. We have 2
vendor-supplied apps that run on SQL which are compatible with 2005 and can
be reinstalled if needed. My main concerns are ISA Server 2004 and SBS
Monitoring which both run on SQL Server DE. Will they migrate with the SQL
2005 upgrade? If not, how do I reinstall SBS Monitoring?

Re: Upgrade of SQL 2000 to 2005 by Mariette

Mariette
Tue May 13 12:21:32 PDT 2008

In news:0431A1F1-420C-4A09-BC5E-052EA14D9C7A@microsoft.com,
JWL <JWL@discussions.microsoft.com> wrote:

> I have read several posts on SQL upgrades but none that answer all my
> concerns. We run SBS 2003 SP2 (not R2) with SQL server 2000 SP4. A
> post I read said it is possible to upgrade to SQL 2005 standard. We
> have 2 vendor-supplied apps that run on SQL which are compatible with
> 2005 and can be reinstalled if needed. My main concerns are ISA
> Server 2004 and SBS Monitoring which both run on SQL Server DE. Will
> they migrate with the SQL 2005 upgrade? If not, how do I reinstall
> SBS Monitoring?

You should not touch the Monitoring and ISA instance. Just leave them as is.
Here is a doc that describes how to upgrade the Sharepoint instance. Most of
that doc will also apply to your SQL instances:

Smallbizserver.Net > Windows Small Business Server 2003 > SQL 2005:
http://www.smallbizserver.net/Articles/tabid/266/articleType/CategoryView/categoryId/59/SQL-2005.aspx


--
Mariëtte Knap
Microsoft SBS MVP since 1999
One of the Magical M&M's
www.smallbizserver.net
Forum: http://www.smallbizserver.net/Default.aspx?tabid=53
Articles: http://www.smallbizserver.net/Default.aspx?tabid=266



Re: Upgrade of SQL 2000 to 2005 by JWL

JWL
Tue May 13 12:43:01 PDT 2008

Thanks, Mariette, for the prompt reply. We don't use Sharepoint but I'll go
thru those steps. And thanks for the answer on ISA and SBS Monitoring. I
expect this to go smoothly now.

"Mariette Knap [SBS MVP]" wrote:

> In news:0431A1F1-420C-4A09-BC5E-052EA14D9C7A@microsoft.com,
> JWL <JWL@discussions.microsoft.com> wrote:
>
> > I have read several posts on SQL upgrades but none that answer all my
> > concerns. We run SBS 2003 SP2 (not R2) with SQL server 2000 SP4. A
> > post I read said it is possible to upgrade to SQL 2005 standard. We
> > have 2 vendor-supplied apps that run on SQL which are compatible with
> > 2005 and can be reinstalled if needed. My main concerns are ISA
> > Server 2004 and SBS Monitoring which both run on SQL Server DE. Will
> > they migrate with the SQL 2005 upgrade? If not, how do I reinstall
> > SBS Monitoring?
>
> You should not touch the Monitoring and ISA instance. Just leave them as is.
> Here is a doc that describes how to upgrade the Sharepoint instance. Most of
> that doc will also apply to your SQL instances:
>
> Smallbizserver.Net > Windows Small Business Server 2003 > SQL 2005:
> http://www.smallbizserver.net/Articles/tabid/266/articleType/CategoryView/categoryId/59/SQL-2005.aspx
>
>
> --
> Mariëtte Knap
> Microsoft SBS MVP since 1999
> One of the Magical M&M's
> www.smallbizserver.net
> Forum: http://www.smallbizserver.net/Default.aspx?tabid=53
> Articles: http://www.smallbizserver.net/Default.aspx?tabid=266
>
>
>