Battery Analyzer Database Installation Notes
(Updated on 4/10/2021)
Three Key Things:
- Make sure the instance name is “SQLEXPRESS” when install database.
- Add users while installing SQL server express. (It is VERY difficult to add user after installation. If you are not a user for SQL, you cannot use the database. In that case, Analyzer cannot store any data to database even you run it as administrator.)
- To install Battery Analyzer software, right click “BatteryAnalyzerSetup.exe”, run as administrator.
- Manually create database
Nothing BatteryDAQ can help if you don’t have administrator access to that computer. All installation effort is wasteful if you don’t have an administrator account.
Devices (Sentry units) configuration is not saved in Database. It is a XML file named as “EquipmentConfigForClient.xml” in C:\BatteryDAQ\Analyzer folder.
For initial installation, please copy above XML file from installation CD to that folder.
For re-installation on the same computer, the previous XML file will stay in that folder so no need to re-configure after uninstall/install process.
For installation on a new computer, just copy the XML file from other computer with correct/validated configuration.
Battery Analyzer software utilizes Microsoft SQL Server express, a free version with database size limitation of 10GB, which is plenty for most battery monitoring projects.
Microsoft® SQL Server® Express
Download from Microsoft
Download Microsoft® SQL Server® 2019 Express from Official Microsoft Download Center
You may also use the copy from Battery Analyzer CD.
SQLEXPR_x64_ENU (64-bit)
Depends on which package you have downloaded from Microsoft. You may see more options.
Click “Installation”
New SQL Server stand-alone installation or add features to an existing installation.
Install
Express
Accept the license terms
Not “Default instance”. It has to be named as “SQLEXPRESS”.
Automatic for Database Engine
If you see this error, check the account name, set to NT AUTHORITY\SYSTEM.
Windows authentication mode, Add current user
Copy XML files under C:\BatteryDAQ folder. Save it to other place. Copy overwrite after re-installation of Battery Analyzer software
Install Battery Analyzer software, right click “BatteryAnalyzerSetup.exe”, run as administrator.
If you don’t run as administrator, the database cannot be created. You will see the message.
After installation, go to menu “Operation”à Add baseline. If you see any error, that says the database is not correct. You may need to uninstall all and do it again.
When it is messed up and database couldn’t be created even after reinstall SQLServer. Go to the folder to delete:
Reinstall by Run “BatteryAnalyzerSetp.exe” as administrator. You shall not see any error when create database tables.
Remember to copy “EquipmentConfigForClient.xml” to start with. In order to make change to configuration, you will also need to go C:\BatteryDAQ\Analyzer to right click “Battery Analyzer.exe” to “run as administrator”. For normal start, click quick link icon on desktop will work.
Manually Create Database
Due to too many changes to Microsoft Windows software, we must manually create database for a new installation.
- Finish SQL Express installation without error
- Finish Analyzer software installation
- With file explorer, go to C:\BatteryDAQ\Analyzer folder
- Find “CreateDatabase.bat”, double click, Y(Yes) to create database. It show create “master” and “BatteryMonitoringSystem” database with multiple rows affected, no error.
- In case any error, try cmd.
- Press ⊞ Win+S. This opens the Windows search bar.
- Type cmd. A list of results will appear.
- Right-click Command Prompt. It’s the option with a black terminal window icon.
- Click Run as administrator.
- cd.. cd.. to back to root. Then cd BatteryDAQ\Analyzer folder.
- type and run CreateDatabase.bat
- Make sure no error.
Best wishes!
If you still have trouble, install TeamViewer on this computer and contact BatteryDAQ for remote troubleshooting.