Do you add the Application Name in the SQL Server connection string?
Last updated by Brady Stroud [SSW] 7 months ago.See historyYou 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