To find out which SQL Server database CashFootprint is connected to, open CashFootprint, go to the Tools menu, select Options.
The server name and database are listed on the Data Source tab. See attached for a screen shot.
The server name can have two parts: the server's computer name and the instance name. An instance name is a unique name given to a specific instance of the SQL Server software running on the server computer.
In the following example the red text is the server's computer name and the blue text is the name of the instance of SQL Server running on that server computer.
CFOOTW7\CASHFOOTPRINT