How to Change Tally Port Configuration: ODBC Guide (2026)

By default, Tally Prime uses port 9000 to host its Open Database Connectivity (ODBC) server, which allows third-party applications (like Excel, custom sync clients, or TrulyInvoice) to communicate with it.

However, port conflicts frequently occur when another application (such as Skype, local dev environments, or printer drivers) occupies port 9000, leading to a "Connection Refused" error. In this guide, we walk through how to configure a custom port in Tally Prime and test its accessibility.

Step 1: Check Current Port Status in Tally Prime

To check if Tally's ODBC server is active and note which port it is currently listening on:

• Look at the bottom footer of your Tally Prime interface. You should see a status block indicating ODBC Server: 9000 or similar.
• If the footer displays ODBC Server: Off, the server is disabled. You must enable it in Tally settings.

Step 2: Enable and Alter ODBC Port Settings

To change the port number or enable the server:

1. Navigate to the top menu bar and click on Help (or press F1).
2. Select Settings > Startup.
3. In the Startup settings screen, locate the field named Enable ODBC Server. Ensure it is set to Yes.
4. Locate the field Port Number. Press Enter on this field to edit it.
5. Change the value from the default 9000 to another unused port, such as 9001, 9005, or 9020.
6. Press Ctrl + A to save the configuration changes.

Step 3: Restart Tally Prime

Tally Prime requires a full application restart to bind to the new port address. Close all instances of Tally Prime and open the software again. Confirm that the status bar at the bottom now displays the new port (e.g. ODBC Server: 9001).

Step 4: Verify the Port using PowerShell

To ensure Tally Prime is successfully listening on the new port without blockages from Windows Firewall:

Run the command above in Windows PowerShell. If it returns TcpTestSucceeded : True, your integration software will be able to connect to Tally Prime.