cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
FreeFlow Production Workflow Moderator DavidU54339-XRX
FreeFlow Production Workflow Moderator

SQL Dialog Upgrade Workaround

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.

0 Kudos
1 Reply
FreeFlow Production Workflow Moderator DavidU54339-XRX
FreeFlow Production Workflow Moderator

Re: SQL Dialog Upgrade Workaround

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.

SQL0.png

 

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

SQL1.png

 

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.

 

0 Kudos