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?
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?
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
Jeff
TechSoEasy
ASKER
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()
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()
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
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
ASKER
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?
So I should uninstall SQL 2000 on the SBSMonitoring and let that run on MSDE?
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
Have you installed SBS SP1 yet? (meaning all 5 parts as outlined in http://sbsurl.com/sp1 )
Jeff
TechSoEasy
ASKER
Yes, I have installed the Service Pack.
ASKER
Also, what else runs on the SBSmonitoring database? Everything else seems to be working fine on the server...
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
Jeff
TechSoEasy
ASKER
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.
Strange be cause on my machine it's a little over 3GB. Did not think it would take that much to run it.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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