Setting up separate web and database servers

When setting up separate web and database servers, you need to make sure that the account with which you are installing, has Administrator rights on the web server as well as on the database server.

You have to specify SQL service account(s) for access to the database server from the web server. This/these account(s) must be known on the database server.

See more about specification of SQL service accounts.

Below is an example of how a Parameter file with the parameters “apiSQLServiceAccountName” and “idsSQLServiceAccountName” could look when using separate web and database servers:

{
  "installOptions": {
    "siteHost": "dviserver.local",
    "destinationFolder": "C:\\InetPub\\wwwroot\\dvi6",
    "apiSQLServiceAccountName":"SOMEDOMAIN\\SOMEACCOUNT",
    "idsSQLServiceAccountName":"SOMEDOMAIN\\ANOTHERACCOUNTORTHESAMEACCOUNT"
  },
  "apiOptions": {
    "sql:api2sql:catalog": "PLASS_ID_COMMON_TEST",
    "sql:job2sql:catalog": "PLASS_ID_JOBS_TEST",
    "sql:ids2sql:catalog": "PLASS_ID_IDENTITY_TEST",
    "sql:api2sql:dataSource": "SOMESQLSERVER\\SOMESQLINSTANCE",
    "sql:ids2sql:dataSource": "SOMESQLSERVER\\SOMESQLINSTANCE",
    "sql:job2sql:dataSource": "SOMESQLSERVER\\SOMESQLINSTANCE"
  },
  "idsOptions": {
    "sql:ids2sql:catalog": "PLASS_ID_IDENTITY_TEST",
    "sql:ids2sql:dataSource": "SOMESQLSERVER\\SOMESQLINSTANCE"
  }
}