SQL Server(Tough one)

[LindaHewitt]

I am absolutely sure that it is SQL Server 2000 standard edition and not MSDE.

Just look at the R2 components link. That link does not say MSDE. As for their original SSBS 2003 CDs for confirmation.

FYI ... Microsoft tweaks each of these server programs, so that they are limited to how large a business can use SBS. Microsoft's objective is to get small to medium size business used to Microsoft integration, so that when these business require it, they will upgrade to the individual standard versions. This also makes the migration process much simplier.

http://www.itjungle.com/two/two052505-story02.html

http://www.smallbizserver.net/ This link verifies that it is SQL Server 2000, which is included in SBS.

http://www.microsoft.com/windowsserv...s/default.mspx

Here is the Google search that I used.

http://www.google.com/search?sourcei...ess+Server+sp1

Is it possible that the SP1 update process was not completed correctly? Or maybe SBS was not installed correctly.

UPDATE:

I just did some additional Google searches and discovered that there are multiple versions of SBS 2003 and that the standard edition does not include SQL Server 2000 but the premium edition does include SQL Server 2000. Because this product is heavily subsidized and limited to maximum number of processers and users, if you are trying to install a regular version of SQL Server 2000, then the problem that you are having is caused because there is an incompatibility here.

If this is the case, the solution is for your client to upgrade to the premium edition.

Here are some additional links, so that you can continue to do the research.

http://www.microsoft.com/windowsserv...s/default.mspx

SQL Server is not included in standard edition

http://en.wikipedia.org/wiki/Windows_Server_2003

Cheers,

Linda