PVS configuration wizard failed to add domain\users service account into database automatically:<The EXECUTE permission was denied on the object 'uspGetServerSettings

PVS configuration wizard failed to add domain\users service account into database automatically:<The EXECUTE permission was denied on the object 'uspGetServerSettings

book

Article ID: CTX235869

calendar_today

Updated On:

Description

PVS configuration wizard fails to add domain\users service account into database automatically.<The EXECUTE permission was denied on the object 'uspGetServerSettings' or System.Data.SqlClient.SqlException (0x80131904): Windows NT user or group 'domain\username' not found in CDF trace.  No error is reported after the configuration wizard process is finished, but user fails to open pvs console. Adding the service account into DB mannually can solve the issue .

Resolution

Discard top-level domainname when running PVS configuration to change service account of stream service and soap service
for example:
Domainname->xxx.com and user1
Use xxx as Domain and user1 as user name
User-added image

 

Problem Cause

PVS_Dll_MPI_AO try to add yd.local\svc into database but failed to identify the format of username, so add operation failed. But SQL native Client try to use yd\svc to connect to database which result in the failure