RE: SBS 2003 Unable to connect to database STS_Config

This did it!, there were a few idiosyncrasies that I overcame but all it up
and running and my databases are restored and functioning.

Thank You

"chace zhang" wrote:

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: SQL CE 3 and CF 1.0 support
    ... > We have designed our application so that all data access logic is ... > using our automated upgrade mechanism and at the same time upgrade the ... > from the engine download and the database upgrade delay). ... > I also know of applications that have been using SQL CE databases in RAM ...
    (microsoft.public.sqlserver.ce)
  • Re: How do i move an SQLDatabase to another location?
    ... I went to my clients and installed SQL Server ... Express and copied my database to the same location it was in while i was ... knowing that i can bring a database with me and install ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: New to Windows CE Development - Have some questions
    ... validating against the main database, or querying the database during data ... iterate through the SQL CE table and create new entries in the ... SQL Server database that correspond. ... >>> not connected to the Enterprise. ...
    (microsoft.public.windowsce.app.development)
  • RE: Logging in in background
    ... wold take all kinds of modifictions as I'd need to be checking that each SQL ... my database and all have connection strings associated with them. ... I suspect that there is also an issue on the SQL Server side as I keep ...
    (microsoft.public.access.modulesdaovba)
  • Re: Using Access 2007 to connect to SQL
    ... MDB database file format, ODBC linked tables, passthrough queries ... probably the easiest way of retrieving data from a SQL-Server ... I'm a total newbie w MS SQL Server. ...
    (microsoft.public.access.adp.sqlserver)