RE: Sharpoint Error in SBS 2003

Hi Rerry,

Thanks for your update!

>>1. When I ran osql -e -s dellserver\sharepoint I came to a command
window with 1> on it is that correct?

Yes, the result is correct. That indicates you can connect to sharepoint
database.

>>2. I did a search on oledb32.dll and the results are:
>> C:\windows\$ntservicepack\uninstall version2.8.1022.0
>>C:\windows\servicepackfiles\i386\ version 2.82.1830.0
>>C:\program files\common files\system\oledb version 2.82.1830.0

The oledb32.dll version is also correct.

Please try to restart the server, do you get any error info?

For your information, I know you also have monitoring and reporting issue
and ODBC issue. To sort out the root cause I suggest that we try to resolve
sharepoint issue first. Please follow the steps in KB Article 829113 and
remove the Sharepoint Services from CompanyWeb and re-extended them.

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

*Note: Before we begin to troubleshooting the issue, I would like to
suggest you refer to the SBS 2003 backup/restore document to backup server.
For more information regarding the data recovery. you may visit the
document at:
http://www.microsoft.com/downloads/details.aspx?FamilyID=487736f8-f6f5-436d-
a82d-0c8d66e2a634&displaylang=en

Try to test, how about the result? Can you access companyweb again?

If the issue persists, please help me collect some information to further
troubleshooting the issue:

1. Follow the steps below to export IIS metabase and send the files to me:

A. Extract attached MBExplorer.zip and run MBExplorer.msi.
B. Run MBExplorer.exe.
C. Right-click LM and click Export to file.
D. Type a name such as "lm" and click OK.

2. The files in the "C:\Program Files\Microsoft SQL
Server\MSSQL$SHAREPOINT\LOG" folder.
The files in the "C:\Program Files\Microsoft SQL
Server\MSSQL$Monitoring\LOG" folder.

3. Follow the steps below to get error event log:

A. Open Event Viewer: Start -> All Programs -> Administrative Tools ->
Event Viewer.
B. Right-click on System/Application log and select "Save Log File As?".

Please add all files to a zip file and send to v-yanniw@xxxxxxxxxxxxxx

I appreciate your time and effort to perform test. I am looking forward to
your reply!

Have a nice day!

Best Regards,

