Open U T190 question

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

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.

@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/

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
------------------------------
 

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.

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

Where are you stuck? Can you share a screenshot?

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.)

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?

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

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

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

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

2. 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)

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.

Ok thank you Gabriel, will do.

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.