Navigate
Wasp Helpdesk
  • Register

  • or
  • Login
    Need a password reminder?
or
Contact Us
  • Get in touch

    Send us an email

  • Start a chat session

  • Knowledgebase Read help articles
  • News News & updates
  • Contact Us We are here to help
  • Training View our options
  • Product Sunsets Non-Supported Products
Barcode System Consult
Barcode Printer Consult
Barcode Label Consult
  • Portal
  • Knowledgebase
  • Software
  • Custom SQL passwords for InventoryControl and MobileAsset
Subscribe Download PDF

Custom SQL passwords for InventoryControl and MobileAsset

Scott Leonard
2019-02-19
in Software
This article discusses SQL account usage and password changes needed when a user wants to use their own custom passwords for the SQL accounts used by InventoryControl (IC) or MobileAsset (MA).
 
The SQL account sa is used when:
1. Creating or patching the database. The EnterpriseDBInstaller utilities can be used to specify the custom password.
2. Managing MobileAsset databases with the Database Manager utility. A custom password can be specified here.
 
The SQL accounts InventoryUser (IC only) and AssetUser (MA only) are used for communication between the SQL database and the PC Clients, and the Windows Service for each application.
 
The SQL accounts InventoryReader (IC only) and AssetReader (MA only) are used by the ODBC connection used by Labeler, and by the Crystal Reports viewer (for running reports).
 
InventoryControl:
1. PC Client registry needs DatabasePassword updated with encrypted InventoryUser password
2. SQL accounts (InventoryUser, InventoryReader) need new passwords set
3. ODBC connection needs InventoryReader password
4. Wasp Inventory Windows Service needs the InventoryUser password entered, and the service restarted. Use the "Change Configuration Settings.exe" utility in the Services folder. This service handles mobile device communication.
5. InventoryControl Web needs encrypted password updated in web.config file.
 
MobileAsset:
1. PC Client registry needs DatabasePassword updated with encrypted AssetUser password
2. SQL accounts (AssetUser, AssetReader) need new passwords set
3. ODBC connection needs AssetReader password
4. Wasp MobileAsset Windows Service needs the AssetUser password entered, and the service restarted. Administration on left, Service Configuration on right. This service handles mobile device communication. This password is stored in the MobileAssetWindowsService.exe.config file in cleartext.
5. MobileAsset Web needs AssetUser password updated in web.config file, in cleartext. Leave the $$ characters intact; they are not part of the password.
6. SQL database WaspConfig, Tables, dbo.application_databases:
column db_update_password: encrypted AssetUser password
column db_read_password: encrypted AssetReader password
 
If you need to use custom passwords, Wasp Tech Support will need your desired passwords so we can generate and send you the corresponding encrypted passwords. The maximum number of characters for each password is 20.

Rate the quality of this page

This page was helpful :) :( This page was not helpful

27 of 40 people found this page helpful


Quick Jump
  • Wasp Helpdesk
  • Knowledgebase
  • News
  • Contact Us
Top
Helpdesk software provided by Deskpro