Knowledgebase
Knowledgebase: PaperCut > Databases
SQL Server connection problems
Last modified on 11 August 2020 01:07 PM

PaperCut can run on an external database like SQL Server. The setup process is described in the manual here: https://www.apms.com.hk/product/ng-mf/manual/common/topics/ext-db.html

If you receive errors like the following when you try to connect to the SQL Server database, this indicates that PaperCut cannot connect to the SQL Server TCP/IP port.

    Network error: IOException: Connection refused: connect

The most common causes for this error are:

  • SQL Server is not configured to use TCP/IP, or the standard port (1433) is not being used.
  • The connection to the server is being blocked by a firewall, or there is some other network connectivity issue.

To check that you can connect to the SQL Server port from the PaperCut server, open a command prompt (cmd.exe) and try the following command:

   telnet sqlservername 1433 

If this fails, then it’s likely that you are encountering one of the above problems.

To check if TCP/IP is enabled in SQL Server, you can do use the SQL Surface Area tool. Start → Programs → Microsoft SQL Server 2005 → Configuration Tools → SQL Server Surface Area Configuration → Configuration for Services and Connections → Remote Connections.