Database Login window for Crystal Reports appears when printing or previewing
Products
Sage 100
Country
North America
Description
A Database Login prompt window for Crystal Reports appears when printing or previewing a form or report in Sage 100
The user is prompted for Login ID and Password. The Server Name and Database fields also appear (disabled)
Disclaimer
Operating System Warning
This solution requires advanced knowledge of your computer’s operating system. Contact your system administrator for assistance. Modifying your Windows Registry incorrectly can severely affect system operations. Sage is not responsible for operation issues caused by incorrectly modifying your Windows Registry. Always create a backup of your data before proceeding with advanced solutions.
Sage Customer Support does not provide assistance for issues related to third party products or enhancements, hardware, report customizations, state or federal tax-related questions, or specific accounting questions. Please contact your Sage business partner, network administrator, or accountant for assistance. Please review this document for additional information on the scope of Sage Customer Support Services.
Cause
- The SOTAMAS90 DSN may be damaged or missing for the Workstation client
- Workstation software Crystal Runtimes are damaged
- The Windows account running the CS/ODBC Driver service, if being used, does not have FULL SHARE and NT Permissions under Sage 100 ERP Share
- CS/ODBC Service has been turned on in System Configuration but Sage server has not be configured to use the service or it does not exist
Resolution
- Uninstall Workstation Setup
- Remove the C:\Program Files (86)\Common Files\Sage\Common Components directory left behind (leave this directory alone if doing this at the Server)
- Reinstall Workstation Setup
- If using CS/ODBC features to increase Printing speed verify the following via Windows Services on the Server where Sage is installed
- Verify the account running the Sage 100 Client Server ODBC Driver service is a Full permissions user. Note: If running with Local System account make sure the SYSTEM account has FULL SHARE and NT (Security) permissions to be starting the Service
- Verify the service is running
- If CS/ODBC may have been turned on in Sage but not at the server by accident do the following to turn off
1. Open Library Master, Setup, System Configuration
2. Click on the ODBC Driver tab
3. Uncheck Enable for All Users
4. Uncheck Enable CS/ODBC Driver
5. Accept and exit - Open Library Master, Main, User Maintenance
- Select first user and click on the Preferences tab
- Uncheck Enable CS/ODBC Driver
- Accept and exit
- Test printing now
Note: on occasion, you may need to do the following between the Workstation uninstall and the Workstation re-install:
- Rename the pvxio.dll and pvxodbc.dll files in \windows\system32 and \windows\syswow64
Verify old Providex ODBC driver (v.4.21) is not installed
- Go to Start, Control Panel, Program and Features
- Look for ‘Providex ODBC Driver (v.4.21)’
Note: Search for and rename and versions of ‘PVXIO.dll’ under the ‘C:\Program Files (x86)\Sage Software\Providex ODBC Driver\’ folder. Test printing from Sage 100, to verify this was the cause of the issue. - If no longer using Uninstall ‘Providex ODBC Driver (v.4.21)’