RE: Sharepoint issue

Hi Jalyo,

Thank you for posting in SBS newsgroup.

From your description, I understand you received error message "Cannot
connect to the configuration database" when you access Companyweb. If I
have misunderstood your concerns, please do not hesitate to let me know.

To narrow down the problem, would you please help me confirm you are using
SBS Standard or Premium? If you are using Standard edition, there should
not have SQL been installed. In addition, do you mean Microsoft SQL Server
and Enterprise Manager do not exist in All Programs?

Currently, I want to provide some general steps to troubleshooting the
issue as following, you may try to see if it helps.

1. Please double-check the default application pool in IIS. To do so:

1) Open IIS Manager.
2) Go to Server/Application Pools/DefaultAppPool.
3) Right click DefaultAppPool and click Properties.
4) Click the Identity tab.
5) Make sure the application pool is using "Predefined: Network Service" as
its identity.
6) Run IISReset command and check whether the problem persists.

2. Please check the SharePoint Timer Service. To do so:

1) Open Services in Administrative Tools.
2) Double click SharePoint Timer Service in the right pane.
3) Click Log On tab.
4) Make sure that the service is using "This account: NT AUTHORITY\NETWORK
SERVICE" to log on.
5) Click OK to save the changes.
6) Run IISReset command and check whether the problem persists.

3. Please follow the steps below to check oledb32.dll file permission.

1) Go to C:\Program Files\Common Files\System\Ole DB folder.
2) Right click oledb32.dll and click Properties.
3) Click Security tab. Then click Advanced button.
4) Make sure that the "Allow inheritable permissions from the parent to
propagate to this object and all child objects. Include these with entries
explicitly defined here" box has not been checked.
5) Make sure the permission is as follows:

SYSTEM - Full Control.
Administrators - Full Control.
Users - Read/Read & Execute

6) Run IISReset command and check whether the problem persists.

If the problem still persists, please help me collect the following
information:

1. Does the situation occur on all internal client computers? Is OWA or RWW
working? Can you access companyweb using
http://companyweb/default.aspx?
2. Restart the MSSQL$SHAREPOINT service, does this help?
3. Does the situation occur when you access companyweb from external client?
4. On the SBS server, click Start, click Run, type "cmd" and click OK. Type
"osql -E -S <sbsserver>\SHAREPOINT" and press ENTER, do you receive any
error message?
5. Does the Companyweb work before? What changes you have done recently?

More information related to the issue:

833183 You receive a "Cannot connect to the configuration database" error
http://support.microsoft.com/?id=833183

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

I appreciate your time and efforts to perform test and collect information.

I am happy to provide further assistance and looking forward to your reply!

Best regards,

Crina Li (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: Sharepoint issue
|| From: =?Utf-8?B?amFseW8=?= <jalyo@xxxxxxxxxxxxxxxxxxxxxxxxx>
| Subject: Sharepoint issue
| Date: Fri, 12 May 2006 19:40:02 -0700
| | Newsgroups: microsoft.public.windows.server.sbs
| |
| I get the following message when trying to access http://companyweb
|
| Cannot 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.
|
| I went to the article and the first two issues do not seem to be a
problem
| however on the third one I am having some difficulty with teh following.
I
| do not have in Programs Microsoft SQL Server nor a Enterprise Manager in
a
| SQL Server. If anyone can help with this much appreciated.
|
| Next, you must verify that this account has the required permission the
SQL
| Server database. To do this, follow these steps: 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.
| 4. Double-click Security.
| 5. In the left pane, click Logins.
| 6. In the right pane, double-click the user who you noted step 8 of the
| previous procedure.
| 7. In the SQL Server Login Properties dialog box, click Server Roles.
| 8. Click to select both the Security Administrators and the Database
| Creators check boxes, and then click Database Access.
| 9. Under the Permit column, click to select the Windows SharePoint
Services
| database.
|
|
|

.