Failed to start the database service MSSQL$SharePoint

Question

This appears to be more in SQL Server than in SharePoint Server(this is what I believe):

This is the message from failed SharePoint Server installation.

There is a dbwraplog file which reads as shown:(only part of it copied)

INF:0:Starting process C:\Program Files\Common Files\Microsoft Shared\SERVER14\Server Setup Controller\sqlexpr.exe with args  /q /HideConsole  /ACTION=install /pid=11111-00000-00000-00000-00000 /FEATURES=SQL,Tools /SQLSYSADMINACCOUNTS="BUILTIN\ADMINISTRATORS" /SQLSVCACCOUNT="NT AUTHORITY\Network Service" /INSTANCENAME=SharePoint /INSTALLSQLDATADIR="C:\Program Files\Microsoft Office Servers\14.0\Data" and waiting 00:49:10 for it to stop
ERR:-2068578304:Leaving function RunCommand

I do find the SQLexpr.exe in

C:\Program Files\Common Files\Microsoft Shared\SERVER14\Server Setup Controllerit not

Why does it not start?

I do see the MSSQL10.SharePoint in the directory
C:\Program Files\Microsoft Office Servers\14.0\Data

There are no other SQL Servers on the machine at present.

I do not have SSMS.

Any help will be appreciated.

---

mysorian

Answer 1

Hello,

Please read the following thread:

http://social.msdn.microsoft.com/forums/en-IN/sharepointgeneralprevious/thread/94f39985-f5d1-4a56-956c-ee74fb4b65e0

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 2

I finally found why this happens. It's probably a bug in the code that prevents the sqlexpr.exe in the installaiton folder from starting. There are various hotfixes, the problem is, which is the correct one to use for fixing this.

I also found a way to get around this irritating problem.

---

mysorian