BatteryDAQ

The world leader of effective battery monitoring for any scale.

read more

Battery Analyzer Database Installation Notes

Print Friendly, PDF & Email

(Updated on 9/10/2019)

Two Key Things:

  • 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.)
  • When you run Analyzer, make sure you login your computer using administrator account.

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® 2012 Express

English Version

https://www.microsoft.com/en-us/download/details.aspx?id=29062

Spanish Version

https://www.microsoft.com/es-ES/download/details.aspx?id=29062

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”

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 “setup.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 “Setp.exe” as administrator. You shall not see any error when create database tables.

Best wishes!

If you still have trouble, install TeamViewer (non-commercial version) on this computer and contact BatteryDAQ for remote troubleshooting.