• Connecting to Linked Server (External SQL Database)

    Hello all, After many attempts and support of Aras Support, we are still unable to execute SQL Stored Procedures on an external SQL database. Context Aras Innovator Version 26 SQL Server 2017 Goal Execute a Stored Procedure on an external…
  • Date issue, user date selected different from date in DB

    Why the date selected by user in aras form is different from the date in database?
  • Commit the transaction half way through the code and continue the execution from there.

    Hi Team, We have a scenario where we want to commit the transaction half way through the code and continue the execution from there. For example : 1. We are working on Background tasks implementation 2. Where we want to change the status [property…
  • Login failed for user 'innovator' - MSSQL

    I actually found a locked thread that answers this after 20 or so comments. No answer is marked as accepted. There are other very similar threads. None have a screenshot to tell the story of what to do. It ends up I had to enable mixed mode auth for the…