The below error can occur in Ektron 9.1 when a password is longer than 10 characters.
ERROR! Failed to run C:\Program Files (x86)\Ektron\Search2.0\Backup\DBScripts\SetSolrConfiguration.sql against the database! String or binary data would be truncated.
The statement has been terminated.
To avoid this error, upgrade to 9.2 or higher of Solr. As a workaround, use less than 10 characters for the Solr SQL user.