Summary

When @ptitude Analyst and SQL Server 2019 are freshly installed on a new machine, the users may not see any errors during operations like setting the database connection, test connection, running DBUpdates etc., using the SKF @ptitude Analyst Configuration Tool. Later however when the user tries to login, they may sometimes encounter an error depending on the settings used by the user during the SQL Server 2019 installation. This article describes how to resolve that issue.

Details

On a new machine once the user installs @ptitude Analyst and SQL Server 2019, they may encounter the following error message while logging into @ptitude Analyst:

“Unable to connect to database <DATABASE_NAME>”

In this case, please follow these steps:

1. 1. 1. Open the SKF @ptitude Analyst Configuration Tool.
         
      2. Then go to ‘File->Settings’.
         
      3. Now select the ‘Specify a database tool for Configuration Tool’ option.
         
      4. Browse and select the SQLCMD.exe location from the browse button. For SQL Server 2019 it would be under:
         
         
      5. After setting this, close this popup window.
      6. Now select ‘Database Type’ on the left and set active connection.
         
      7. Then select ‘User Management’, run ‘Rebuild Users’.
      8. Finally select ‘Update Database’ and verify that the database version number is ‘9.2.0.0’ or higher. 

Now run @ptitude Analyst and enter the login credentials. The application should launch without error.

Contacting SKF Technical Support Group

For further assistance please open a support case using the Technical Support group's self-help portal at www.skf.com/cm/tsg. Once your support case is submitted, a technician will contact you to begin working on your issue. For urgent issues we are available at these times by phone:

• Monday through Friday, 5:00 a.m. to 4 p.m. Pacific Time -
  Phone: +1 800 523 7514 within the US or +1 858 496 3627 outside the US.
• Monday through Friday, 8:00 a.m. to 4:00 p.m. Central European Time -
  Phone: +46 31 337 65 00.
• Monday through Friday, 7:30 a.m. to 4:30 p.m. India Standard Time -
  Phone: +60 16 699 9506.