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

[nurul]

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.

[Tejesh Chandra · Accepted solution]

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

[nurul]

HI,

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

Regards,