Deploy AssetExplorer with a Standalone SQL Server
The procedure in the online documentation for configuring AssetExplorer with a separate standalone MS SQL server are incomplete, and raise many questions - they can be found here:
I was only able to get the configuration working after a support call. The key issues that were not addressed in the documentation are:
- Install AssetExplorer using the default PostgreSQL server first
- The SQL Server must be installed and ready - either on the same server, or preferably to a separate standalone server - the AssetExplorer database will be created when you run the changedbserver.bat (below)
- The SQL Server must be using SQL Authentication only - Mixed mode does not work
- The local SQL Account must be created and have DB Creator or sa permissions
- You need to have the Master Key - created by the SQL Server admin
- Run the changedbserver.bat from an administrative command prompt from:
C:\Program Files\ManageEngine\AssetExplorer\bin\changedbserver.bat
Once the changedbserver.bat was run as described here, AssetExplorer was able to work with a standalone SQL Server running on a separate Windows Sever.