DOC 1 Designer and Engage One Designer - How to Manually setup Designers SQL connection


If you want to change the account credentials that are used to connect the Designer Application Server (busobjService) to the SQL server then here are the steps:

  1. Setup a new user and password in MS SQL and give the user 'DBCreator' permissions
  2. Make the new user the 'dbowner' of the Doc1Repository
  3. On the application server, locate the serversetup.exe file (Default location:  C:\Program Files (x86)\PBBI CCM\DOC1\Designer\Server)
  4. Open the command prompt and change directory to the location of serversetup.exe
  5. Run the following command, substituting the 'DB Username' and 'DB User password' with the correct values used earlier
    • ServerSetup.exe /ccf /du <DB Username> /dp <DB User password>
  6. Once done, open the computer services and restart the 'BusobjService' to make the changes take effect.
UPDATED:  March 28, 2017