we are implementing a database firewall on Oracle based on a unique value associated to a given application. With this value, we can reliably identify the application, even if one changes the name of the application before connecting to the RDBMS.
We plan on doing the same thing with SQL Server.
I've already seen that there is a connection_id column in sys.dm_exec_connections, but it identifies a connection, not an application.
In SQL Server, iIs there something, that could reliably identify an application ?
Best Answer
The only way I can think of is, using "Application Name" in the connection string. That is how SQL server recognises different applications.
I think, you can append application name in the connection string at runtime using your v$session column.