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?
colin911Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Murat RaymondCIOCommented:
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.

Vico1
Jeffrey Kane - TechSoEasyPrincipal ConsultantCommented:
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.

Jeff
TechSoEasy
colin911Author Commented:
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()




Fundamentals of JavaScript

Learn the fundamentals of the popular programming language JavaScript so that you can explore the realm of web development.

Jeffrey Kane - TechSoEasyPrincipal ConsultantCommented:
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.

Jeff
TechSoEasy
colin911Author Commented:
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 - TechSoEasyPrincipal ConsultantCommented:
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 )

Jeff
TechSoEasy
colin911Author Commented:
Yes, I have installed the Service Pack.
colin911Author Commented:
Also, what else runs on the SBSmonitoring database?  Everything else seems to be working fine on the server...
Jeffrey Kane - TechSoEasyPrincipal ConsultantCommented:
nothing, only SBS Monitoring.  You will have to reinstall it from the SBS Integrated Installation.  Add/Remove Programs > Windows Small Business Server 2003.  

Jeff
TechSoEasy
colin911Author Commented:
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 - TechSoEasyPrincipal ConsultantCommented:
No, SBSMonitoring is your server's Monitoring and Reporting functionality.  The Companyweb is handled by the MSSQL$SHAREPOINT instance.

If it's 3GB, then perhaps the SQLAgent$SBSMonitoring  isn't running?  It should be set to Automatic and started.  This will keep the database maintained correctly.

Jeff
TechSoEasy

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SBS

From novice to tech pro — start learning today.