Error:
'Error With Provider Portal Account Registration
String or Binary data would be truncated in table 'providerportal_live.dbo.users, column 'password'. truncated value: 'xxxxxx'
This statement has been terminated'
This error is usually caused by passwords in the database becoming longer than 10 characters. Due to the encryption process, some characters are changed on a greater than 1:1 basis. So, even if the password you provided is 10 characters or fewer, encryption will make it longer in the database.
Try using a different password and ensure you do not use special characters. This should resolve the issue.