Just installed MS SQL Server 5 Express. JDBC connection failing

[michael tall]

I installed MS SQL Server 5 Express. Downloaded sqljdbc.jar and added it to classpath. Trying to connect to a table with 5 rows as a test.

Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");connection = DriverManager.getConnection( "jdbc:sqlserver://localhost", "unm", "pw" );

When I run the program it is generating the following error: The TCP/IP connection to the host has failed. java.net.ConnectException: Connection refused: connect". I, then, tried by replacing localhost with IP address 111.11.11.11. Got the same error message. Any idea what mistake I'm making?

[Paul Sturrock]

By default, SQL Server does not allow remote connections over TCP/IP. Check you have enabled this via the network configuration tool.
[ November 05, 2008: Message edited by: Paul Sturrock ]

[michael tall]

Between my first post on this matter and now I checked some internet resources and enabled the TCP/IP using configuration manager. I restarted SQL server and re-ran the program. Still getting the same error

[michael tall]

Friends! I got it. Port in the SQL Server is different. I corrected port number in my code and connection succeeded. Thanks

[Paul Sturrock]

Glad to hear it