Error while restarting AX 2012 service

Issue: The database Servername\ModelDatabase is not recognised as a model store

Below error occurred while restarting AX2012 service after database restore:

 

  

Event log error:

Object Server 01:The database Servername\ModelDatabase is not recognized as a model store

Object Server 01:  Fatal SQL condition during login. Error message: "[Microsoft][SQL Server Native Client 10.0][SQL Server]Login failed for user “User name”

Solution: 

1. This issue happen when service account do not have access on the database from where we took backup. So simply AOS component can be uninstalled and installed again which will fix the issue.

2. After database refresh add AX service account in database security section and provide proper permission which will fix the issue.

login. Error message: "[Microsoft][SQL Server Native Client 10.0][SQL Server]Login failed for user “User name”