SQL Server(SBSMONITORING) and SBS Manager won't start on services

Question

Good Day! I have a problem about SBS11 console I'm trying to generate report but SQL Server(SBSMONITORING) and SBS Manager won't start on services. thanks in advance for the answers.

Answer 1

A start for me (since I'm an SQL Server person) would be to look in C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\LOG\Errorlog to see which excuses SQL Server has.

Note here that the exact path depends on the SQL Server version. (And I don't know if there are any specials with SBS.)

Answer 2

Hi,
I consider that you could try to check the following path:

C:\Program Files\Windows Small Business Server\Logs\Console.log

And related events in event viewer. Based on my knowledge, Windows SBS Manager relies on a SQL database running on a SQL express instance called SBSMonitoring. Under certain circumstances, the database may become unusable, when this happens you can experience behaviors like the SBS console crashing, or incorrectly reporting the status of machines.

You may try to create a new, blank, database to regain functionality. Detailed steps you may reference link below:
http://blogs.technet.com/b/sbs/archive/2011/08/22/how-to-recreate-the-sbsmonitoring-database.aspx
Hope this helps and please help to accept as Answer if the response is useful.
Best Regards,
Carl