The database dbname is not accessible. (ObjectExplorer)

(0) Share

Report

Posted on by Hariharans87

Hi,

I did the AOS restart. It is not starting. I noticed that the database is not accessible.

When i click the database in the SQL server management studio, i am getting the error message "The database dbname is not accessible. (ObjectExplorer)"

Thanks,

Hari

*This post is locked for comments

I have the same question (0)

All responses (15)

Answers (2)

tenda membrane 5 on at

Like (0)

Report

RE: The database dbname is not accessible. (ObjectExplorer)

halo

please Check if you and the AOS Service Account have the proper rights on AX Databases.

https://suryatendamembrane.com

Was this reply helpful? Yes No
Hariharans87 3 on at

Like (0)

Report

RE: The database dbname is not accessible. (ObjectExplorer)

Hi Dick,

I am logging with domain account like domain\hari

Was this reply helpful? Yes No
Dick Wenning 8,705 Moderator on at

Like (0)

Report

RE: The database dbname is not accessible. (ObjectExplorer)

are you logging in with a local account or a domain account?

Was this reply helpful? Yes No
Verified answer

Iulian Cordobin 8,201 on at

Like (0)

Report

RE: The database dbname is not accessible. (ObjectExplorer)

There are multiple reasons why this could happen.

Either a restart of the SQL Server (which is not the case), something in the log was not properly processed, or a real failure in the database (logical or physical corruption) of data. I would say run that command, and look in the Event Viewer for logs coming from MSSQLSERVER source.

Was this reply helpful? Yes No
Iulian Cordobin 8,201 on at

Like (0)

Report

RE: The database dbname is not accessible. (ObjectExplorer)

Try this first: in SSMS run a

DBCC CHECKDB ('MicrosoftDynamicsAx') WITH ALL_ERRORMSGS, NO_INFOMSGS

Was this reply helpful? Yes No
Hariharans87 3 on at

Like (0)

Report

RE: The database dbname is not accessible. (ObjectExplorer)

Hi Brain,

Sorry. I could not understand your point. Could you please explain clearly?

Thanks,

Hari

Was this reply helpful? Yes No
Hariharans87 3 on at

Like (0)

Report

RE: The database dbname is not accessible. (ObjectExplorer)

Hi Ilulian,

The SQL server was not restarted.

Could you please let me know in which case the AX database is going to recovery mode?

Thanks,

Hari

Was this reply helpful? Yes No
Verified answer

Brian Kinser 815 on at

Like (0)

Report

RE: The database dbname is not accessible. (ObjectExplorer)

Also make sure that on the SQL instance you have added yourself AND the AXSysAccount (the account the AOS runs under)......you may not have physical access to that db, especially if someone ran the install under admin login and now you are logging in as yourself.....get someone to add under permissions in SQL db

Was this reply helpful? Yes No
Suggested answer

Iulian Cordobin 8,201 on at

Like (0)

Report

RE: The database dbname is not accessible. (ObjectExplorer)

Well, one thing that this can mean is that the SQL server was also restarted and it's just bringing the database up. Now, if everything is ok, you should be able to use it shortly (depending on how big it is). I would suggest wait some time and then do a refresh in SSMS and see if it's still in Recovery. If it's not, you're good to go. If still, you need to look further more into possible reasons.

Was this reply helpful? Yes No
Hariharans87 3 on at

Like (0)

Report

RE: The database dbname is not accessible. (ObjectExplorer)

Yes. I noticed that it is displayed as dbname (in recovery) in the SSMS.

Was this reply helpful? Yes No