Failed to start the database service MSSQL$OfficeServers. Repair this product by selecting it from the Add/Remove Programs menu.

After installing SharePoint when I tried running ‘SharePoint Products and Technologies Configuration Wizard’, it gave below error --

======================================================================

Failed to start the database service MSSQL$OfficeServers.  Repair this product by selecting it from the Add/Remove Programs menu. 

======================================================================

I tried reinstalling everything again but in vain. Finally after doing some research got a quick fix.

Solution:

Go to START -> RUN -> REGEDIT

Then locate this folder (HKLM/Software/Microsoft/Shared Tools/Web Server Extensions/12.0/WSS) and change ServerRole key from ‘SingleServer’ to ‘Application’.

Redirection to Login Page issue in SharePoint

This is my first blog and it may be useful to somebody and save their time, as we struggled a lot to figure out why some of our SharePoint pages were redirected to login page for anonymous users. Only at the time of testing we came to know that if we are logged-in (non-anonymous) and browse a page (which is checked-out) it shows up properly, and when we access the page as anonymous user we were redirected to login page. In spite of our site been enabled for anonymous users, we were facing this issue.  The behavior was such because we used ‘+’ (plus) special character in the URL in order to make our site SEO compliant. When we replaced ‘+’ with ‘-‘ in all the URLs (keeping it SEO compliant) and checked, the problem was resolved and it gave us a sigh of relief.