question

AldrinFernandeZ-7956 avatar image
0 Votes"
AldrinFernandeZ-7956 asked CarlFan-MSFT answered

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

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.

sql-server-generalwindows-small-business-server
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ErlandSommarskog avatar image
0 Votes"
ErlandSommarskog answered

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

CarlFan-MSFT avatar image
0 Votes"
CarlFan-MSFT answered

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.