Avatar of colin911
 asked on

Companyweb not working in SBS 2003

I have gone through a bunch of configurations with my SBS 2003 and have the end result of companyweb not working.

It was working fine when I first installed SBS 2003.

Then I wanted to get CRM 3.0 working on the server so I installed SQL2005.  SQL 2005 was making the machine really slow, so I uninstalled it.  At that point companyweb stopped working.  Since I wanted to get CRM working again, I installed SQL 2000.  After all the updates were installed, Companyweb started working again.

Finally, the crm was not what was expected, so decided to get rid of it, at least for now and then reinstall it on a different machine. So I uninstalled CRM and SQL 2000.  And then companyweb stopped working.

So I reinstalled SQL 2000 and stil companyweb does not work.  I get the error:
not connect to the configuration database. For tips on troubleshooting this error, search for article 823287 in the Microsoft Knowledge Base at http://support.microsoft.com.

So I looked at the article (http://support.microsoft.com/?kbid=823287) and followed the steps.

In method 1 and 2, everything was ok.

In method 3, when I got to the part:
1. Click Start, point to Programs, point to Microsoft SQL Server, and then click Enterprise Manager.
2. In the left pane, double-click Microsoft SQL Servers, and then double-click your SQL server group.
3. Double-click your server.
There was no server listed there.  At this point I'm not sure what to do. Obviously there is justsome linking to to to the database, but I don't know much about SQL and so need some help.  What do you suggest doing now?

Avatar of undefined
Last Comment
Jeffrey Kane - TechSoEasy

8/22/2022 - Mon
Murat Raymond

Why didn't you leave SQL 2000 and just uninstall CRM?
SQL Will not do any arm to the system.

Company web was setup to use MSDE by installing SQL you probably uninstall the instance for Company web.

If I am right those services should stop working.

I would reintall SQL 2000, Or reinstall MSDE. By doing so maybe the instances for company web will start working again.

You  Should setup a lab to try things before you install them on a working server. Or make a full backup so you can back step.

Jeffrey Kane - TechSoEasy

When you say that you installed SQL 2000, what version?  Is this SBS premium?  Because installing a Standard Version of SQL 2000 on your SBS is not the same... for one, the licensing is different, but it is also not optimized for SBS.


I uninstalled SQL because I did not want addtitional resources being used if they did not need to be.  SBS Premium (my version) I don't think comes with that installed does it?

What is the name of the Companyweb instance?  It is just Companyweb?  I have never seen that instance in any of my installations of SQL. When I install SQL 2000 standard I get the option to attach the installation to either Shaprepointservices of sbsmonitoring.

I never Uninstalled MSDE but I think that since the SQL 2000 has been installed, both the SQLAgent$SBSMONITORING and SQLAgent$SHAREPOINT services are stopped and the MSSQL$SBSMONITORING and MSSQL$SHAREPOINT are running instead.  I'm assuming that the more advanced SQL has now taken over the desktop agent that came with SBS.

QUOTE: Company web was setup to use MSDE by installing SQL you probably uninstall the instance for Company web.

Companyweb worked fine after installing SQL 2005.  Then stopped after uninstalling sql 2005.  After I installed SQL 2000, it started working again.  Now I have uninstalled SQL 2000 and reinstalled, but now it is not working.

If I got to the Enterprise manager, there are no servers in the SQL server group, which I find odd. I try to add an SQL server, but for some reason when i go to add it I get the message:  SERVER - SQL server does not exist or access denied. ConnectionOpen (Connect()

Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
Jeffrey Kane - TechSoEasy

SBS Premium comes with SQL Server, and you are right it is not part of the integrated installation.  You can install it or uninstall it as you like.  I was just making sure you weren't using a version that wasn't on the SBS Premium Technologies CD, since those are just slightly different.

The companyweb instance would be MSSQL$SHAREPOINT.  You can upgrade that instance, but you cannot upgrade MSSQL$SBSMONITORING.  Full SQL server doesn't just TAKE OVER an MSDE instance.  It needs to be upgraded to that manually.

Just because you don't have any SQL servers registered in Enterprise manager doesn't mean they aren't SQL.  But the best way to tell is to look at ADD Remove Programs and see what's listed there.  SQL needs to be installed multiple times for multiple instances.  It will list what instance is installed.


Actually, I did use a version that was not on the small business server CD.  But it did work at one time.  Add remove programs says that SQL server 2000 is installed for both sharepoint and sbsmonitoring.

So I should uninstall SQL 2000 on the SBSMonitoring and let that run on MSDE?
Jeffrey Kane - TechSoEasy

You can't just uninstall SQL and expect it to revert to MSDE.  Since SBSMONITORING is not supported on full SQL I wouldn't be surprised if the DB is now corrupt.

Have you installed SBS SP1 yet?  (meaning all 5 parts as outlined in http://sbsurl.com/sp1 )

Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.

Yes, I have installed the Service Pack.

Also, what else runs on the SBSmonitoring database?  Everything else seems to be working fine on the server...
Jeffrey Kane - TechSoEasy

nothing, only SBS Monitoring.  You will have to reinstall it from the SBS Integrated Installation.  Add/Remove Programs > Windows Small Business Server 2003.  

I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck

Just to confirm, becasue the wording was a little wierd, the only thing that tthe SBSmonitoring instance does is run Companyweb.  Correct?

Strange be cause on my machine it's a little over 3GB.  Did not think it would take that much to run it.
Jeffrey Kane - TechSoEasy

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question