Skip to main content

Failed to start the database service MSSQL$SharePoint


Today when i uninstall my sharepoint because of frame work and reinstall it! i face the strange problem

Failed to start the database service MSSQL$SharePoint

After a small search i found the proper solution and this credit goes to
"ayman shawky" 
he has given the solution under http://social.msdn.microsoft.com/Forums/en/searchserverinstallconfigandadminstration/thread/104e2875-37be-4506-94ff-6762f19345f8

For you Guys I have just copy and past here


  1. Go to “regedit” through run command, 
  2. browse thru “HKLM_Local_Machine/Software/Microsoft/Shared Tools/Web Server Extensions/12.0/WSS/”. 
  3. Then change the value of attribute named “ServerRole” from SINGLESERVER to APPLICATION
  4. Then save it 
Now when you run the wizard it will now show you the sharepoint application installation wizard 

Hope it will work with you as well 

and thanks for "ayman shawky" 

Regards
3ART Technologies



Labels:

Comments

  1. ImwmkJanuary 22, 2013 at 12:12 AM

    To resolve this issue, you need to install SQL Express 2005 with Service pack 3.

    After the installation, go to Program and Features and repair the Sharepoint installation.

    ReplyDelete
  2. JisperkMay 16, 2013 at 12:28 PM

    Thank's for your help!!!

    ReplyDelete
  3. UnknownMay 28, 2014 at 4:50 AM

    Thanks for the information. I have just signed up for a free SharePoint site with http://www.cloudappsportal.com

    ReplyDelete
  4. DigihostJanuary 25, 2018 at 1:14 AM

    Thanks For sharing nice article about database development services.
    Database Development Services in India

    ReplyDelete
  5. for ict 99March 17, 2018 at 9:39 PM

    great

    ReplyDelete

Post a Comment

Popular posts from this blog

[Solved] SharePoint 2013 And Adobe Reader Problem : The URL you have provided could not be reached. Please verify that the URL is correct and that the network location is reachable

Dear All  When trying to open a PDF file from a mapped drive in SharePoint 2010.  You might see the following error message. The URL you have provided could not be reached. Please verify that the URL is correct and that the network location is reachable. 1. Open the registry. 2. Go to HKLM Local Software\SOFTWARE\Policies\Adobe\\\FeatureLockDown. 3. Create a key called cSharePoint. 4. Create a DWORD value called bDisableSharePointFeatures. 5. Set its value to 1. Regards Rashid Imran Bilgrami CEO Best visualization http://www.bestvisualization.com  
Post a Comment
Read more

Content Query Webpart Template In SharePoint 2013 and add new column in it

Dear All, Here is the easiest way to make add custom column under your content query web part and then you can format it as you want. Step 1:  Open Sharepoint design Step 2:  Open site for sharepoint parent site collection Step 3:  Locate the following folder Style Library > XLS Style Sheets Step 4:  Open "ItemStyle.xsl"  file Add the custom style sheet as you want <xsl:template name="[Your Style Name]" match="Row[@Style='[Your Style Name]']" mode="itemstyle">                                                   <xsl:param name="CurPos" />                          ...
1 comment
Read more

SQL SPLIT FUNCTION or String_split sql function alternative Very Information (Solved)

Dear All,  Today i created a form with the checkbox list and store the value in the sql with comma seprated way. It was strange for me that the split_string function is not supported in sql 2014, so i have created split function that will help to split the comma sepearted values   CREATE FUNCTION dbo.Split(@String varchar(8000), @Delimiter char(1))      returns @temptable TABLE (items varchar(8000))      as      begin      declare @idx int      declare @slice varchar(8000)      select @idx = 1          if len(@String)<1 or @String is null  return      while @idx!= 0      begin          set @idx = charindex(@Delimiter,@String)          if @idx!=0              set @slice = left(@String,@idx - 1)          else  ...
Post a Comment
Read more