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.
Course Of The Month
4 days, 12 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
SharePoint Sql Server Error
Posted on 2010-11-22
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_e
2010-11-21 15:46:45.17 spid19s Starting up database 'WSS_Content_de197ff40ced4
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_de197ff40ced4
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_de197ff40ced4
2010-11-21 15:46:46.35 spid14s CHECKDB for database 'SharePoint_AdminContent_e
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]
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_e
2010-11-21 15:46:45.17 spid19s Starting up database 'WSS_Content_de197ff40ced4
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_de197ff40ced4
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_de197ff40ced4
2010-11-21 15:46:46.35 spid14s CHECKDB for database 'SharePoint_AdminContent_e
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]
[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
Regarding WSS, you seem to have some service/account problems
here is how you can change them.
http://support.microsoft.com/kb/934838
here is how you can change them.
http://support.microsoft.com/kb/934838
Now I am not able to delete or check-out the document. The stored procedure is returning null parameters.
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
This article demonstrates probably the easiest way to configure domain-wide tier isolation within Active Directory.
If you do not know tier isolation read https://technet.microsoft.com/en-us/windows-server-docs/security/securing-privileged-access/s…
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s
ManageEngine
webinar, where attendees received a comprehensive look at the ma…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Suggested Courses
Course of the Month4 days, 12 hours left to enroll
687 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.