SQL Server connection problems

KB Home   |   SQL Server connection problems

Main.SQLServerIssues History

Hide minor edits - Show changes to output

Changed lines 3-4 from:
PaperCut NG 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]].
to:
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]].
Changed line 24 from:
''Categories:'' [[!Databases]], [[!PaperCutNG]]
to:
''Categories:'' [[!Databases]]
Changed lines 22-24 from:
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.
to:
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]], [[!PaperCutNG]]
Added lines 1-22:
(:title 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://papercut.biz/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.

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