A user may need to set the program name for the session when connecting to SQL Server to avoid confusion with the other program names connecting to the same SQL server instance. The program name can be set with the ApplicationName parameter in the connection properties using the TIBCO Scribe Online Connector for Microsoft SQL Server.
 

We can achieve this by using the additional parameter option- 'ApplicationName' and can provide a meaningful value to it. It sets the name of the application associated with the connection string.

Resolution Steps:

1. Below is the default program name in Microsoft SQL Server Management studio.




2. In order to have a meaningful name, edit the connection and provide the application name and save the connection.




3. Once the connection is successfully saved, the program name is renamed to the provided value.


 

This article describes how to set the program name for a session using the TIBCO Scribe Online Connector for Microsoft SQL Server.