An easy way to get the connection string right is to use the .udl connection string wizard
There are other articles on its use out there but this should be engough.
They say, best men are moulded out of faults,
And, for the most, become much more the better
For being a little bad.