help: db connection refused!

[mhdside]

I`m facing a strange connection refused message as show below although I`m sure I`m providing all the information successfully in the zone config as below:

Code: Select all

<databaseManager active="true">
    <driverName>com.microsoft.sqlserver.jdbc.SQLServerDriver</driverName>
    <connectionString>jdbc:sqlserver://localhost:1433;DatabaseName=GameDB</connectionString>
   <userName>sa</userName>
    <password>qwe</password>
    <testSql>SELECT COUNT(*) FROM Player</testSql>
    <maxActiveConnections>10</maxActiveConnections>
    <maxIdleConnections>10</maxIdleConnections>
    <exhaustedPoolAction>FAIL</exhaustedPoolAction>
    <blockTime>3000</blockTime>
  </databaseManager>

the error I get when I run the server:


I`m using windows7 64bit, sfs2x final latest version.

Please advice what can I try so my sqlserver allows the connection.

regards,

[Lapo]

You should make sure that the database server is configured to receive connections from the client or, since it runs on the localhost, check that the local firewall is not blocking communication.

[mhdside]

You should make sure that the database server is configured to receive connections from the client or, since it runs on the localhost, check that the local firewall is not blocking communication.

can you tell me steps to try? I`m not a good system guy. ie: how to know if the local firewall is blocking communication?

[Lapo]

I am sorry I never worked with SQLServer, I think you should check the docs provided by Microsoft.
Anyways before that I would suggest a simple test, try disabling the Windows firewall and see if it helps, if so you will need to configure it so that it allows TCP traffic on the SQLServer port (which is the one specified in the error message)

I don't have a Windows pc at hand right now but turning off the firewall is pretty easy, just start from the Control Panel > Firewall.