Solved

Sharepoint spconfig fails and now SBS2011 will mot back up.

Posted on 2013-05-24
7
606 Views
Last Modified: 2013-06-03
after the sharepoint update I ran spconfig command and it fails on one of the steps.  Now in event viewer there are errors from sharepoint comming up.

one of the errors are event id 3760:::::SQL Database 'WSS_Search_SBS2011' on SQL Server instance 'SBS2011\SHAREPOINT' not found. Additional error information from SQL Server is included below.

Cannot open database "WSS_Search_SBS2011" requested by the login. The login failed.
Login failed for user 'SAMS\spfarm'.


and the other error is event id 6398:::::The Execute method of job definition Microsoft.SharePoint.Search.Administration.SPSearchJobDefinition (ID d4f93fc8-3847-4237-90a0-1d5b6397fa4a) threw an exception. More information is included below.

Cannot open database "WSS_Search_SBS2011" requested by the login. The login failed.
Login failed for user 'SAMS\spfarm'.



whenever i tun the backup it fails when it is trying to run the VSS before it backs up the data.

Im pretty sure the server is not backing up because sharepoint will not update.  Any Ideas
0
Comment
Question by:BBrayton
  • 4
  • 3
7 Comments
 
LVL 8

Expert Comment

by:PaulD77
ID: 39194128
Give this a shot...
Open the SharePoint management shell..Start, all programs, Microsoft SharePoint 2010 products, mgmnt shell
run the command
(get-spserver $env:servername).NeedsUpgrade  where server name is the name of your machine
If the Value comes back as True, try running the psconfig command.  Follow the details in this article:

http://blogs.technet.com/b/sbs/archive/2011/07/06/potential-issues-after-installing-sharepoint-foundation-2010-sp1.aspx
0
 

Author Comment

by:BBrayton
ID: 39194174
I tried that it does not some up with anything.  it just starts a new command line.
0
 
LVL 8

Expert Comment

by:PaulD77
ID: 39194181
I would run the PSconfig anyway just to force any updates.  The site will go down for a few minutes while it runs
0
Free camera licenses with purchase of My Cloud NAS

Milestone Arcus software is compatible with thousands of industry-leading cameras for added flexibility. Upon installation on your My Cloud NAS, you will receive two (2) camera licenses already enabled in the software. And for a limited time, get additional camera licenses FREE.

 

Author Comment

by:BBrayton
ID: 39194182
If I don't put in the computer name and leave the line as default it tells me false.
0
 

Author Comment

by:BBrayton
ID: 39194197
If I stop the sharepoint server service and the sharepoint timer server the server does backup. It backed up yesterday then I turned the services back on and the scheduled backup failed last night.
0
 
LVL 8

Accepted Solution

by:
PaulD77 earned 500 total points
ID: 39194213
Ok, well I'm hoping your database is still there.  Take a look at this article, skip over the restore part and start from reconnect to central admin

http://technet.microsoft.com/en-us/library/cc561036(v=office.12).aspx

If the DB is not there, you may need to restore from a backup

This may help you as well:

http://technet.microsoft.com/en-us/library/cc561011(v=office.12).aspx
0
 

Author Comment

by:BBrayton
ID: 39194216
I get this error on step 5 of 6 Failed to upgrade Sharepoint products


An exception of type Microsoft.SharePoint.PostSetupConfiguration.PostSetupConfig
urationTaskException was thrown.  Additional exception information: The upgrade
command is invalid or a failure has been encountered.
Failed to upgrade SharePoint Products.

Total number of configuration settings run: 5
Total number of successful configuration settings: 4
Total number of unsuccessful configuration settings: 1
Successfully stopped the configuration of SharePoint Products.
Configuration of SharePoint Products failed.  Configuration must be performed be
fore you use SharePoint Products.  For further details, see the diagnostic log l
ocated at C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\1
4\LOGS\PSCDiagnostics_5_24_2013_9_15_11_740_725939300.log and the application ev
ent log.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Sharrepoint 2010 DB size 2 31
Microsoft  Partnership 1 64
Starting imported SBS2011 as VM in HyperV 14 81
Is AD Certificate Services necessary to migrate 7 47
The articles for turning off the Client firewall policy on the internet are for SBS 2008 and don't really help for SBS 2011. They actually moved the Client firewall policy. In 2011, the client firewall policy has moved to the SBS computers conta…
Because virtualization becomes more and more common, and, with Microsoft Hyper-V included in Windows Server at no additional costs, and, most server hardware nowadays is more than capable of running a physical Small Business Server (SBS) 2008 or 201…
Delivering innovative fully-managed cloud services for mission-critical applications requires expertise in multiple areas plus vision and commitment. Meet a few of the people behind the quality services of Concerto.
A company’s greatest vulnerability is their email. CEO fraud, ransomware and spear phishing attacks are the no1 threat to a company’s security. Cybercrime is responsible for the largest loss of money to companies today with losses projected to r…

930 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now