Writing connection string manually is one of the worst things in software development. That's why I always want them to be generated by any tool but not by me. Some times before I have found a way how to generate a connection string creating an .udl file in Windows (https://markimarta.com/c/how-easily-write-the-text-of-connection-string/). Now I've found a better way.