Spam Filter ISP Forums : Can't connect to DB - "again" https://www.logsat.com/spamfilter/forums/ Tue, 10 Mar 2026 11:48:40 +0000 Mon, 16 Jun 2008 06:43:24 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 11.04 360 https://www.logsat.com/spamfilter/forums/RSS_post_feed.asp?TID=6493 <![CDATA[Spam Filter ISP Forums]]> https://www.logsat.com/spamfilter/forums/forum_images/web_wiz_forums.png https://www.logsat.com/spamfilter/forums/ <![CDATA[Can't connect to DB - "again" : For the record, the issue was:...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6493&PID=12164&title=cant-connect-to-db-again#12164 Author: LogSat
Subject: 6493
Posted: 16 June 2008 at 6:43am

For the record, the issue was:
====================================
The issue is that your SQL server is not listening on the standard TCP port 1433, but rather it’s only using named pipes. The SQL Server is configured to use TCP on port 1433, but that port is actually not responding to traffic.

There is a bug in SQL Server that may cause this to happen (http://support.microsoft.com/kb/306865) and the workaround is to manually add/change the REG_SZ key below and set its value to 1433 (and restart SQL Server):
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\ [Instance Name]\MSSQLServer\SuperSocketNetLib\Tcp\TcpPort

]]> Mon, 16 Jun 2008 06:43:24 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6493&PID=12164&title=cant-connect-to-db-again#12164 <![CDATA[Can't connect to DB - "again" : If you try to telnet to port 1433...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6493&PID=12143&title=cant-connect-to-db-again#12143 Author: LogSat
Subject: 6493
Posted: 06 June 2008 at 9:55pm

If you try to telnet to port 1433 on the SQL server, you will not get a connection right now – you should instead get a connection if SQL server was listening for traffic on that port. I’m pretty sure that once you’re able to solve the SQL issue, that will take care of SpamFilter as well.
Clicking on the “test” button on the UDL file works as that will failback to using named pipes to test the connection. SpamFilter will only use TCP.

]]> Fri, 06 Jun 2008 21:55:07 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6493&PID=12143&title=cant-connect-to-db-again#12143 <![CDATA[Can't connect to DB - "again" : Not sure I understand yourquestion...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6493&PID=12142&title=cant-connect-to-db-again#12142 Author: rdemeyer
Subject: 6493
Posted: 05 June 2008 at 5:02pm

Not sure I understand your question about the dialog box.  But you are certainly welcome to access our network to get all the info you need.  Just let me know when you want to schedule it.]]> Thu, 05 Jun 2008 17:02:29 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6493&PID=12142&title=cant-connect-to-db-again#12142 <![CDATA[Can't connect to DB - "again" : Even though I think I know the...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6493&PID=12141&title=cant-connect-to-db-again#12141 Author: LogSat
Subject: 6493
Posted: 05 June 2008 at 4:19pm

Even though I think I know the answer, I have to ask.
Is the dialog box for the “Data Link Properties” what appears when, from the serer running SpamFilter, you double-click on the file “D:\Program Files\SpamFilter\Database\SpamFilterMSSQL.udl”?

If so, that is indeed strange. Is it possible for us to remote into your SpamFilter and into your SQL Server so we can have a better idea of what is happening?
]]> Thu, 05 Jun 2008 16:19:18 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6493&PID=12141&title=cant-connect-to-db-again#12141 <![CDATA[Can't connect to DB - "again" : Sent you an Email with the info. Thanks Randy...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6493&PID=12140&title=cant-connect-to-db-again#12140 Author: rdemeyer
Subject: 6493
Posted: 05 June 2008 at 3:31pm

Sent you an Email with the info.
 
Thanks
 
Randy
]]> Thu, 05 Jun 2008 15:31:49 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6493&PID=12140&title=cant-connect-to-db-again#12140 <![CDATA[Can't connect to DB - "again" : Randy, can you post (or email...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6493&PID=12139&title=cant-connect-to-db-again#12139 Author: LogSat
Subject: 6493
Posted: 04 June 2008 at 4:06pm

Randy, can you post (or email us) screenshots with the error you are receiving, or a section of SpamFilter's activity logfile showing the errors?]]> Wed, 04 Jun 2008 16:06:30 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6493&PID=12139&title=cant-connect-to-db-again#12139 <![CDATA[Can't connect to DB - "again" : We are having a repeat of a problem...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6493&PID=12138&title=cant-connect-to-db-again#12138 Author: rdemeyer
Subject: 6493
Posted: 04 June 2008 at 3:28pm

We are having a repeat of a problem I reported (and Roberto fixed) a few weeks back.  The SF Quarantine DB isn't active and I can't seem to get it to connect.  I have checked all the things we did to fix the last one, but it still keeps telling me that the SQL Server Does Not Exist or Access Denied.

In the previous incident the TCP/IP settings were missing from the DB and were added to correct the issue.  However, today they are present in the DB and I can't connect.  The SQL DB resides on a different Server than the SF software.  I have checked everything I can think of to correct this, but it just doen't want to let me connect.

Anybody have a clue?

Thanks

Randy

]]> Wed, 04 Jun 2008 15:28:06 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6493&PID=12138&title=cant-connect-to-db-again#12138