An error like the following occurs when the SQL PI installer tries to create the PI repository on SQL Server.
[ERROR] MsSqlFactory.java:123:com.dell.dsgi.spi.common.utils.sql.mssql.MsSqlFactory$1.run(): Failed to test connection with EncryptionMethod=requestSSL. Error: Cannot create PoolableConnectionFactory (Cannot open database "DBNAME" requested by the login. The login failed. ClientConnectionId:51e716ce-1228-436f-9e19-f76a992b110e)
In the SQL Server Error Log a message like the following appears interrupting the process.
Setting database option SINGLE_USER is ON for database 'DBNAME'
SQL Server database instance was configured to switch to Single user mode when while the installer attempted to create the new database.
Refer to Knowledgebase article 4226138 to add a SQL PI repository manually.
