Acumatica – Tips, Tricks and Components
With an industry reputation in delivering cutting edge development and integration solutions, Greytrix brings a complete pool of services for Acumatica, a cloud ERP, ranging from development, customization, and integration with third-party apps. Through these blogs we aim to highlight landmark developments, share our expertise and knowledge on current technology trends for you to get the best of Acumatica practices. Contact Greytrix Certified Specialists Team at acumatica@greytrix.com. Greytrix is a leading Sage Development partner since 22+ years across verticals and industries. Using this experience, it has Using our home connector GUMU™ we develop system integrations for Acumatica.
Skip to content
  • Home

Acumatica – Login failed for user

By greytrix | March 11, 2022
0 Comment

Acumatica ERP allows us to connect database server using Windows Authentication as well as SQL Server Authentication. When we connect using SQL server method, we need to make sure that selected login user has sufficient rights to update the database; but when we use Windows authentication, we do not have those features/options.

In this blog, we will be looking into one of the resolutions for the error that occurs when we choose windows authentication and try to access the Acumatica ERP website from our local IIS.
Error: – “Login Failed for user ‘IIS APPPOOL\apppoolname”.

Cannot open database

Steps to resolve the error:

  1. Open IIS (1) and select the Application Pool assigned to your ERP instance.
  2. Right-click on Application Pool (2) and select Advanced Settings (3) OR click on Advanced Settings (3) from the Actions section.

Cannot open database 1

3. Once the Advanced Settings dialog box is opened, navigate to Identity property (1) and browse its values to change it from ApplicationPoolIdentity to Custom

Cannot open database 2

4. Select Custom account (1) and click on Set button (2).

Cannot open database 3

5. Enter the system Username, Password, and Confirm Password on Set Credentials dialog and click OK.
6. Recycle your application pool and restart the IIS. This step is optional and only required if the changed are not reflected.
7. Now, we can browse/Launch our ERP instance without the error of login failure.

Note: If the credentials of the entered user are changed, then it needs to be updated here as well.

This is how we can overcome the error when an Acumatica ERP instance is connected using Windows Authentication.

Greytrix, with its 22+ years of expertise as the Sage Development partner, extends its mastery to bring Acumatica to modern businesses. Greytrix offers complete end-to-end professional services for Acumatica, ranging from development, support, technical assistance, consulting, and system integrations.

Related Posts

  • Multiple Controls Types in a Grid in the Acumatica Test SDK
Category: Acumatica ERP Tags: Acumatica, Acumatica ERP, Cannot Open database, Identity Property, Login Failed for user
Post navigation
← Multiple Controls Types in a Grid in the Acumatica Test SDK Automate Schedule in Acumatica →

Categories

  • Acumatica
  • Acumatica Customization
  • Acumatica ERP
  • Acumatica Product
  • Acumatica Services
  • Greytrix Event
  • GUMU Integration
  • Uncategorized

Greytrix Websites and Blogs

  • Greytrix
  • Greytrix Africa
  • Greytrix Australia
  • Sage X3 – Tips, Tricks and Components
  • Sage 100 & 500 ERP Tips and Tricks
  • Sage CRM – Tips, Tricks and Components
  • Salesforce.com Tips and Tricks by Greytrix
  • Sage Intacct– Tips, Tricks and Components

Recent Posts

  •              WebHook Configuration in Acumatica.
  • How to assign a business account to user in Acumatica?
  • How to create custom week in Acumatica
  • Date Formats in Acumatica
  • Using a custom SQL view in Acumatica Report
Copyright 2022
Acumatica – Tips, Tricks and Components
Iconic One Theme | Powered by Wordpress