Applies to InventoryControl, MobileAsset, WaspTime
Symptom
When you attempt to run a report, you receive a prompt:
Database Login
Server Name: <server>
Database: <blank>
Login ID: WaspReader
Password: ********
Clicking the Finish button gives a Login Failed message.
Note: The Login ID might be different, such as TimeUser or AssetReader.
Possible Cause 1
The SQL Native Client is not installed or corrupted.
Solution 1
In Programs and Features, if "Microsoft SQL Server Native Client" is listed, right-click and uninstall it.
Rerun the SQL Native Client installer from the installation disc. Alternately, the installer can be downloaded here:
64-bit Windows: https://dl.waspbarcode.com/wasp/supportfiles/sqlncli_x64.zip
32-bit Windows: https://dl.waspbarcode.com/wasp/supportfiles/sqlncli.zip
Possible Cause 2
TLS 1.0 has been disabled on the database PC and/or the workstation running the report.
Solution 2
On any affected PC, follow the resolution in the article "Multiple Products: SQL Server service will not start, error code -2146893007" which is linked below in Related Pages.