Microsoft Dynamics AX - Cannot open database "AXDBRain" requested by the login

Views (1948)

Gaurav Pandey

960

Like(1)

Report

While doing some development in new Microsoft Dynamics AX , while adding a field in a Data entity ,during synchronization I got below error :

Error       Cannot open database "AXDBRain" requested by the login. The login failed.
Login failed for user 'xxxxxxx-xxx\xxxxx'. when try to connect to business database with provided configuration.

This error was misleading , because AXDBRain is not the correct DB which my AX is connected with.

Solution :

Go to C:\Users\userid\Documents\Visual Studio 2015\Settings\DefaultConfig.XML
and change the following :

<BusinessDatabaseName>CorrectDBname</BusinessDatabaseName>

Save the file.

Restart VS and try to do Sync again , hopefully this will help to sync.

This was originally posted here.