RE: SBS 2003 Unable to connect to database STS_Config

should sbsmonitoring ever be upgraded to SQL std?

"Dredge" wrote:

Please read notes below, I stopped before upgrading SQL;


To do so

Step One: Uninstall the SQL server
===============================

Uninstall the SQL server from the SBS 2k3 server from add/remove programs

Step two: reinstall sharepoint
=============================

I. Uninstall Intranet

1. Click Start, click Control Panel, and then click Add or Remove
Programs.
2. Select Windows Small Business Server 2003 and then click
Change/Remove. The Setup Wizard appears.
3. Click Next to start the wizard.
4. On the Windows Configuration page, click Next.
5. On the Component Selection page, in the Action column, change
Server Tools to Maintenance, change Intranet component to Remove, and then
click Next.


Intranet shows Shows not installed




6. On the Component Summary page, click Next.
7. Click Finish.


II. Uninstall Microsoft SQL Server Desktop Engine (SHAREPOINT)

In Add or Remove Programs, select Microsoft SQL Server Desktop Engine
(SHAREPOINT) and then click Remove. A dialog box appears. To confirm that
you want to remove, click Yes.



Sharepoint Not listed, only SBSMonitoring




III. Delete Registry Keys

1. Delete
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SmallBusinessServer\Intranet
2. Delete HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\SHAREPOINT
3. Delete HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web
Server Extensions\Ports\Port /LM/W3SVC/4: (Do not delete "Port
/LM/W3SVC/1:" because it is FronPage Server Extension 2002 which is
installed on the Default WebSite. If you see additional "Port
/LM/W3SVC/X:", backup and then remove them)


IV. Delete IIS Virtual Directory

1. Delete SharePoint Central Administration (Do Not Delete Microsoft
SharePoint Administration. It belongs to FronPage Server Extension)
2. Delete Companyweb


7 instances of companyweb listed all but one are stopped





Note: If AV software install any extra IIS virtual directory, also remove
them if possible. They sometimes use port 8081 which will conflict with our
SharePoint Central Administration virtual directory.


V. Delete Application Pool

There should be only 4 application pools (DefaultAppPool,
ExchangeApplicationPool, ExchangeMobileBrowseApplicationPool, and
MSSharePointAppPool). Besides those 4, delete all the extra.

VI. Rename Folders

1. Rename C:\Program Files\Microsoft SQL Server\MSSQL$SHAREPOINT
2. Rename C:\Inetpub\companyweb


VII. Install the intranet component
1. In Add or Remove Programs, select Windows Small Business Server
2003 and then click Change/Remove. The Setup Wizard appears.
2. Click Next.
3. On the Windows Configuration page, click Next.
4. On the Component Selection page, in the Action column, change
Server Tools to Maintenance, change Intranet and Monitoring components to
Install, and then click Next.
5. On the Logon Information page, click Next.
6. On the Component Summary page, click Next.
7. Click Finish.


VIII. The Installation should still fail, then apply the patch located
at:
http://www.microsoft.com/downloads/details.aspx?FamilyId=CB7E90A1-DE9D-4A83-
85F8-951E9F055BF0&displaylang=en



Failed here as you said it would, installed patch then reran the SBS server
setup and ran to completion successfully






Setup Three: Upgrade the MSDE instance to SQL
=============================================

The steps upgrading the SharePoint named instance to full SQL are listed in

the premiuminstallsteps.htm on the root of the Premium CD. After SQL
installation, you should only have the following 2 items in ''Add/Remove
Programs'':

? Microsoft SQL Server 2000 (SHAREPOINT)

Sharepoint NOT LISTED


? Microsoft SQL Server Desktop Engine (SBSMONITORING)




"chace zhang" wrote:

Hi,

Thank you for posting here.

According to your description, I understand you encountered following error
in application log:
#50070: Unable to connect to the database STS_Config on USM\SharePoint.
Check the database connection information and make sure that the database
server is running.

Also you could not use sharepoint (http://companyweb)
I do understand you are in a production environment, but based on my
research, you need do the following action to resolve this issue:

1. Uninstall SQL Server;

2. Reinstall Monitoring and Sharepoint and make sure they work;

3. Install SQL and upgrade the Sharepoint and Monitoring MSDE instances to
SQL Server instances.

To do so

Step One: Uninstall the SQL server
===============================

Uninstall the SQL server from the SBS 2k3 server from add/remove programs

Step two: reinstall sharepoint
=============================

I. Uninstall Intranet

1. Click Start, click Control Panel, and then click Add or Remove
Programs.
2. Select Windows Small Business Server 2003 and then click
Change/Remove. The Setup Wizard appears.
3. Click Next to start the wizard.
4. On the Windows Configuration page, click Next.
5. On the Component Selection page, in the Action column, change
Server Tools to Maintenance, change Intranet component to Remove, and then
click Next.
6. On the Component Summary page, click Next.
7. Click Finish.


II. Uninstall Microsoft SQL Server Desktop Engine (SHAREPOINT)

In Add or Remove Programs, select Microsoft SQL Server Desktop Engine
(SHAREPOINT) and then click Remove. A dialog box appears. To confirm that
you want to remove, click Yes.


III. Delete Registry Keys

1. Delete
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SmallBusinessServer\Intranet
2. Delete HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\SHAREPOINT
3. Delete HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web
Server Extensions\Ports\Port /LM/W3SVC/4: (Do not delete "Port
/LM/W3SVC/1:" because it is FronPage Server Extension 2002 which is
installed on the Default WebSite. If you see additional "Port
/LM/W3SVC/X:", backup and then remove them)


IV. Delete IIS Virtual Directory

1. Delete SharePoint Central Administration (Do Not Delete Microsoft
SharePoint Administration. It belongs to FronPage Server Extension)
2. Delete Companyweb

Note: If AV software install any extra IIS virtual directory, also remove
them if possible. They sometimes use port 8081 which will conflict with our
SharePoint Central Administration virtual directory.


V. Delete Application Pool

There should be only 4 application pools (DefaultAppPool,
ExchangeApplicationPool, ExchangeMobileBrowseApplicationPool, and
MSSharePointAppPool). Besides those 4, delete all the extra.

VI. Rename Folders

1. Rename C:\Program Files\Microsoft SQL Server\MSSQL$SHAREPOINT
2. Rename C:\Inetpub\companyweb


VII. Install the intranet component
1. In Add or Remove Programs, select Windows Small Business Server
2003 and then click Change/Remove. The Setup Wizard appears.
2. Click Next.
3. On the Windows Configuration page, click Next.
4. On the Component Selection page, in the Action column, change
Server Tools to Maintenance, change Intranet and Monitoring components to
Install, and then click Next.
5. On the Logon Information page, click Next.
6. On the Component Summary page, click Next.
7. Click Finish.


VIII. The Installation should still fail, then apply the patch located
at:
http://www.microsoft.com/downloads/details.aspx?FamilyId=CB7E90A1-DE9D-4A83-
85F8-951E9F055BF0&displaylang=en


Setup Three: Upgrade the MSDE instance to SQL
=============================================

The steps upgrading the SharePoint named instance to full SQL are listed in
the premiuminstallsteps.htm on the root of the Premium CD. After SQL
installation, you should only have the following 2 items in ''Add/Remove
Programs'':

? Microsoft SQL Server 2000 (SHAREPOINT)
? Microsoft SQL Server Desktop Engine (SBSMONITORING)

In addition, you can also find the steps on how to upgrade to SQL server in
the following KB article

How to turn on full-text search in Windows SharePoint Services on a Windows
Small Business Server 2003-based computer
http://support.microsoft.com/default.aspx?scid=kb;en-us;837367

After performing the steps in above article, your WSS content database
management is upgraded from MSDE to SQL and you will also have full-text
search function.

For more information, I would also like to give you the following article.

829113 How to restore a Windows SharePoint Services CompanyWeb database
after the intranet component and SQL Server or MSDE 2000 have been removed
on Windows Small Business Server
http://support.microsoft.com/?id=829113

829114 How to remove and how to install the Windows Small Business Server
2003 SharePoint Services Companyweb Web site
http://support.microsoft.com/?id=829114

If you have any further questions or concerns, please feel free to let us
know. Thanks for your time and we look forward to hearing from you.

Have a nice day!

Best Regards,

Chace Zhang (MSFT)

Microsoft CSS Online Newsgroup Support

Get Secure! - www.microsoft.com/security

=====================================================
This newsgroup only focuses on SBS technical issues. If you have issues
regarding other Microsoft products, you'd better post in the corresponding
newsgroups so that they can be resolved in an efficient and timely manner.
You can locate the newsgroup here:
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx
.

Relevant Pages

  • RE: SharePoint and Company Web not working
    ... How did you install the SharePoint 3.0, side by side install or In-place ... If you made in-place upgrade for companyweb, you must uninstall SharePoint ... Select Windows Small Business Server 2003, ...
    (microsoft.public.windows.server.sbs)
  • Re: Sharepoint for Windows Server 2000?
    ... Sharepoint Team Services 2001 can be found on either the Frontpage ... If you install it to a server that already has SQL server it will ...
    (microsoft.public.sharepoint.teamservices)
  • RE: SBS2K3 Share Point Services re-install?
    ... Welcome to SBS newsgroup. ... I am not sure how you reinstall the sharepoint services on SBS 2003, ... 829114 How to remove and how to install the Windows Small Business Server ...
    (microsoft.public.windows.server.sbs)
  • RE: Reinstall Internal Web
    ... It did not fix the sharepoint but the ... This is a clean install of ClientX. ... > http://companyweb in Windows Small Business Server 2003 ... Rename Program Files\Microsoft Integration\Windows Small Business Server ...
    (microsoft.public.windows.server.sbs)
  • RE: SBS 2003 SP1 Upgrade - MSDE 2000 Service Pack 4 did not instal
    ... The DSRestore Filter failed to connect to local SAM server. ... registry keys of the Microsoft SQL server and mail to me for analyze. ... This newsgroup only focuses on SBS technical issues. ... SBS 2003 SP1 Upgrade - MSDE 2000 Service Pack 4 did not install ...
    (microsoft.public.windows.server.sbs)