This is a fresh install of DevTest 10.5 on Windows 2016, with local SQL 2016.
The problem is the following: Customer doesn't want to provide dbo authority to "our" db users. When we run the 10.1 installation we created the DBs manually, then we imported the DDLs provided with the product to create the schema, we created users with datareader and datawriter permissions, we configured .properties files and everything worked as expected.
Tried the same with release 10.5, so I created 3 DBs (iamdb, lisadb and dradisdb), 3 users (iamusr, lisausr and dradisusr) and these three users have datareader and datawriter permissions on "their" databases.
Then imported the DDLs from sa user (one DDL for IAMDB, one for DRADISDB and two for LISADB).
Configured the .properties files and:
1) Started IAM service ==> OK
2) Started Enterprise Dashboard Service ==> Ok
3) Started Registry service ==> IT FAILS.
In a nutshell Registry service tries to create a table (LISA_TEMP_TABLE1__) but obviously it fails.
On local machine tried adding the ddladmin authority to lisausr (not to the other users) and then it works, if user has ddladmin authority there is no need to import the DDLs.
Release : 10.5
Component : CA Service Virtualization