RE: SBS 2003 Unable to connect to database STS_Config

Hi,

Thanks for your update.

Based on my experience, on SBS server, there are already 2 instances using
MSDE to store SharePoint (Companyweb) uses the MSSQL$SharePoint database,
while the Monitoring features use the MSSQL$SBSMonitoring database to store
data. Both of these features are mutually exclusive for the most part.

If you are using SQL 2000, you could (and you should) upgrade the
SharePoint named instance to full SQL.
Note : You cannot upgrade the Monitoring instance to SQL
The steps are listed in the premiuminstallsteps.htm on the root of the
Premium CD. (I will send you this file in a separated email) 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

Currently please check whether MSSQLSERVER service is started. You can
remote SQL on your SBS and follow the steps above to upgrade to SQL


If the issue persists, please refer to following MS article to reinstall
SPS components

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



829112 How to back up and restore http://companyweb data in Windows Small
Business Server 2003
http://support.microsoft.com/?id=829112



827701 How to perform a disaster recovery operation of SharePoint Services
http://support.microsoft.com/?id=827701


After that do not upgrade to SQL immediately, Please Verify if the
companyweb is functional.

According to your situation, please perform a full bakup before you perform
these actions above.


Hope this helps, I look forward to your update.

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

When opening a new thread via the web interface, we recommend you check the
"Notify me of replies" box to receive e-mail notifications when there are
any updates in your thread. When responding to posts via your newsreader,
please "Reply to Group" so that others may learn and benefit from your
issue.

Microsoft engineers can only focus on one issue per thread. Although we
provide other information for your reference, we recommend you post
different incidents in different threads to keep the thread clean. In doing
so, it will ensure your issues are resolved in a timely manner.

For urgent issues, you may want to contact Microsoft CSS directly. Please
check http://support.microsoft.com for regional support phone numbers.

Any input or comments in this thread are highly appreciated.

=====================================================

This posting is provided "AS IS" with no warranties, and confers no rights.


--------------------
| Thread-Topic: SBS 2003 Unable to connect to database STS_Config
| thread-index: AcbA9buRr+CC9YW2SWGYStMe7xaz0w==
| X-WBNR-Posting-Host: 70.251.234.130
| From: =?Utf-8?B?RHJlZGdl?= <Dredge@xxxxxxxxxxxxxxxxxxxxxxxxx>
| References: <1155214460.484383.63200@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>
<kC68#9QvGHA.1992@xxxxxxxxxxxxxxxxxxxxx>
<1C3FBCE5-E330-4704-BBF3-33B2F5432B22@xxxxxxxxxxxxx>
| Subject: RE: SBS 2003 Unable to connect to database STS_Config
| Date: Tue, 15 Aug 2006 22:35:07 -0700
| Lines: 17
| Message-ID: <6E6FF4B8-9433-4069-9848-5D3ADA9238FD@xxxxxxxxxxxxx>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
| Newsgroups: microsoft.public.windows.server.sbs
| Path: TK2MSFTNGXA01.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.windows.server.sbs:290224
| NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
| X-Tomcat-NG: microsoft.public.windows.server.sbs
|
| Chace,
|
| I must be missing something, I got as far as re-installing SQL std and
| upgraded the instance of sharepoint, I did not upgrade sbs monitoring.
In
| services I see 2 services (mssql$sharepoint and mssql$sbsmonitoring) both
are
| started. I have installed SQL SP-4, but the system tray icon shows "not
| connected" , there are no errors in the event logs. I open enterprise
| manager to restore the 2 databases I backed up and I do not have the
ability
| to restore them. What I see is the SQL server group and (LOCAL) under
it, if
| I click on it, I get "The SQL Server \\(LOCAL) is not known to be
running.
| Are you sure you wish to connect?, if I click Yes, I get "A connection
could
| not be established to(LOCAL). Reason: SQL server does not exist or
access
| denied. ConnectionOpen (Connect()).. Please verify SQL server is
running
| and check your SQL server registration properties (by right clicking on
the
| (LOCAL) node) and try again.
|
|
|

.

Relevant Pages

  • RE: Problems upgrading SQL MSDE for Sharepoint
    ... I am glad to know the upgrade Sharepoint ... Microsoft CSS Online Newsgroup Support ... With this working I was able to start upgrading SQL MSDE for SharePoint. ... >white paper to backup your SBS server first. ...
    (microsoft.public.windows.server.sbs)
  • Re: Redundancy design in SBS Domain
    ... But virtualization was not on my radar, and Exchange and SQL need more with each iteration. ... I originally went the SBS route because it was by far the cheapest was to get a server up and running with SQL Server at the time. ...
    (microsoft.public.windows.server.sbs)
  • Re: Repost SBS 2003, Sharepoint, remote SQL
    ... While WSS itself should/does support SQL running on another server.. ... SBS v4.x: microsoft.public.backoffice.smallbiz SBS 2000: microsoft.public.backoffice.smallbiz2000 SBS 2003: microsoft.public.windows.server.sbs "Rich" wrote in message ... If anybody has any more information on> installing Sharepoint on a remote SQL server,> other than the link provided, please advise. ...
    (microsoft.public.windows.server.sbs)
  • Re: SBS 2003 Std - SQL Eval expired...will un-installing break SBS fun
    ... I agree with Claus that you're able to remove SQL 2005 instances if you did ... you can get SBS R2 which already contains SQL Server 2005 ... Workgroup Edition, and upgrade Sharepoint instance, and install other ...
    (microsoft.public.windows.server.sbs)
  • RE: Sharepoint and SBS2003 SP1
    ... If your companyweb can work well, this would be a known issue in SBS server ... To resolve the issue, please refer to the following knowledge based ... their SharePoint site could fail. ...
    (microsoft.public.windows.server.sbs)
Loading