Skip to main content
Solved

Absolute Path problem when launching Database for training servers

  • Mar 17, 2022 4:32 PM UTC
  • 5 replies
  • 175 views
  • Translate All
Freshman I

Absolute Path problem when launching Database for training servers.

I cannot get my database to launch to run Accumatica. I have all IIS settings correct. I think it is a Microsoft SQL express or Windows admin permission issue

 

 

Best answer by hkabiri

@CAllaire  Please check if the folder mentioned on error exists under TemporaryAspFiles Folder and the path highlighted. If not it should be created with same name as you see on the Highlighted statement.

Also make sure the Application Pool user has Write Access to that folder.

Restart both Site and Application pool and try load the instance again.

View original

    5 replies

    hkabiri
    Acumatica Moderator
    Forum|alt.badge.img+8
    • hkabiri
    • Acumatica Support Team
    • Answer
    • Mar 17, 2022 7:51 PM UTC

    @CAllaire  Please check if the folder mentioned on error exists under TemporaryAspFiles Folder and the path highlighted. If not it should be created with same name as you see on the Highlighted statement.

    Also make sure the Application Pool user has Write Access to that folder.

    Restart both Site and Application pool and try load the instance again.

    Translate
    SAM KABIRI | L2 Support Engineer | hkabiri@acumatica.com | www.acumatica.com
      Freshman I
      • CAllaire
      • Author
      • Freshman I
      • Mar 17, 2022 8:09 PM UTC

      thanks. for some reason i cannot understand why it is being coded as temp when it is not written that way from the wizard. it is causing the site not to load.

       

      I downloaded the wizard and saved a new database on my second ssd and the site loads. but now the credentials admin and setup arent letting me log in 

      Translate
      hkabiri
      Acumatica Moderator
      Forum|alt.badge.img+8
      • hkabiri
      • Acumatica Support Team
      • Mar 17, 2022 8:13 PM UTC

      You can execute following update script against the NEW DB and password will be 123

      update PreferencesSecurity set PasswordMinLength = 3, PasswordComplexity = 0, PasswordSecurityType = 0
      update users set password = '123', PasswordChangeOnNextLogin =0, PasswordNeverExpires = 1,LastLockedOutDate=NULL,FailedPasswordAnswerAttemptCount=0,FailedPasswordAttemptWindowStart=NULL,PasswordRecoveryExpirationDate=NULL,IsApproved = 1 where source = 0

      Translate
      SAM KABIRI | L2 Support Engineer | hkabiri@acumatica.com | www.acumatica.com
        Freshman I
        • CAllaire
        • Author
        • Freshman I
        • Mar 17, 2022 8:36 PM UTC

        lol i got the database to load off of another drive lol weird how that worked haha!!

        Translate
        Freshman I
        • CAllaire
        • Author
        • Freshman I
        • Mar 17, 2022 8:38 PM UTC

        Might need to wipe and reformat my PC

        Translate
        Terms & ConditionsAccessibility statement
        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