SQLServerException error

Hi,When I try to initialize the database by running a batch file,I am getting this error
"class com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host localhost, port 1433 has failed. Error: "Connection refused: connect. Verify the connection properties, check that an instance of SQLServer is running on the host and accepting TCP/IP connections at the port, and that no firewall is blocking TCP connections to the port"
I am using SQLServer 2008R2.I made sure that server is running and that firewall is turned off.Can some1 let me know what are my other options to debug this?

Thanks,
Lucy

What does this have to do with JDBC?

db

Where else should this be posted then?

You said

Quote:

---

I try to initialize the database by running a batch file

---

Did you perhaps mean a Java program, not a batch file at all?

db

Open "SQL Sever Configuration manager" tool and check that TCP/IP is Enabled in "SQL server Network configuration" section.

I checked SQL Sever Configuration manager tool and TCP/IP is enabled.And with respect to running batch file,the batch file which i am trying to run calls a Java class called InitializeDatabase where there is the code to initalize the db ,and from this file I am getting the error.I mean the error is mentioned in this java class.

I fixed my error.In the SQLServer config Manager ->SQLServerNetworkConfiguration ->Protocols for <instancename>->TCP/IP->IPAddresses tab I set the IPAll to 1433 and the error got fixed.Thanks for the help though.

Quote:

---

Originally Posted by Lucy

I fixed my error.In the SQLServer config Manager ->SQLServerNetworkConfiguration ->Protocols for <instancename>->TCP/IP->IPAddresses tab I set the IPAll to 1433 and the error got fixed.Thanks for the help though.

---

So as I suspected, it wasn't a JDBC matter at all.

db