AnsweredAssumed Answered

Cannot run PI SQL DAS (Integrator) service during installation

Question asked by AAB1 on Nov 12, 2020
Latest reply on Nov 17, 2020 by AAB1

Hi Guys,

 

Have an installation issue with PI SQL Data Access Server for PI BA Integrator.

There was no request for the installation path for PI Integrator for BA therefore all apps been installed by default on C:\ drive and it was required to move them to E:\.

After uninstalling existing PI BA, correcting PIPC.ini, Environment Variables and Regedit path and running new installation process I have an issue with PI SQL DAS component: As a last step of installation process there is a necessity to run the PI SQL DAS service which gives an error 1920  - insufficient privileges to start system service.

As the PI SQL DAS service could not be started there is a rollback process which removes all the SQLDAS folders and service itself.
What was checked:

1. Virtual service account PISqlDas.Integrator is a member of "Log on as a service" in Local Computer Policy, I even added it to local Admins group as one of the last actions;

2. Tried to run PI SQL DAS separately and replace Service Log On user during installation as described in article below.

https://customers.osisoft.com/s/knowledgearticle?knowledgeArticleUrl=000030346 

The account used was domain svc account, running PI Integrator for BA services and a member of Local Admins and "Log on as a service" in Local Computer Policy.

3. Tried to reinstall all components of PI Integrator for BA.

4. Run installation as administrator. My personal domain account usually running installation is a member of local Admins group.

 

All other PI BA integrator components have been successfully installed. Connection to SQL Server and DBs is healthy.

This VM is dedicated for PI Integrator for BA only. No other PI SQL DAS services except this one.

++++++++++++++++++++++++

A piece of log file with error.

 

Looking up sid for username 'NT SERVICE\PISqlDas.Integrator'
Found sid 'S-1-5-80-3208607258-3635334641-884083537-656761469-1448334296'; adding urlacl for url 'https://+:5461/PIIntegrator/'
MSI (s) (E0:BC) [22:37:55:386]: Executing op: ActionStart(Name=StartServices,Description=Starting services,Template=Service: [1])
Calculated SDDL: D:(A;;GX;;;S-1-5-80-3208607258-3635334641-884083537-656761469-1448334296)
MSI (s) (E0:BC) [22:37:55:386]: Executing op: ProgressTotal(Total=1,Type=1,ByteEquivalent=1300000)
MSI (s) (E0:BC) [22:37:55:386]: Executing op: ServiceControl(,Name=PISqlDas.Integrator,Action=1,Wait=1,)
MSI (s) (E0:BC) [22:42:06:382]: Product: PI SQL Data Access Server (PI Integrator Framework) 2018 SP2 -- Error 1920. Service 'PI SQL Data Access Server (PI Integrator Framework)' (PISqlDas.Integrator) failed to start. Verify that you have sufficient privileges to start system services.

Error 1920. Service 'PI SQL Data Access Server (PI Integrator Framework)' (PISqlDas.Integrator) failed to start. Verify that you have sufficient privileges to start system services.

Outcomes