Answer by Amadeusz Liu is correct. I create a Dataset. Visual Studio randomly creates a new SQL connection string. I drop out of Visual Studio, edit the .VSD file with Notepad and change the incorrect connection string reference to my desired one. Go back into Visual Studio and it all works file. One SQL connection string only for the entire project.