Version

Argent AT, Argent Reports All versions

SQL Server 2008 or lower to SQL Server 2012 or SQL 2014

Date

Tuesday, 23 June 2015

Summary

When the SQL database for Argent AT or Argent Reports is migrated from SQL 2008 to SQL 2012 or SQL 2014 a customer may lose ownership of the database

The typical method of detach/copy and attach as described in the Argent KBI311059 may not work when moving from SQL Server 2008 or lower to SQL 2012 or SQL 2014

After attaching the database check the ownership

This is a known Microsoft bug

Click For Full Size

Below is a screenshot of a typical symptom in Argent Reports

Click For Full Size

Checking the log located in X:\Argent\ArgentXXX\Logs\XX_Log will show login failures for the Argent AT or Argent Reports database:

18 Jun 2015 12:49:50.452 AG-0172-W7 administrator fe80::907:d275:b324:4d07%17 *** ERROR *** Login……………….. ‘Administrator’

This is NOT an Argent issue; it is a known Microsoft SQL Server bug

Technical Background

N/A

Resolution

There are two methods to correct this known bug in Microsoft SQL Server 2012/2014

1. Run a SQL query to repair the login and default database for the Argent Service Account
   • EXEC sp_change_users_login ‘Auto_Fix’, ‘db_login1’
   • EXEC sp_change_users_login ‘database_name’
2. Create new database and import data from old database
   • Create a new database
   • Import data
   • Follow Argent KBI311059 to connect the new database to Argent AT

How To Create New Database And Move Data From SQL Server 2008 To SQL 2012 Or SQL 2014

1. Stop all Argent Services
2. Create a new database



Click For Full Size
3. Right-click on database, select “Task”, then select “Import Data”



Click For Full Size
4. Follow the SQL Server Import Export Wizard to import data from old SQL database



Click For Full Size



Click For Full Size

Select source




Click For Full Size






5. Start all Argent Services and verify all reports are available and that all Relators are running properly