Do you add the Application Name in the SQL Server connection string?

Last updated by Brady Stroud [SSW] about 1 month ago.See history

You should always add the application name to the connection string so that SQL Server will know which application is connecting, and which database is used by that application. This will also allow SQL Profiler to trace individual applications which helps you monitor performance or resolve conflicts.

<add key="Connection" value="Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Biotrack01;Data Source=sheep;"/>

Bad example - The connection string without Application Name

<add key="Connection" value="Integrated Security=SSPI;Persist Security
 Info=False;Initial Catalog=Biotrack01;Data Source=sheep;
 Application Name=Biotracker"/> <!-- Good Code - Application Name is added in the connection string. -->

Good example - The connection string with Application Name

Adam Cogan
We open source. Powered by GitHub