Skip to main content
Solved

New Acumatica Instance


I am looking to install a new instance on my personal computer for training.

How do I navigate the database Server connection request for - server type and server name per MYSQL server- not conversant with this.

Can anyone help

Best answer by MichaelShirk

As I recall, if it allows you to get to this point, it was able to establish a connection. 
I could be wrong here, but this looks like an issue with Internet Information Services (IIS).
The error messages don’t mention an authentication error, but rather an issue with application pools, which are managed by IIS. 
Do these errors pop up before you’ve clicked anything on the Website Configuration window?

Also, it’s worth asking. Did you carefully follow the IIS configuration steps outlined in this article? Setting Up Local Developer Instances of Acumatica - Part 1

There are a number of things that have to be configured in IIS in order to run an Acumatica instance on your computer. 

I would also suggest selecting the option to create a new application pool, since if you are doing development work, you will sooner or later want to install more than one instance and those should be run in separate application pools.

View original
Did this topic help you find an answer to your question?

14 replies

MichaelShirk
Captain I
Forum|alt.badge.img+1

Hey! Have you found/followed the instructions in these articles? I’ve found these very helpful when I was first learning to set up developer instances.

Setting Up Local Developer Instances of Acumatica - Part 1

Quick-Start Acumatica Developer Guide | Acumatica Cloud ERP

 

Hope this helps!


  • Author
  • Freshman I
  • 6 replies
  • July 24, 2024

Thanks Michael- Please see snapshot of what am talking about, and am using my personal computer at home

 

 


Forum|alt.badge.img+1

MichaelShirk
Captain I
Forum|alt.badge.img+1

@Olaoguntola75 In your original post you mention MYSQL server, and in the screenshot, the server type you have selected is Microsoft SQL Server. These are two different types of SQL servers, so can you confirm which type you have installed? 
 

I you are using Microsoft SQL Server, and have not made any special configurations, you should be able to click “Next” on the Database Server Connection window shown in your screenshot and it will use the default anonymous user account used by Internet Information Services (IIS) to authenticate your connection to the database.

I am not familiar with setting up a MYSQL server connection.


  • Author
  • Freshman I
  • 6 replies
  • July 24, 2024

@pallikasharma11 - I was able to get to the database connection then I get this error- seems it has something to do with the rights

 

@MichaelShirk , I went with Microsoft SQL Server. thanks 


MichaelShirk
Captain I
Forum|alt.badge.img+1

When setting up a local dev instance I typically don’t create a new SQL Server login. On the database connection window, I select the “Windows Authentication” option and the system takes care of the login in the background. 
Did this not work for you, or did you have a reason for not wanting to use Windows Authentication?


  • Author
  • Freshman I
  • 6 replies
  • July 24, 2024

@MichaelShirk I did use the window authentication and on the website configuration page, this is what I got ..

 

 


  • Author
  • Freshman I
  • 6 replies
  • July 24, 2024

MichaelShirk
Captain I
Forum|alt.badge.img+1
  • Captain I
  • 108 replies
  • Answer
  • July 24, 2024

As I recall, if it allows you to get to this point, it was able to establish a connection. 
I could be wrong here, but this looks like an issue with Internet Information Services (IIS).
The error messages don’t mention an authentication error, but rather an issue with application pools, which are managed by IIS. 
Do these errors pop up before you’ve clicked anything on the Website Configuration window?

Also, it’s worth asking. Did you carefully follow the IIS configuration steps outlined in this article? Setting Up Local Developer Instances of Acumatica - Part 1

There are a number of things that have to be configured in IIS in order to run an Acumatica instance on your computer. 

I would also suggest selecting the option to create a new application pool, since if you are doing development work, you will sooner or later want to install more than one instance and those should be run in separate application pools.


  • Author
  • Freshman I
  • 6 replies
  • July 24, 2024

@MichaelShirk 

Do these errors pop up before you’ve clicked anything on the Website Configuration window? After Clicking.


iqraharrison
Captain II
Forum|alt.badge.img+8
  • Captain II
  • 520 replies
  • July 24, 2024

@Olaoguntola75 i recently went through setting up a local environment with MySQL, however that came with a few issues (slowness, dashboard errors) so we ended up switching to Microsoft SQL and we noticed a significant increase in speed as well as no more dashboard error.  I would recommend using microsoft if you have the option


MichaelShirk
Captain I
Forum|alt.badge.img+1

@Olaoguntola75 it sounds like an IIS configuration issue to me. I’ve created a lot of local Acumatica instances and some of the errors thrown by IIS can be hard to track down. 

The error sounds familiar, but I couldn’t tell you where to start looking in IIS for the source of the problem.

 


  • Author
  • Freshman I
  • 6 replies
  • July 24, 2024

@MichaelShirk you very correct. was the IIS and I followed the setting and it worked 😀.

 

Is there a guide on how to launch it was its installed?


MichaelShirk
Captain I
Forum|alt.badge.img+1

@Olaoguntola75 not beyond the instructions in the articles I shared. 
A lot of what I know I’ve learned through trial and a lot of error!😏

If my answer helped you solve the issue, I’d appreciate if you mark it “best answer”!


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings