SharePointsBlog

Interesting Exploits in Office 365 and SharePoint

Category Archives: Resources

SharePoint_Config Database Suspect Mode – Cannot Connect to the Configuration Database Error

If SQL Server ever crashes or hard booted, you may come across a possible corrupted SharePoint_Config database. Recently while doing SharePoint 2010 configuration of our new product suite on my VM, I had to hard reboot the VM. When the VM came back up, I received the dreaded “cannot connect to the configuration database error”.  This occurs while accessing any of the content web application.

cannot-connect-to-config-db-error

I’ve seen this condition before, so I tried the usual debugging avenue – – IIS Web Site availability, IIS Application Pool Availability. IIS Application Pool Identity, and SQL Server availability. (see http://support.microsoft.com/kb/823287)  After walking through these steps, I noticed that “SharePoint_Config” database was in suspect mode. (notice the order of the items in my debugging avenue…yes, SQLServer was last)

sharepoint_config_suspect1

A quick BING took me following links to fix this issue.

http://ahmershahid.wordpress.com/2009/05/25/moss-2007-config-db-in-suspect-mode/
http://www.aarat.com/sharepoint-config-database-suspect/

As it turned out, it’s not a SharePoint issue. Any SQL Server databases can be corrupted and gets in the suspect mode. The following steps will fix the suspect database mode issues. As usual, I don’t take credit for this solution, but only post as a reference.  The credit goes to above blogs.

— Use the Master database
Use Master
— Verify that database has issues
EXEC sp_resetstatus ‘SharePoint_Config’
— Put the database in emergency mode
ALTER DATABASE SharePoint_Config SET EMERGENCY
DBCC checkdb(‘SharePoint_Config’)
— Set the database in single user mode
ALTER DATABASE SharePoint_Config SET SINGLE_USER WITH ROLLBACK IMMEDIATE
–Repair the database with data loss
DBCC CheckDB (‘SharePoint_Config’, REPAIR_ALLOW_DATA_LOSS)
–Set the database in multi-user mode
ALTER DATABASE SharePoint_Config SET MULTI_USER
–Verify that database is reset
EXEC sp_resetstatus ‘SharePoint_Config’

To fix SQL Server database suspect mode, we need to use the SQL Server’s emergency mode which allows you repair the database by reparing to last normal state.

After running the script on the Master database, SharePoint_Config database suspect mode was fixed and I was able to access the content web application.

sharepoint_config_suspect_r

Advertisements

SharePoint 2010 Resources – Getting Started

I often get questions about finding information on SharePoint 2010, the best places to learn and the “hows” and “whys”.  It seems that many people will type in a single word or phrase into their favorite search engine…look at the first page and throw up their hands saying they can’t find anything.

It is the unfortunate state of our world with information overload and the attention spans of fleas.  I also find that many people seem to assume that every post/site or page on the web is absolutely factual and they don’t know how to determine the validity of the information they are ready.

With this commentary on society out of the way, I figured i would post some “getting started” links and resources for those of you wondering how to get started.

General SharePoint Information 

Main Microsoft Site (running on SharePoint 2010) – http://sharepoint.microsoft.com/en-us/pages/default.aspx

Capability Overview – http://sharepoint.microsoft.com/en-us/product/capabilities/Pages/default.aspx

Edition Comparison – http://sharepoint.microsoft.com/en-us/buy/Pages/Editions-Comparison.aspx

Training

Advanced IT Pro Training – http://technet.microsoft.com/en-gb/sharepoint/ff677987.aspx
IT Professional Overview – A video that shows you some of the great new features in SharePoint 2010
Experiencing the Microsoft SharePoint 2010 User Interface – A video that provides a look at the new, improved user interface in SharePoint 2010

Getting Started Screencast Series – A series of entry-level screencasts by Microsoft SharePoint MVPs that lets you take advantage of an 11-module e-learning course

Training and Certification – http://www.microsoft.com/learning/en/us/training/sharepoint.aspx

Documentation

Full TechNet Documentation – http://technet.microsoft.com/en-us/library/ee428287.aspx

The Total Economic Impact of SharePoint 2010 – http://go.microsoft.com/?linkid=9730143

Downloads

Download trial – http://technet.microsoft.com/en-us/evalcenter/ee388573.aspx

VM demonstration images – http://go.microsoft.com/?linkid=9728417

 

Communications

SharePoint Team Blog – http://sharepoint.microsoft.com/blog/Pages/default.aspx

SharePoint 2010 Forums
  

Downloadable Books

Getting started with SharePoint Server 2010 – http://go.microsoft.com/fwlink/?LinkId=191146

Planning guide for SharePoint Server 2010 – http://go.microsoft.com/fwlink/?LinkId=196150

Upgrading to SharePoint Server 2010 – http://go.microsoft.com/fwlink/?LinkId=196221

Deployment guide for SharePoint Server 2010 – http://go.microsoft.com/fwlink/?LinkId=196222

Operations guide for SharePoint Server 2010 – http://go.microsoft.com/fwlink/?LinkId=196154

Technical reference for SharePoint Server 2010 – http://go.microsoft.com/fwlink/?LinkId=196155

 

Diagrams and white papers

Technical diagrams (SharePoint Server 2010) – http://blogs.technet.com/b/seanearp/archive/2010/07/09/technical-diagrams-for-sharepoint-2010.aspx

Evaluation guide for SharePoint Server 2010 (white paper)

Developer Resources

SharePoint Development Center – http://msdn.microsoft.com/en-us/sharepoint/default.aspx

Setting Up the Development Environment for SharePoint 2010 on Windows Vista, Windows 7, and Windows Server 2008

What’s New in SharePoint Foundation 2010

What’s New in SharePoint Server 2010

Get Started Developing on SharePoint 2010

Getting Started with Development for SharePoint Foundation

Training

Starting Point – http://msdn.microsoft.com/en-us/library/ff770300.aspx

Excellent Free Developer Training – http://msdn.microsoft.com/en-us/sharepoint/ff420377.aspx

Channel 9 Training – http://channel9.msdn.com/learn/courses/SharePoint2010Developer/

SharePoint Developer Training Kit Download – http://www.microsoft.com/downloads/en/details.aspx?FamilyID=83a80a0f-0906-4d7d-98e1-3dd6f58ff059&displaylang=en 

Documentation

SharePoint 2010 SDK Documentation

SharePoint 2010 Technical Articles – Technical articles are 15-20 pages in length and provide detailed technical information and code examples

SharePoint 2010 Book Excerpts –  Book excerpts are online excerpts of published books.

SharePoint 2010 Visual  How-Tos  – Visual how-to articles are 10-15 pages in length and combine some of the best elements of blogs, video, and technical articles by providing a brief overview, a code sample, and a how-to video.

SharePoint 2010 Quick Notes – Quick Notes are 2-4 page tasks in a single scenario.

Search connector development – http://msdn.microsoft.com/en-us/library/ee556429.aspx

Code Samples

SharePoint Downloads and Samples
SharePoint Code Gallery Projects
SharePoint CodePlex Projects