Sorry if this seems like a noob type question, but I am a database
programmer trying to help out a client.

We have a client using SBS 2003 as a file server and hosting our SQL Server
database.

They are running out of memory resources and the database is timing out.
When I took them through a list of SQL databases and processes running on
their machine I found they had Sharepoint and Exchange. They have stopped
using exchange since they moved all of their email to an outside prover.
They don't even know what Sharepoint is! (I only know sharepoint allows
document exchange)

My question is this. Should their IT consultant be able to disable
Sharepoint and Exchange and free up some resources without too much trouble?
Any gotchas I should warn them about?

They also have a "MSSQL$Sharepoint" SQL database. If they disable
Sharepoint I assume I can stop this instance of SQL from starting also?

Any links to setting up/configuring a minimal configuration of SBS would be
helpful as well.. I should probably know this stuff at least to warn
potential clients about how to optimize their setup.

Thanks in advance!

Jerry Justic

Hi

This group is for older versions of SBS. You may get more response in the
SBS 2003 Newsgroup.

SBS public Newsgroups:

SBS 4.x: microsoft.public.backoffice.smallbiz
SBS 2000: microsoft.public.backoffice.smallbiz2000
SBS 2003: microsoft.public.windows.server.sbs

if your current news server does not carry these groups you should
be able to connect directly to news.microsoft.com

Now that the housekeeping is out of the way, the solution seems pretty
drastic.

The clients IT guy did not do them any favors to get the best small office
system on the planet and then cripple it.

That server probably is under resourced with either RAM, CPU or the speed
/capacity of the drives, or all three. There is no reason why Exchange
Sharepoint and any reasonable installation of SQL should not run on a well
equipped SBS.

Having said all that, no reason why your client's IT guy could not uninstall
Exchange and Sharepoint. Lots of things won't work right, but if they don't
care then I guess they could live with it.

It is also possible to reduce the footprint of the various default instances
of SQL

http://msmvps.com/blogs/bradley/arch.../04/34984.aspx

and her earlier post referenced in the one above.

--
Larry

Please post the resolution to
your issue so that all can benefit.


"Jerry J" <jerryj@datair.com> wrote in message
news:%23Zr27bNmIHA.3512@TK2MSFTNGP03.phx.gbl...