MS SQL Connection String Format

Oddly I am having to use Remote SQL rather than Local as the option doesn’t appear in the list of services.