Power Monitoring Expert - When doing a standalone PME install, the PME installer is unable to find an existing SQL instance and wants to install SQL Express
Issue
When trying to install Power Monitoring Expert 8.x/9.0 on a standalone server on which SQL Server has already been installed, the PME installer is not able to find this existing SQL Server instance and the only option given is to install SQL Express. SQL Server is clearly installed, and the SQL Server and SQL Browser services are both running.
Product Line
Power Monitoring Expert 8.x
Power Monitoring Expert 9.0
Environment
A new PME install on a standalone server. SQL Server has already been installed as per the System Guide.
Cause
The PME installer queries the system to find a list of existing SQL Server instances. It imposes a 100 second timeout. If it takes longer than 100 seconds to obtain this list of SQL Server instances, the installer will advance to the screen that tells the user no SQL Server instances were found and offers to install SQL Server Express. This timeout setting is contained in one of the xml broker files.
Resolution
*Warning: Take backups of any files prior to modifying them. Ensure the backups are in a location that will not be overwritten (i.e. the Desktop).
This problem can be worked around by editing one of the broker files to increase the timeout setting. In order to do this, the PME iso must be unpacked. The file in question is in the 'setup' directory and is called 'broker.xml'. Note that the timeout setting is in milliseconds.
Find this section:
<BrokerRequest Name="GetSqlInstanceList">
<Request Name="GetSQLServerList" EstTime="500" TimeOut="100000" UIName="#determinesqledition" ActionOnFail="Stop">
<Method>
<GetServerListEnumDelim Library="DatabaseUtilities" Class="Installer.InstallTools.ConfigureSQL">
<includeInstance>true</includeInstance>
</GetServerListEnumDelim>
</Method>
</Request>
Change the TimeOut setting from 100000 to 600000. The edited section of the file should look like this:
<BrokerRequest Name="GetSqlInstanceList">
<Request Name="GetSQLServerList" EstTime="500" TimeOut="600000" UIName="#determinesqledition" ActionOnFail="Stop">
<Method>
<GetServerListEnumDelim Library="DatabaseUtilities" Class="Installer.InstallTools.ConfigureSQL">
<includeInstance>true</includeInstance>
</GetServerListEnumDelim>
</Method>
</Request>
After editing the file, save it, and then rerun the installer. Be sure to choose 'Restart' not 'Resume'
Additional Note
The timeout value will be increased for the next PME release.
When trying to install Power Monitoring Expert 8.x/9.0 on a standalone server on which SQL Server has already been installed, the PME installer is not able to find this existing SQL Server instance and the only option given is to install SQL Express. SQL Server is clearly installed, and the SQL Server and SQL Browser services are both running.
Product Line
Power Monitoring Expert 8.x
Power Monitoring Expert 9.0
Environment
A new PME install on a standalone server. SQL Server has already been installed as per the System Guide.
Cause
The PME installer queries the system to find a list of existing SQL Server instances. It imposes a 100 second timeout. If it takes longer than 100 seconds to obtain this list of SQL Server instances, the installer will advance to the screen that tells the user no SQL Server instances were found and offers to install SQL Server Express. This timeout setting is contained in one of the xml broker files.
Resolution
*Warning: Take backups of any files prior to modifying them. Ensure the backups are in a location that will not be overwritten (i.e. the Desktop).
This problem can be worked around by editing one of the broker files to increase the timeout setting. In order to do this, the PME iso must be unpacked. The file in question is in the 'setup' directory and is called 'broker.xml'. Note that the timeout setting is in milliseconds.
Find this section:
<BrokerRequest Name="GetSqlInstanceList">
<Request Name="GetSQLServerList" EstTime="500" TimeOut="100000" UIName="#determinesqledition" ActionOnFail="Stop">
<Method>
<GetServerListEnumDelim Library="DatabaseUtilities" Class="Installer.InstallTools.ConfigureSQL">
<includeInstance>true</includeInstance>
</GetServerListEnumDelim>
</Method>
</Request>
Change the TimeOut setting from 100000 to 600000. The edited section of the file should look like this:
<BrokerRequest Name="GetSqlInstanceList">
<Request Name="GetSQLServerList" EstTime="500" TimeOut="600000" UIName="#determinesqledition" ActionOnFail="Stop">
<Method>
<GetServerListEnumDelim Library="DatabaseUtilities" Class="Installer.InstallTools.ConfigureSQL">
<includeInstance>true</includeInstance>
</GetServerListEnumDelim>
</Method>
</Request>
After editing the file, save it, and then rerun the installer. Be sure to choose 'Restart' not 'Resume'
Additional Note
The timeout value will be increased for the next PME release.
Publié pour: Schneider Electric Belgium
Besoin d'aide ?
Sélectionnez le bon produit
Trouvez rapidement et facilement les produits et accessoires adaptés à vos applications.
Obtenir un devis
Effectuez une demande de renseignements en ligne et un expert vous contactera.
Où acheter ?
Trouvez facilement le distributeur Schneider Electric local le plus proche.
Centre d'aide
Trouvez des ressources de support pour tous vos besoins, en un seul endroit.