This was a while ago but pretty sure I changed it from setting the full connection string to just set the servername property. I don't work at the place anymore so can't check for you but pretty sure that's what I did.