Jenny Wu
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: Sharpoint Error in SBS 2003
>thread-index: AcWnSnlYa0wzgf5TQ8mQIkxo1xyLDw==
>X-WBNR-Posting-Host: 216.193.185.20
>From: =?Utf-8?B?VGVycnkxMzM3?= <Terry1337@xxxxxxxxxxxxxxxxxxxxxxxxx>
>References: <A09218AA-A4FB-49C4-AE5A-8C35EB9C063B@xxxxxxxxxxxxx>
<QwOimsupFHA.940@xxxxxxxxxxxxxxxxxxxxx>
>Subject: RE: Sharpoint Error in SBS 2003
>Date: Mon, 22 Aug 2005 11:51:15 -0700
>Lines: 260
>Message-ID: <984C6F8B-D0E5-4A26-83F8-2CBEE4FBDC1B@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.0
>Newsgroups: microsoft.public.windows.server.sbs
>NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA03.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.windows.server.sbs:146719
>X-Tomcat-NG: microsoft.public.windows.server.sbs
>
>Hi Jenny,
>
>I sent you an email and am hoping you recieved the information and can
>evaluate my results. Any questions please let me know.
>
>Thanks,
>Terry
>
>""Jenny wu [MSFT]"" wrote:
>
>> Hi Rerry,
>>
>> Thank you for posting here!
>>
>> I am sorry for the delayed response due to weekend. Please understand
that
>> the newsgroups are staffed weekdays by Microsoft Support professionals
to
>> answer your systems and applications questions. Your understanding is
>> greatly appreciated!
>>
>> For your description, I understand that the issue is: when you access
>> Companyweb you got the error " Cannot connect to the configuration
database
>> " and the 1000 error event is logged in Application log. If I am off
base,
>> please don't hesitate to let me know.
>>
>> Suggestion 1:
>> Based on my research, this behavior occurs if one of the following
>> conditions is true:
>> **The SQL database is not running.
>> -or-
>> ** Internet Information Services (IIS) is configured to run in IIS 5.0
>> isolation mode.
>> -or-
>> **The account that is used by application pool does not have the
required
>> permissions to the SQL Server database.
>>
>> Please refer to the following KB article to try to resolve the problem:
>> You receive a "Cannot connect to the configuration database" error
message
>> when you connect to your Windows SharePoint Services Web site
>> http://support.microsoft.com/?id=823287
>>
>> Have you upgraded the Sharepoint WMSDE to SQL server? And how you
register
>> the SharePoint instance in SQL Enterprise Manager?
>>
>> You can use the following steps to register the SharePoint instance in
SQL
>> Enterprise Manager:
>>
>> A. Click Start, point to All Programs\Microsoft SQL Server, and then
click
>> Client Network Utility. Make sure "Enable shared memory protocol" is
>> selected.
>>
>> B. Open Enterprise Manager, right-click a server or a server group, and
>> then click New SQL Server Registration. Click Next.
>>
>> NOTE: If you selected the From now on I want to perform this task
without
>> using a wizard check box the last time you used the Register Server
Wizard,
>> SQL Server Enterprise Manager displays the Registered SQL Server
Properties
>> dialog box. Otherwise, the Register Server Wizard is started.
>>
>> C. In the Server box, type the instance name, ie,
<sbsserver>\SHAREPOINT,
>> and click Add and then Next.
>>
>> D. Click "The Windows account information I use to log on to my computer
>> (Windows Authentication)", and then click Next.
>>
>> E. In the Server Group list, click a server group and click Next.
>>
>> NOTE: If the group you need does not exist yet, create it by clicking
the
>> build (...) button, and then completing the Server Groups dialog box.
>>
>> F. Click Finish, and then Close.
>>
>> Try to test, how about the result?
>>
>> Suggestion 2:
>>
>> This issue may occur when the SharePoint Timer Service tries to contact
the
>> configuration database when the computer starts or shuts down.
>>
>> If you can connect to Companyweb successfully, you can safely ignore
this
>> error message. Or you can follow the steps in 840685 to work around this
>> issue:
>>
>> 840685 An event ID 1000 error message is logged to the application event
log
>>
>> http://support.microsoft.com/?id=840685
>>
>> Try to test, how about the result?
>>
>> Suggestion 3:
>>
>> This problem can occur if a handle to a registry key is not closed
>> correctly. This "locks" the registry files so when Windows attempts to
copy
>> these files as part of the roaming profile synchronization process it
fails
>> (and this event is recorded). Several users have reported this problem
as
>> occuring after the installation of various software packages. In most
>> cases, this indicates a bug in those applications.
>>
>> One of the first steps to take in troubleshooting this problem is to
>> install the latest service pack.
>>
>> RESOLUTION:
>>
>> A supported hotfix is now available from Microsoft, but it is only
intended
>> to correct the problem that is described in this article. Only apply it
to
>> systems that are experiencing this specific problem. This hotfix may
>> receive additional testing. Therefore, if you are not severely affected
by
>> this problem, we recommend that you wait for the next Windows Server
2003
>> service pack that contains this hotfix.
>>
>> To resolve this problem immediately, contact Microsoft Product Support
>> Services to obtain the hotfix. For a complete list of Microsoft Product
>> Support Services phone numbers and information about support costs,
visit
>> the following Microsoft Web site:
>>
>> http://support.microsoft.com/default.aspx?scid=fh;[LN];CNTACTMS
>> (http://support.microsoft.com/default.aspx?scid=fh;%5Bln%5D;cntactms)
>>
>> Note: In special cases, charges that are ordinarily incurred for support
>> calls may be canceled if a Microsoft Support Professional determines
that a
>> specific update will resolve your problem. The usual support costs will
>> apply to additional support questions and issues that do not qualify for
>> the specific update in question.
>>
>> You can refer to the following KB article to get detail info:
>>
>> 883521 Changes to your roaming user profile are not saved when you log
off
>> and
>>
>> http://support.microsoft.com/?id=883521
>>
>> Try to test, how about the result?
>>
>> Suggestion 4:
>>
>> Antivirus programs like Norton or McAfee were causing this error. Most
of
>> the users solved the problem by installing the latest patches or
software
>> version for the particular program.
>>
>> Another software that seemed to cause problems to many users is
TightVNC.
>> Replacing it with standard VNC fixed this issue.
>>
>> You can refer to the following KB article:
>>
>> This one applies to Anti-virus effects:
>>
>> 312031 Using the Symantec W32.Nimda.A@mm Virus Removal Tool Affects the
>> Sysvol
>>
>> http://support.microsoft.com/?id=312031
>>
>> Try to test, how about the result?
>>
>> Please try the steps above one by one and let me know the results.
>>
>> If the issue persist, please help me collect some information to further
>> troubleshooting the issue:
>>
>> 1. When the issue occurs, is the service MSSQL$SHAREPOINT running? Can
you
>> connect to the SHAREPOINT instance by running "osql -E -S
>> <sbsserver>\SHAREPOINT"?
>>
>> 2. What's the version of Oledb32.dll file when the issue occurs? For
>> Windows Server 2003, the version must be 2.8.1022.0 or a later version.
>>
>> 3. Please paste all the accurate errors information in the newsgroup.
>>
>> 4. When you run "Monitoring and reporting", what is error message you
got?
>> Can you give me a screen shot of the error message?
>>
>> 5. Can you give me a screen shot of the error message when you access
>> companyweb?
>>
>> 6. What has done two weeks ago? Has the server suffered any problems or
>> install any applications?
>>
>> Please add all files to a zip file and send to v-yanniw@xxxxxxxxxxxxxx
>>
>> For your reference:
>>
>> This one applies to improper permissions to the
%SystemRoot%\Winnt\Sysvol
>> folder:
>> 290647 Event ID 1000, 1001 Is Logged Every Five Minutes in the
Application
>> http://support.microsoft.com/?id=290647
>>
>> This one applies to incorrect time on the client:
>> 285923 Error Messages Every 5 Minutes Report Events 1000, 1001, and
13508,
>> http://support.microsoft.com/?id=285923
>>
>> I appreciate you time and effort to perform test. I am currently
standing
>> by for you about the test result. I am always happy to be of further
>> assistance.
>>
>> Have a nice day!
>>
>> Best Regards,
>>
>> Jenny Wu
>> 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: Sharpoint Error in SBS 2003
>> >thread-index: AcWkvSGufuZQ3yH5SxuyejhvJIFPKg==
>> >X-WBNR-Posting-Host: 216.193.185.20
>> >From: =?Utf-8?B?VGVycnkxMzM3?= <Terry1337@xxxxxxxxxxxxxxxxxxxxxxxxx>
>> >Subject: Sharpoint Error in SBS 2003
>> >Date: Fri, 19 Aug 2005 05:54:27 -0700
>> >Lines: 8
>> >Message-ID: <A09218AA-A4FB-49C4-AE5A-8C35EB9C063B@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.0
>> >Newsgroups: microsoft.public.windows.server.sbs
>> >NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
>> >Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGXA03.phx.gbl
>> >Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.windows.server.sbs:145892
>> >X-Tomcat-NG: microsoft.public.windows.server.sbs
>> >
>> >I am running sharepoint services on Small Business Server 2003 standard
>> >edition. Had a crash 2 weeks ago and am getting the error: Cannot
connect
>> to
>> >the configuration database. In the application event viewer I get lots
on
>> >1000 errors. I can access the virtual server saettings but do not have
the
>> >default company web site. I also cannot get the monitoring and reports
to
>> >run. Any suggestions are greatly appreciated!
>> >
>> >Terry
>> >
>>
>>
>

.

Loading