4Site
Support Request System
View Patch #50.021.004
Description
Patch ID:
Date Implemented:
Patch Title:
Patch Type:
Request IDs:
Bug
Enhancement
Other
01593 -
SQL 2005 passwords are case-sensitive
Symptoms:
After upgrading to SQL Server 2005, 4Site users can no longer log in to the database where a secondary login is enabled. Applications having the possibility of a secondary log in are Stores Request, Quick Picks and Receipts. This problem also applies to the 4Site database tool MkSql.
Solution:
Prior to SQL Server 2005, database passwords were not case sensitive. 4Site login modules contained code that took the user input for password and converted the input to lower case. If a user tried to log in to 4Site with a mixed case password when running under SQL Server 2005, the login would fail. The 4Site secondary login routines have been changed to remove the conversion of entered password into lower case. This problem was originally fixed in patch 50.006.008, but the secondary logins were missed. This patch completes this request.
Browse Patches
Find a Patch
Return to Request System Menu
