Failed to login SSC after moving DB from MySQL to SQL Server

We change the database from MySql to SQL Server 2008
we already config and the database is already seed by bundle from Fortify_PCI_Basic_Seed_Bundle-2018_Q1, Fortify_Process_Seed_Bundle-2018_Q1 and Fortify_Report_Seed_Bundle-2018_Q1

the issue is happening when we try to login, using admin & pass admin is incorrect, would you help us for this issue.. is there another way to reset the password??

FYI, we've try this but still nothing happen:

UPDATE fortifyuser
SET requirePasswordChange='Y', failedLoginAttempts=0, dateFrozen=NULL, suspended='N', secPass='b0521d842e68c870af598b81aa8cd6d1728611b1e5568397e420b2d026172b74', salt='P7D4co4mI/4='
WHERE username='<admin_user>';

Thanks.

  • Verified Answer

    Hi,

    Please verify the current value for the propertyName 'user.lookup.strategy' in the table 'configproperty' using below query.
    select * from configproperty where propertyName = 'user.lookup.strategy'

    The propertyValue may be 2 (LDAP users first, fallback to local users - 2 OR LDAP users exclusive, fallback to local administrator - 3)

    If so, run below query to update the User Lookup Strategy to "Local users first, fallback to LDAP users (compatibility)"
    update configproperty set propertyValue = 1 where propertyName = 'user.lookup.strategy'

    Once this change has been performed, please run the query to reset the 'admin' user password to the default value (i.e. admin).

    UPDATE fortifyuser SET requirePasswordChange='Y', failedLoginAttempts=0, dateFrozen=NULL, suspended='N', secPass='b0521d842e68c870af598b81aa8cd6d1728611b1e5568397e420b2d026172b74', salt='P7D4co4mI/4=' WHERE userName='admin';

    Restart the Tomcat server and attempt to login to SSC (with default username and password) post these changes.

    Regards,
    Tejesh Chandra K H

  • HI,

    thanks for your advice.. now we can login onto SSC after we update the query.

    Regards,