/
Login fails for login SQL users
Login fails for login SQL users
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.
Related articles
, multiple selections available,
Related content
Invalid column name 'ActiveLogin'
Invalid column name 'ActiveLogin'
Read with this
BookIn Activation can sometimes result in an error - "Add failed. Duplicate key value supplied"
BookIn Activation can sometimes result in an error - "Add failed. Duplicate key value supplied"
More like this
SQL Query Store
SQL Query Store
Read with this
Is there a way to 'kill' or terminate a user session?
Is there a way to 'kill' or terminate a user session?
More like this
Isolating "String or binary data would be truncated" errors
Isolating "String or binary data would be truncated" errors
More like this
Jiwa 7 Installation Guide
Jiwa 7 Installation Guide
More like this