RE: SBS 2003 Unable to connect to database STS_Config
- From: v-chacez@xxxxxxxxxxxxx (chace zhang)
- Date: Thu, 17 Aug 2006 02:07:11 GMT
Hi,
Thank you for your update.
I'm glad to hear that things are working correctly for you now.
I really appreciate your time on this issue, and thanks for you sharing the
knowledge. Please do not hesitate to post in this newsgroup if you need any
assistance in the future. I look forward to working with you again.
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: AcbBNoq8OOzd8WbjRfadHszbJVaSaQ==
| 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>
<6E6FF4B8-9433-4069-9848-5D3ADA9238FD@xxxxxxxxxxxxx>
<VyRcB2RwGHA.2004@xxxxxxxxxxxxxxxxxxxxx>
| Subject: RE: SBS 2003 Unable to connect to database STS_Config
| Date: Wed, 16 Aug 2006 06:19:02 -0700
| Lines: 160
| Message-ID: <C492377B-B879-4261-863C-493A151D8208@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:290343
| NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
| X-Tomcat-NG: microsoft.public.windows.server.sbs
|
| 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.
| > |
| > |
| > |
| >
| >
|
.
- References:
- SBS 2003 Unable to connect to database STS_Config
- From: CCRick
- RE: SBS 2003 Unable to connect to database STS_Config
- From: chace zhang
- RE: SBS 2003 Unable to connect to database STS_Config
- From: Dredge
- RE: SBS 2003 Unable to connect to database STS_Config
- From: chace zhang
- RE: SBS 2003 Unable to connect to database STS_Config
- From: Dredge
- SBS 2003 Unable to connect to database STS_Config
- Prev by Date: Re: Catalog database error
- Next by Date: Grab fax console data to Excel?
- Previous by thread: RE: SBS 2003 Unable to connect to database STS_Config
- Next by thread: RE: SBS 2003 Unable to connect to database STS_Config
- Index(es):
Relevant Pages
|
