- \n
- Paribus 365™ Data Cleansing<\/li>\n
- Microsoft Dynamics 365 CRM<\/li>\n
- Infor CRM SLX (Saleslogix)<\/li>\n<\/ul>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
<\/p>\n
Issue Outline<\/h2>\n
There was an issue when logging into Paribus 365™ Data Cleansing using Microsoft SQL Server 2005 as the Control Database, where you get an error (similar to the one shown below) even when you have the correct username and password.<\/p>\n
![\"\"](\"https:\/\/www.qgate.co.uk\/knowledge\/wp-content\/uploads\/2013\/09\/cf2f17d4-1c7d-43f3-aecb-3d9b2d201d99-001.jpg\")
<\/p>\nThis issue has been resolved in Paribus 365™ Data Cleansing version 1.3.3. This article provides a work-around that can be used for those on versions prior to version 1.3.3.<\/p>\n
Cause of the issue<\/h3>\n
The cause of the issue is due to the way that previous versions of Paribus Discovery made connections to Microsoft SQL Server databases.<\/p>\n
Microsoft SQL Server versions prior to 2005 were not Case-Sensitive when authenticating users, thus earlier versions of Paribus Discovery did not need to factor this into the authentication process.<\/p>\n
Microsoft SQL Server 2005 is however Case-Sensitive, so if the SQL account being used is lower-case (\u201cparabus_user<\/b>\u201d, for example); when Paribus coverts to UPPER-CASE, SQL Server will always reject the connection attempt.<\/p>\n
Workaround \/ Solution<\/h3>\n
As mentioned previously, this issue has now been resolved in Paribus Discovery version 1.3.3, so we would recommend upgrading to the latest version.<\/p>\n
To work-around this issue with the current version of Paribus Discovery, you can do the following:<\/p>\n
- \n
- Follow the steps provided in the related article \u201cDatabase user permissions required to use Paribus 365 Data Cleansing<\/a>\u201d, which will show you how to create a new SQL login account for Paribus, but\u2026<\/li>\n
- When you get to the section: \u201cCreate a new database login<\/b>\u201d, BOTH the Login name and Password must be all in UPPER-CASE. The User Name and Password may be alpha-numeric, but all characters must be CAPITALS.<\/li>\n<\/ul>\n
NOTE<\/strong>: If you have already created a dedicated SQL login for Paribus 365, you could simply rename the account to be in UPPER-CASE and like-wise for the account password.
\n<\/p>\n - When you get to the section: \u201cCreate a new database login<\/b>\u201d, BOTH the Login name and Password must be all in UPPER-CASE. The User Name and Password may be alpha-numeric, but all characters must be CAPITALS.<\/li>\n<\/ul>\n
- Follow the steps provided in the related article \u201cDatabase user permissions required to use Paribus 365 Data Cleansing<\/a>\u201d, which will show you how to create a new SQL login account for Paribus, but\u2026<\/li>\n