Change the account of the PI Vision database

If you change the AVEVA PI Vision application pool ID after the AVEVA PI Vision database has been created and you use Windows Integrated Security for the PI Vision web services to connect to the AVEVA PI Vision SQL database, then you must create a SQL Server login for the account and alter the account used to access the AVEVA PI Vision database.

To perform these changes, you must have the database permissions ALTER ANY USER and CONTROL.

To create a SQL Server login for the account, use SQL Server Management Studio or run the following SQL command:

CREATE LOGIN "<domain>\<Application Pool ID>" FROM WINDOWS

To alter the account used to access the AVEVA PI Vision database, run the following SQL commands:

ALTER USER "DVService" with
LOGIN="<domain>\<Application Pool ID>"
ALTER USER "<domain>\<Application Pool ID>" with
NAME="DVService"

Note: If you want to change the authentication method or account used for PI Vision web services to connect to the PI Vision SQL database and you are not using Windows Integrated Security for this connection, refer to Add permissions to the PI Vision database for web services.