Hello all,
I am new here, I am trying to connect SQL with Acumatica for the first time but I have been unable to do it. I’d appreciate any advice. This is the message I get…
Answer
Setting up Acumatica + SQL
Best answer by Laura03
Hello,
As an Acumatica consultant, I remove/re-install Acumatica versions at least once a year. I created a ‘cheat sheet’ using my notes, and I’ve shared the details below. The rest of the details & steps, you will find in the Acumatica ERP_InstallationGuide.pdf document.
- Download & install recent version of SQL Server. The DEVELOPER edition is free for demo systems; not for resale.
- Download most recent version of Acumatica from Acumatica.com. There will be two files: one for the framework and one for the app.
- Activate IIS.
Control Panel --> Programs & Features --> Turn Windows features on or off. Turn on ALL features as listed in the Acumatica ERP_InstallationGuide.pdf document:
(Numbering goofy because I copied from Word in pieces.)
- Execute the Framework MSI.
- The Acumatica ERP FRAMEWORK configurator opens automatically at the end of process # 4. Follow through on setting up the Framework (system) database. Accept defaults. Steps 4 and 5 look the same, sort of, but if you skip this step to create the framework database, the next step to create the tenants won’t work. It won’t find the application pool during tenant configuration.
- Execute the Acumatica ERP installation MSI.
- When ERP installation completes, the Acumatica ERP configurator opens. Use it to Set up the tenants.
- I like to set up one tenant for Each Option (Sales Demo, U100, i100, etc.) plus one EMPTY tenant.
If your steps match everything shown above, post more details and someone more technical than I will come along to help.
Laura
+19Hello, it may be helpful for us to see how the Database Server Connection screen was populated, before the error appeared. Include some detail about installation steps you have taken so far. Thank you.
Laura
~ Laura Barber, WM Synergy
+19Hello,
As an Acumatica consultant, I remove/re-install Acumatica versions at least once a year. I created a ‘cheat sheet’ using my notes, and I’ve shared the details below. The rest of the details & steps, you will find in the Acumatica ERP_InstallationGuide.pdf document.
- Download & install recent version of SQL Server. The DEVELOPER edition is free for demo systems; not for resale.
- Download most recent version of Acumatica from Acumatica.com. There will be two files: one for the framework and one for the app.
- Activate IIS.
Control Panel --> Programs & Features --> Turn Windows features on or off. Turn on ALL features as listed in the Acumatica ERP_InstallationGuide.pdf document:
(Numbering goofy because I copied from Word in pieces.)
- Execute the Framework MSI.
- The Acumatica ERP FRAMEWORK configurator opens automatically at the end of process # 4. Follow through on setting up the Framework (system) database. Accept defaults. Steps 4 and 5 look the same, sort of, but if you skip this step to create the framework database, the next step to create the tenants won’t work. It won’t find the application pool during tenant configuration.
- Execute the Acumatica ERP installation MSI.
- When ERP installation completes, the Acumatica ERP configurator opens. Use it to Set up the tenants.
- I like to set up one tenant for Each Option (Sales Demo, U100, i100, etc.) plus one EMPTY tenant.
If your steps match everything shown above, post more details and someone more technical than I will come along to help.
Laura
~ Laura Barber, WM Synergy
+15As
Dermot Comerford
+17HI
Along with what
I would check the iis manager as well to see if that is started
Kandy ~ If a member helped you, please *Like* their post, and if a member provided an answer to your question, please mark it as *Best Answer*.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.