You create a data source name (DSN) to save database setup information, so you can open a connection to the SQL Server database without re-entering the server information.

You can use SQL to create, modify, search, and display database information.

Untangle SQL Server connection strings Today’s README file explains how to create connection strings to SQL Server databases using Visual Studio’s built-in tools.

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.