Unable to create/update database tables. Format of the initialization string does not conform to specifications starting at index 147 error appears
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.
Solution / Workaround:
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.