Re: What version of SQL is on SBS R2 Standard and can I use it?


Thanks for the answers guy...I did some further investigating, called the
vendor, and it's recommend I go with SQL2005 Express as it allows for up to a
4GB database vs. MSDE which only supports 2GB. There no where near that, but
nothing like planing ahead.

Two questions:

1. Can someone point me to a white paper explaining step by step on how to
install SQL2005 Express on an existing SBS 2003 Standard server?

2. There are two versions listed for download, one with and one without
advanced services, and a toolkit. From what I can tell, running as a backend
server I should use the advanced services version, it this correct? Do I need
the tools?

Thanks,

Dave



"Steve Foster [SBS MVP]" wrote:

Daveinfla wrote:


OK I'm a bit light on the SQL training, OK a lot; I use the paint by number
method!

I'm setting up a new server for a client which was ordered with SBS 2003 R2
Standard, of course as luck would have it we discovered after the fact they
have two applications that use SQL databases. Actually one is currently
configured to use MSDE 2000 and the other is using Access but will support
SQL and we will be migrating that to SQL in the near future.

If the application vendor supports MSDE, then you're fine with MSDE.


If I'm not mistaken SBS 2003 R2 ships with MSDE installed for running
monitoring, SharePoint and one other instance. What version of MSDE is it
and
can it support 2 more instances? Keep in mind the two applications will
only
have 2 users accessing them at any given time; it's a very small office.

You cannot legally use the MSDE that ships with SBS for hosting anything
but the existing applications. That's a licencing restriction on MSDE.

However, you _can_ install another instance of MSDE if the application
vendor is shipping their product with MSDE, since that's licenced
independently to the application vendor (MSDE licencing is a bit weird,
even by MS standards).

Take the following into consideration when making recommendations.

I've been supplied instructions from the vendor on how to move the
application from the current server (desktop) running MSDE 2000 to a new
server with the following options:

Option 1: Install on a full version of SQL Server 2005
Option 2: Move from MSDE to MSDE (old server to new server)
Option 3: Move from EXPRESS to EXPRESS
Option 4: Move from MSDE to EXPRESS

From what I’ve read EXPESS ships on SBS 2003 R2 Premium, silly me I
thought
SBS Premium shipped with a full version of SQL, but $500 extra is a lot to
pay for Premium just to get SQL EXPRESS and since it’s a very small
office
I’d like to avoid that option if possible.

SBS2003 R2 Premium includes SQL2005 Workgroup. This is not the same as
SQL2005 Express. Express is the 2005 equivalent of MSDE.

What further confuses me is the fact that I’ve read EXPRESS is a free
download. Can it be installed on SBS Standard and used at the same time
MSDE
is running? If so, doesn’t that just leave ISA at a $500 price tag?

SQL2005 Express is indeed a free download.

It would be a possibility for the Access migration you're planning.

Since your application vendor appears to support SQL2005 Express as well
as MSDE, you can choose whichever suits you better for that (I'd simply go
with the vendors preferred choice).

--
Steve Foster [SBS MVP]
---------------------------------------
MVPs do not work for Microsoft. Please reply only to the newsgroups.

.

Relevant Pages

  • Re: Do I install SQL or MSDE
    ... Thanks for using the SBS newsgroup! ... difference of MSDE and SQL. ... In SBS 2003 environment, after you setup SBS 2003 server box successfully, ...
    (microsoft.public.windows.server.sbs)
  • RE: MSDE to SQL Server
    ... I understand that you want to upgrade MSDE instances ... We can upgrade the instance SHAREPOINT to SQL and it is not recommended ... Business Server 2003 ...
    (microsoft.public.windows.server.sbs)
  • Re: SQL or Access DB
    ... database files and see your data, with access you can create a workgroup ... I have once made a deploy package for MSDE and found myself coding in C++ ... i understood that this is now much better with sql ... the reall server version. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Windows Update - KB829358
    ... Some have SQL installed, Sharepoint not upgraded, and of course ... > I applied that patch and it hosed the MSDE. ... > picking my server and it does not show any servers or services listed. ... >> upgrade/patch. ...
    (microsoft.public.windows.server.sbs)
  • Re: WSS & WMSDE
    ... "Windows SharePoint Services is a Windows Server 2003 component, ... and if SPS 2003 is not installed WSS uses a special version of MSDE, ... known as SQL Server 2000 Desktop Engine, ...
    (microsoft.public.sharepoint.windowsservices)