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 ...

When creating automation scripts to discover, add, update or remove records from a remote SQL database, you need to make sure your script can successfully connect to the database.

The next step is to create an SQL subkernel with the SQL connection string in a C# cell: #!connect mssql --kernel-name DemoKernel @csharp:connectionString ...