Pesquisar nas perguntas frequentes (FAQ)

{"searchBar":{"inputPlaceholder":"Pesquisar por palavra-chave ou fazer uma pergunta","searchBtn":"Pesquisar","error":"Introduza uma palavra-chave para procurar"}}

PME 7.2.x or PME 8.0 installer fails on step "Verify databases"

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

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

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

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.

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

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.

Isto foi útil?