Tuesday, March 20, 2018

AOS Service start Error

Error:
When you try to start the AOS. "Error 100: Cannot create another system semaphore"

Resolution:
Steps:
1. Add the below permission to AOS SQL user
    db_ddladmin, db_datareader, db_datawriter

2. Update the below query on SQL
    Query:
    update SQLSystemVariables set value = '4' where parm = 'SYSTIMEZONESVERSION'

No comments:

Post a Comment

Missing_index in D365FO

 Refrence: sys.dm_db_missing_index_details (Transact-SQL) - SQL Server | Microsoft Learn