SQL Server connection problems

KB Home   |   SQL Server connection problems

PaperCut can run on an external database like SQL Server. The setup process is described in the manual here: https://www.papercut.com/products/ng/manual/ch-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.

Categories: Databases

Comments

Share your findings and experience with other PaperCut users. Feel free to add comments and suggestions about this Knowledge Base article. Please don't use this for support requests.

Article last modified on March 29, 2012, at 10:01 PM
Printable View   |   Article History   |   Edit Article