Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

SharePoint Sql Server Error

Posted on 2010-11-22
4
Medium Priority
?
845 Views
Last Modified: 2012-06-21
I am getting error with SharePoint WSS connection to Database as shown below.I have tried using different user and verified that the user id and password are right and have access to the WSS Database  but still this problem persists. Any ideas would be appreciated


 

2010-11-21 15:46:45.17 spid15s     Starting up database 'ProjectServer'.
2010-11-21 15:46:45.17 spid12s     Starting up database 'msdb'.
2010-11-21 15:46:45.17 spid16s     Starting up database 'Analysis Services Repository'.
2010-11-21 15:46:45.17 spid18s     Starting up database 'WSS_Content'.
2010-11-21 15:46:45.17 spid17s     Starting up database 'WSS_Search_SSS-TP-W-1'.
2010-11-21 15:46:45.17 spid14s     Starting up database 'SharePoint_AdminContent_e9e4ad22-157d-4ba1-b218-8a5401d0cf08'.
2010-11-21 15:46:45.17 spid19s     Starting up database 'WSS_Content_de197ff40ced42dd8e3cb0fd51815d14'.
2010-11-21 15:46:45.17 spid13s     Starting up database 'SharePoint_Config'.
2010-11-21 15:46:45.17 spid20s     Starting up database 'SharedServices1_DB'.
2010-11-21 15:46:45.17 spid21s     Starting up database 'ProjectServer_Published'.
2010-11-21 15:46:45.17 spid22s     Starting up database 'ProjectServer_Draft'.
2010-11-21 15:46:45.17 spid23s     Starting up database 'ProjectServer_Archive'.
2010-11-21 15:46:45.17 spid24s     Starting up database 'ProjectServer_Reporting'.
2010-11-21 15:46:45.17 spid25s     Starting up database 'NW2007DB'.
2010-11-21 15:46:45.67 spid9s      CHECKDB for database 'model' finished without errors on 2010-11-21 00:00:10.297 (local time). This is an informational message only; no user action is required.
2010-11-21 15:46:45.72 spid9s      Clearing tempdb database.
2010-11-21 15:46:45.75 spid16s     CHECKDB for database 'Analysis Services Repository' finished without errors on 2010-11-21 00:00:22.060 (local time). This is an informational message only; no user action is required.
2010-11-21 15:46:45.85 spid22s     CHECKDB for database 'ProjectServer_Draft' finished without errors on 2010-11-21 01:41:24.420 (local time). This is an informational message only; no user action is required.
2010-11-21 15:46:45.89 spid19s     Recovery is writing a checkpoint in database 'WSS_Content_de197ff40ced42dd8e3cb0fd51815d14' (11). This is an informational message only. No user action is required.
2010-11-21 15:46:46.06 spid25s     CHECKDB for database 'NW2007DB' finished without errors on 2010-11-21 01:41:46.077 (local time). This is an informational message only; no user action is required.
2010-11-21 15:46:46.09 spid21s     CHECKDB for database 'ProjectServer_Published' finished without errors on 2010-11-21 01:41:09.110 (local time). This is an informational message only; no user action is required.
2010-11-21 15:46:46.17 spid23s     CHECKDB for database 'ProjectServer_Archive' finished without errors on 2010-11-21 01:41:35.480 (local time). This is an informational message only; no user action is required.
2010-11-21 15:46:46.17 spid15s     CHECKDB for database 'ProjectServer' finished without errors on 2010-11-21 00:00:21.370 (local time). This is an informational message only; no user action is required.
2010-11-21 15:46:46.32 spid19s     CHECKDB for database 'WSS_Content_de197ff40ced42dd8e3cb0fd51815d14' finished without errors on 2010-11-21 01:40:55.767 (local time). This is an informational message only; no user action is required.
2010-11-21 15:46:46.35 spid14s     CHECKDB for database 'SharePoint_AdminContent_e9e4ad22-157d-4ba1-b218-8a5401d0cf08' finished without errors on 2010-11-21 00:00:14.927 (local time). This is an informational message only; no user action is required.
2010-11-21 15:46:46.35 spid13s     2 transactions rolled forward in database 'SharePoint_Config' (5). This is an informational message only. No user action is required.
2010-11-21 15:46:46.36 spid13s     0 transactions rolled back in database 'SharePoint_Config' (5). This is an informational message only. No user action is required.
2010-11-21 15:46:46.36 spid13s     Recovery is writing a checkpoint in database 'SharePoint_Config' (5). This is an informational message only. No user action is required.
2010-11-21 15:46:46.50 spid13s     CHECKDB for database 'SharePoint_Config' finished without errors on 2010-11-21 00:00:13.053 (local time). This is an informational message only; no user action is required.
2010-11-21 15:46:46.56 spid24s     CHECKDB for database 'ProjectServer_Reporting' finished without errors on 2010-11-21 01:41:41.753 (local time). This is an informational message only; no user action is required.
2010-11-21 15:46:46.79 spid20s     CHECKDB for database 'SharedServices1_DB' finished without errors on 2010-11-21 01:41:04.320 (local time). This is an informational message only; no user action is required.
2010-11-21 15:46:47.47 spid12s     CHECKDB for database 'msdb' finished without errors on 2010-11-21 00:00:10.937 (local time). This is an informational message only; no user action is required.
2010-11-21 15:46:47.53 spid9s      Starting up database 'tempdb'.
2010-11-21 15:46:47.54 spid9s      CHECKDB for database 'tempdb' finished without errors on 2010-11-21 00:00:10.297 (local time). This is an informational message only; no user action is required.
2010-11-21 15:46:47.55 spid13s     The Service Broker protocol transport is disabled or not configured.
2010-11-21 15:46:47.55 spid13s     The Database Mirroring protocol transport is disabled or not configured.
2010-11-21 15:46:47.58 spid13s     Service Broker manager has started.
2010-11-21 15:46:47.77 spid18s     Analysis of database 'WSS_Content' (10) is 100% complete (approximately 0 seconds remain). This is an informational message only. No user action is required.
2010-11-21 15:46:48.09 spid17s     CHECKDB for database 'WSS_Search_CKC-PJ-W-1' finished without errors on 2010-11-21 00:00:22.433 (local time). This is an informational message only; no user action is required.
2010-11-21 15:46:48.67 spid18s     Recovery is writing a checkpoint in database 'WSS_Content' (10). This is an informational message only. No user action is required.
2010-11-21 15:46:48.96 spid18s     CHECKDB for database 'WSS_Content' finished without errors on 2010-11-21 00:03:20.640 (local time). This is an informational message only; no user action is required.
2010-11-21 15:46:49.00 spid5s      Recovery of any in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC) has completed. This is an informational message only. No user action is required.
2010-11-21 15:46:49.00 spid5s      Error: 8355, Severity: 16, State: 1.
2010-11-21 15:46:49.00 spid5s      Server-level event notifications can not be delivered. Either Service Broker is disabled in msdb, or msdsb failed to start. Event notifications in other databases could be affected as well. Bring msdb online, or enable Service Broker.
2010-11-21 15:46:49.00 spid5s      Recovery is complete. This is an informational message only. No user action is required.
2010-11-21 15:46:58.26 spid54      Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install.
2010-11-21 15:46:58.27 spid54      Configuration option 'Agent XPs' changed from 0 to 1. Run the RECONFIGURE statement to install.
2010-11-21 15:46:58.31 spid54      Configuration option 'show advanced options' changed from 1 to 0. Run the RECONFIGURE statement to install.
2010-11-21 15:47:01.30 spid54      Using 'xpsqlbot.dll' version '2005.90.4035' to execute extended stored procedure 'xp_qv'. This is an informational message only; no user action is required.
2010-11-21 15:47:03.49 spid54      Using 'xpstar90.dll' version '2005.90.4035' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required.
2010-11-21 15:47:03.58 Logon       Error: 18456, Severity: 14, State: 16.
2010-11-21 15:47:03.58 Logon       Login failed for user 'MMM\wss-User1'. [CLIENT: 129.129.129.129]
2010-11-21 15:47:03.65 spid54      Using 'xplog70.dll' version '2005.90.4035' to execute extended stored procedure 'xp_msver'. This is an informational message only; no user action is required.
2010-11-21 15:48:03.92 Logon       Error: 18456, Severity: 14, State: 16.
2010-11-21 15:48:03.92 Logon       Login failed for user 'MMM\wss-User1'. [CLIENT: 129.129.129.129]
2010-11-21 15:49:04.29 Logon       Error: 18456, Severity: 14, State: 16.
2010-11-21 15:49:04.29 Logon       Login failed for user 'MMM\wss-User1'. [CLIENT: 129.129.129.129]
2010-11-21 15:50:04.64 Logon       Error: 18456, Severity: 14, State: 16.
2010-11-21 15:50:04.64 Logon       Login failed for user 'MMM\wss-User1'. [CLIENT: 129.129.129.129]
2010-11-21 15:51:04.97 Logon       Error: 18456, Severity: 14, State: 16.
2010-11-21 15:51:04.97 Logon       Login failed for user 'MMM\wss-User1'. [CLIENT: 129.129.129.129]
2010-11-21 15:52:05.25 Logon       Error: 18456, Severity: 14, State: 16.
2010-11-21 15:52:05.25 Logon       Login failed for user 'MMM\wss-User1'. [CLIENT: 129.129.129.129]
0
Comment
Question by:nsdlsandy
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 13

Expert Comment

by:George K.
ID: 34194387
Regarding WSS, you seem to have some service/account problems
here is how you can change them.

http://support.microsoft.com/kb/934838
0
 
LVL 1

Author Comment

by:nsdlsandy
ID: 34195860
I have done  that , still has the account issue.
0
 
LVL 1

Accepted Solution

by:
nsdlsandy earned 0 total points
ID: 34200901


Now I am not able to delete or check-out the document. The stored procedure is returning null parameters.
0
 
LVL 1

Author Closing Comment

by:nsdlsandy
ID: 34328718
This issue got resolved. Issue was caused because of incomplete installation of WSS Patch. Had to consult Microsoft support because only they can look in the tables and folders to see till what point installation was done and how to complete it.
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently, Microsoft released a best-practice guide for securing Active Directory. It's a whopping 300+ pages long. Those of us tasked with securing our company’s databases and systems would, ideally, have time to devote to learning the ins and outs…
After seeing many questions for JRNL_WRAP_ERROR for replication failure, I thought it would be useful to write this article.
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…

604 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question