It looks like you are having issue with ODBC drivers on machine…
You can use connection string in below format.
Data Source=YouDBServerName;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;
And in provider name property of connect activity use System.Data.OLEDB and if still does not work then use System.data.SQLClient
