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.


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  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)


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

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
DBCC checkdb(‘SharePoint_Config’)
— Set the database in single user mode
–Repair the database with data loss
DBCC CheckDB (‘SharePoint_Config’, REPAIR_ALLOW_DATA_LOSS)
–Set the database in multi-user mode
–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 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) –

Capability Overview –

Edition Comparison –


Advanced IT Pro Training –
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 –


Full TechNet Documentation –

The Total Economic Impact of SharePoint 2010 –


Download trial –

VM demonstration images –



SharePoint Team Blog –

SharePoint 2010 Forums

Downloadable Books

Getting started with SharePoint Server 2010 –

Planning guide for SharePoint Server 2010 –

Upgrading to SharePoint Server 2010 –

Deployment guide for SharePoint Server 2010 –

Operations guide for SharePoint Server 2010 –

Technical reference for SharePoint Server 2010 –


Diagrams and white papers

Technical diagrams (SharePoint Server 2010) –

Evaluation guide for SharePoint Server 2010 (white paper)

Developer Resources

SharePoint Development Center –

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


Starting Point –

Excellent Free Developer Training –

Channel 9 Training –

SharePoint Developer Training Kit Download – 


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 –

Code Samples

SharePoint Downloads and Samples
SharePoint Code Gallery Projects
SharePoint CodePlex Projects