Problem with database connection to SqlServer 2005

Bru · Post by **Bru** » 16 Mar 2007, 13:51

Hi, we are trying to connect to a SQLServer 2005 database and it failed with the following error:

(DbManager.executeQuery): DbManager could not retrive a connection. com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host has failed. java.net.ConnectException: Connection refused: connect

It has worked before but it stopped since we reinstalled SqlServer. Nothing changed on our SmartFox configuration. I figure the problem must be on the SqlServer put I can put my finger on it.

Does someone know what could be the reason for this failure?

Thanks

Post by **Lapo** » 16 Mar 2007, 20:36

Maybe the server is not configured to receive connections from "outside" ...
I am not familiar with MS SQL but we use MySQL a lot and this is the default behavior of the db server when installed, it only allows local connections