Adding Connection String to Resubmission with DB on Server
- Anup Kumar
Pre-Requisite
Resubmission Server Application installed, and Resubmission Database on the SQL Server.
Access to DB server from your PC with Resubmission client via port 1433(SQL Connection Port)
Steps to follow to connect Resubmission Client to DB
Step 1: Click Start >> Type Greenrain Resubmission in search
Step 2: Greenrain Resubmission application will show up in the list.
Step 3: Click to launch Greenrain Resubmission Client application on your PC.
Step 4: Click Tools >> Click Settings (from the dropdown).
Step 5: Click Database tab from the top menu of “Greenrain Resubmission Settings” window
Step 6: Select Central database (multi-user mode) and then click Configure Database Connection
Clicking the configure database connection will open the “Connection String Wizard” window
Step 7: Enter the following to the Connection String Wizard window:
>> Database Type: Microsoft SQL Server (By default it will be selected)
>>Server Name: tcp:Server IP Address
(for example, if the IP address is 111.222.33.445, this should be filled as tcp:111.222.33.445)
>>Authorization: SQL Server Authentication
>> Login: SQL User login (Should have access to the Resubmission Database)
>> Password: SQL User Password
>> Database: Resubmission_Database (Select the Resubmission Database from the dropdown)
Step 8: After entering all the details, click Test Connection button, then click Ok.
Step 9: Resubmission Connection string is configured and added to Resubmission Settings. Click Ok.
Step 10: Now you can search the downloaded transactions in the Resubmission client app using the search filters.
