Login fails for login SQL users

Owned by Beth Blok (Unlicensed)
Last updated: Nov 21, 2022 by Mike SheenVersion comment
1 min read

Problem

This error can be reported when attempting to login into a database that has been restored from another SQL Server.  

Solution - 7.1.x and earlier

Advanced SQL skills are required

A good knowledge of SQL Management Studio is are required to perform this task

The issue is the database is not recognising the password for SQL user JiwaLogin (or JiwaUser or JiwaReports).  Download and save the attached script to be run in stages - V7 version for databases 7.01.00 and earlier and V7-02-00 for 7.02.00 and higher.  Please review each section and the description of what is being run so you understand the process. 



Note:  If the Delete section errors, then rename the SQL users and run from the Create section onward.