Unable to create/update database tables. Format of the initialization string does not conform to specifications starting at index 147 error appears
There are two possibilities for receiving this error message:
1. Extra spaces in the database connection settings window. SA username has extra spaces entered which causes the error to occur but a test connection will be successful.
2. Special character in the connection password such as a single quote, double quote, or a semi-colon.
Solution / Workaround:
1. Even though the test connection worked, the actual update statement will fail. Remove the extra spaces from the "Verify or Enter Connection Details" window or completely clear that window and re-enter the connection information.
2. Utilize a connection password that does not contain special characters.