Knowledge Base
Home » Main » SQL Server connection problems

SQL Server connection problems

PaperCut NG can run on an external database like SQL Server. The setup process is described in the manual here: http://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

Page last modified on February 03, 2011, at 06:40 PM

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.