SQL Dialog Upgrade Workaround

[DavidU54339-XRX]

During upgrade from Core 4.x to Core 5.1 the values of the database Connection dialog may not populate correctly causing database validation to fail. To remedy this issue, manually reenter the values using the same values from previous installs.  If the previous values are not know, they can be retrieved using the SQL Server Management Studio log on dialog.

To retrieve the values, launch SQL Server Management Studio.  Observe the values on the log on dialog and use those value to populate the installer dialog.

Example 1: SQL Server configured for Windows Authentication.

SQL Management Studio	Installer Screen	Values To Use For Installer
Server name:	Database Server Name:	Toby
Server name:	Database Instance ID:	SQLEXPRESS
Authentication:	Check this box to …	Windows Authentication = Check the box.
User name:	SQL System Administrator:	TOBY\Jimmy
Password:	Password:	Leave blank.

Example 2: SQL Server configured for SQL Server Authentication

SQL Management Studio	Installer Screen	Values To Use For Installer
Server name:	Database Server Name:	SERVERONE
Server name:	Database Instance ID:	FREEFLOWCORE
Authentication:	Check this box to …	SQL Server Authentication =        Leave the box not checked.
User name:	SQL System Administrator:	sa
Password:	Password:	Your password goes here.

[DavidU54339-XRX]

During upgrade from Core 4.x to Core 5.1 the values of the database Connection dialog may not populate correctly causing database validation to fail. To remedy this issue, manually reenter the values using the same values from previous installs.  If the previous values are not know, they can be retrieved using the SQL Server Management Studio log on dialog. See full procedure in attachment.