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

Aldrin FernandeZ 1 Reputation point
2021-03-24T14:26:11.643+00:00

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.

Windows Small Business Server
Windows Small Business Server
A family of Microsoft server products with messaging and collaboration, security-enhanced internet access, protected data storage, reliable printing, faxing, and the ability to run line-of-business applications. Replaced by Windows Server Essentials.
39 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,636 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erland Sommarskog 100.8K Reputation points MVP
    2021-03-24T22:57:13.45+00:00

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

    0 comments
  2. Carl Fan 6,836 Reputation points
    2021-03-25T07:24:33.417+00:00

    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

    0 comments