Tweet
Another error occurs when an attempt to install includes a non-standard port of MSSQSL.
While testing the connection to the database works, the installer fails later.
We found out that if you have a MSSQL Server that uses a custom ports, for example 7745 and you do not include it
in the connection string, then you will not be able to complete the installation.
For example, if you connect string is: WIN-U8OURMSSQL4, 7745
But, you only specify WIN-U8OURMSSQL4 (without the comma and port number) then
if you press the Test Connection, you may get "Successful Tested" msg, but if you continue the installation it will fail to create the database.
The Error code that will flag this issue is: -2147467259
Error -2147467259: failed to ... Create the SQL database:
WBRMBackupScheduler, error details: Cannot Add the
database'WBRMBackupScheduler',
While testing the connection to the database works, the installer fails later.
We found out that if you have a MSSQL Server that uses a custom ports, for example 7745 and you do not include it
in the connection string, then you will not be able to complete the installation.
For example, if you connect string is: WIN-U8OURMSSQL4, 7745
But, you only specify WIN-U8OURMSSQL4 (without the comma and port number) then
if you press the Test Connection, you may get "Successful Tested" msg, but if you continue the installation it will fail to create the database.
The Error code that will flag this issue is: -2147467259
Error -2147467259: failed to ... Create the SQL database:
WBRMBackupScheduler, error details: Cannot Add the
database'WBRMBackupScheduler',