Error: Database could not be accessed

Hi @Harshita Try perform database maintenance by just reselecting the DB instance using Acumatica configuration wizard. That should update the DB server details of the instance. Here is the documentation link for the step I am referring to. 

https://help-2022r2.acumatica.com/Help?ScreenId=ShowWiki&pageid=fc906c62-c65b-44d6-8210-13d9cea2b88d

Hello @manikantad18 , thank you for your prompt response, i did check out the previously created topics relating to same issue and tried to follow those steps but still getting the same error.

Hi @Harshita Could you please review the database connection, 

Have you tried the suggestion provides in the above suggestions ?

Could you please change the database or create a new instance.

Just an update, what I tried now is I added 
<compilation debug=”true”> which was already set to False in the web.config file and then again tried to load the instance, and now a new error is getting triggered:
 

Just an update, what I tried now is I added 
<compilation debug=”true”> which was already set to False in the web.config file and then again tried to load the instance, and now a new error is getting triggered:
 

 

please restart SQL server once

@Harshita if it is a new installation without any user data, I would suggest to maybe delete existing instance(application and database) and just install a new instance. Probably be easier/faster than trying to troubleshoot existing installation. 

My guess would be that installation process got corrupted or something along that.

Just an update, what I tried now is I added 
<compilation debug=”true”> which was already set to False in the web.config file and then again tried to load the instance, and now a new error is getting triggered:
 

 

please restart SQL server once

tried, Still showing the same error

it still throws the same error as posted in first

Hello @Harshita !

When I was setting up Acumatica ERP for the first time, I ran into similar error messages during the set-up process. Please make sure that your system is meeting the minimum requirements and there is an active connection to the IIS. Please review and verify the following:

• Microsoft .NET Framework enabled and installed
• Internet Information Services (IIS) enabled
• Database can be accessed
• No interference from security software

I noticed that even if there are no error messages during the new instance install, it could still throw error messages when attempting to log in as you’re experiencing. I’ll include a link to our Help Archive for documentation as well: https://help-archive.acumatica.com/

Let me know if you have any questions, thanks!

hello @VladS , i did check out the points that you’ve listed here, but still it didn’t get resolved. So now what I did is I started from fresh to install the Acumatica instance, with all the points listed and now it didn’t threw any error.

The same thing happened to me today on an upgrade, no on a new install.

The way I got out of it is: I noticed that the company table missing the CompanyKey.

I noticed it when I did the database maintenance.

I entered the company key, then i completed the maintenance and everything worked again.

The same thing has happened to  me a few times, usually if  I built my solution before leaving work, then opening my instance when i got in in the morning.

Rebuilding the solution has helped.