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