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

Last updated by Brady Stroud [SSW] almost 3 years 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

We open source. Powered by GitHub