Open U T190 question

  • 24 October 2020
  • 17 replies
  • 470 views

Userlevel 1
Badge

Greetings all,

On page 9 in course T190 “Preparing the environment” I have completed everything up to:

“4. Clone or download the customization project and the source code of the extension library from the Help-and-Training-Examples repository in Acumatica GitHub to a folder on your computer.”

I have programming experience but am new to GitHub. How do I get the project and code files from Acumatica GitHub to my GitHup on my computer?

Thank you in advance!

 


17 replies

Userlevel 7
Badge +10

Greeting @dherr70,

I would recommend the following guide to get started with Git and GitHub: https://guides.github.com/introduction/git-handbook/

If you only want to get a copy of the repository, you can do it directly from the web browser. Just go to the Help and Training Examples repository, select the branch that you need (2020R1, 2020R2) and then click Code → Download ZIP

Here’s a directly link to the 2020R2 branch: https://github.com/Acumatica/Help-and-Training-Examples/archive/2020R2.zip

Userlevel 1
Badge

Thank you Gabriel! This all worked. However I am now stuck on the following error message after completing the “Step 2: Deploying the Needed Acumatica ERP Instance for the Training Course”

Error message:

Сan't add a login or user to the database. It could happen if you do not have enough rights or the specified login/user is not found by database server (in case of using Windows Authentication). Try to use SQL Server Authentication or add login/user manually to the database.

What rights do I need to add for using Windows Authentication? I also tried to use SQL Server Authentication and adding a new login/user. It said it was successful but that there is no pipeline to connect.

Userlevel 7
Badge +10

@dherr70 to use Windows Authentication, the user account of the application pool under which your Acumatica web site runs needs to be added to SQL Server with the appropriate permissions (sysadmin is fine for a local dev system). I suggest reading this article and following the instructions provided: https://docs.microsoft.com/fr-ca/archive/blogs/ericparvin/how-to-add-the-applicationpoolidentity-to-a-sql-server-login

In this article, you have screenshots showing how to add an application pool used to SQL and granting sysadmin access: https://blog.arvixe.com/iis-user-permissions-in-sql-server/

 

 

 

Userlevel 1
Badge

Any insight?

The message says:

TITLE: Microsoft SQL Server Management Studio
------------------------------

Create failed for Login 'IIS APPPOOL \ AppPoolName'.  (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=14.0.17224.0+((SSMS_Rel_17_4).180212-1043)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+Login&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

Windows NT user or group 'IIS APPPOOL \ AppPoolName' not found. Check the name again. (Microsoft SQL Server, Error: 15401)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=14.00.1000&EvtSrc=MSSQLServer&EvtID=15401&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------
 

Userlevel 1
Badge

Thank you for your patience. On page 10 of the T190 guide (attached), what is the name of the application to use for Pool Identity? Is it PhoneRepairShop? MyTenant? Other? Thank you for your help.

 

Userlevel 1
Badge

Any further help available on this? I’ve tried every step in the documentation and additional articles and still cannot launch.

 

Userlevel 7
Badge +10

Where are you stuck? Can you share a screenshot?

Userlevel 1
Badge

Hi Gabriel! Here it is, hope you can read it. It says Login failed for user IIS APPPOOL\DefaultAppPool. I tried entering that in my SQL Security Login per instructions but get the same result. (I will send that screen as well.)

 

Userlevel 7
Badge +10

Were you able to add the DefaultAppPool user to SQL?

if so, did you grant it the sysadmin role under the Server Roles pages of the SQL user login?

if not, what is the error message you get?

Userlevel 1
Badge

ok I’ve done that now. Public was also checked:

 

Userlevel 1
Badge

Eureka! That worked and I am in. Thank you so much!

Userlevel 7
Badge +10

Fantastic @dherr70 ! Glad to hear that you are now able to login :sunglasses:

Userlevel 1
Badge

In T190 guide, on Page 15, Step 1.3 Binding the Extension Library

  1. Open the Visual Studio solution and build the PhoneRepairShop_Code project.

Should I be concerned about the error messages on the build? (see screen shot)

 

Userlevel 7
Badge +10

Yes, the references to PX.Data.dll, PX.Objects.dll, etc. are probably not pointing to the right path - expand the references node in the solutions explorer and you should see that immediately. 

 

In the future, please open a separate topic in the community since it relates to a different question.

Userlevel 1
Badge

Ok thank you Gabriel, will do.

 

Userlevel 7
Badge +8

For the instructions on how to install Acumatica on SQL Express, please see the following knowledge base article.

Thank you posting this problem.  It just helped me a couple years later.

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved