D365 Finance VSTS/ azure devops DB sync fails / [error]SYNCENGINE(0,0): Error Number: -2,State:0,Class:11/ C:\DynamicsSDK\Metadata\SyncEngine.proj] Database synchronization failed

 While working with the D365 F&O build server, we suddenly started to get the timeout error on the database synchronization step. Checking the logs on the azure dev ops pointed out that, db sync was not able to complete the login phase for the sql server. 

 

This was odd, as the builds have been working fine until this point. This was a wild goose chase to check the settings of the sql server, hosts file, testing pings etc …

 

Build failed:

 

This started happening after we took 10.0.14 quality update, or it was co-incidence – we are not sure yet.

Resolution:

 

It came down to the “Auto close” was set to “True”, after changing that to “False”, we can see that now builds are getting done successfully.

Connect to Cloud hosted build server and open SSMS - Sql server management studio and connect to AxDB.

If in case AxDB in recovery mode run the below query to set it normal.

ALTER DATABASE AxDBSET MULTI_USER;
GO

Now, right click on AxDB and go to properties -> Go to potions and set Auto close false.

or you can run below query to set auto close off.

ALTER DATABASE [AxDB] SET AUTO_CLOSE OFF;

@Rahul

for more details please refer below link.

https://rizworks.wordpress.com/2020/02/23/d365-fo-dbsync-error-errorsyncengine00-error-number-2state0class11/