{}

Nos marques

Bienvenue sur le site Web de Schneider Electric

Bienvenue sur notre site Web.
Consulter notre FAQ
PME 7.2.x or PME 8.0 installer fails on step "Verify databases"
Issue
When upgrading SPM 7.0.1 to PME 7.2.2 or PME 8.0...the installer fails on step "Verify Databases" with the message "The ION_Network table was not upgraded" or "An error has occurred during the ION_Network database deployment"
When opening the ION_Network.log ( located in the <install directory>\diagnostic folder), at the bottom of the file the error message reads:
"You do not have permission to use the bulk load statement"

Product Line
PME 7.2.2
PME 8.0

Environment
Upgrade to PME 7.2.2 from SPM 7.0.1
Upgrade to PME 8.0 from PME 7.2.2

Cause
The "ION" sql account does not have "sysadmin" privileges

Resolution
To provide sysadmin privileges to the "ION" Sql account, follow the below steps:
1. Open SQL Server Management Studio and log in to the instance of SQL being used by PME 7.2.x or PME 8.0, using the appropriate administrator credentials.

SQL Login

2. Expand the instance of SQL being used and the folder "security" followed by the folder "Logins"

SQL Server Login

3. Right click on the user "ION" and select "properties"
4. Click on the tab "server roles" and select the checkbox for "sysadmin"
5. Click "ok" on the login properties window and rerun the installer.

Schneider Electric Belgium

En savoir plus
Gamme :
Articles utiles
En savoir plus
Gamme :