Below is a cheat sheet for creating SQL Server client connection strings and finding them in common configuration files. Connecting to instances by name, forcing a named pipes connection.

This connection string works fine on Windows. The intriguing part is that the following connection strings work just fine on Linux as well: Data Source=SQL_TEST,1433;Integrated Security=true; Data ...

Please note that Integrated Security=false was set in the connection string used above, as the example uses SQL Server Authentication. If Windows Authentication is used, this must be adapted. To ...

We have our SQL server configured to only allow Windows accounts (i.e. not mixed). However, in some cases we are connecting from non-domain boxes and we want to specify a domain account to connect ...