August 31, 2009 at 12:00 pm
I am trying to connect to SQL Server 2008 SP1, on win 2008 server 64 bit edition from my tomcat application which is on unix box but receive the followiong error:
[2009-08-31 21:56:31.678][CS.DB][ERROR] Exception getting database connection
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (The port number 1433/CMSDB is not valid.)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
at com.fatwire.cs.core.db.DataSourceBackedPool.acquire(y:1266)
"More Green More Oxygen !! Plant a tree today"
August 31, 2009 at 12:41 pm
Can you confirm SQL is listening on TCP 1433? i.e. open a command prompt from your workstation and type: telnet myservername 1433
Is Windows Firewall running? You might need to add a rule to accept traffic on TCP 1433.
Tommy
Follow @sqlscribeSeptember 1, 2009 at 1:03 am
I have dissabled firewall, Checked the TCP/IP is listening on 1433, NAme pipes is enabled, SQL browser service is running
Remote connection is enabled.
what else to check ?
"More Green More Oxygen !! Plant a tree today"
September 1, 2009 at 8:49 am
Although you have disabled the firewall I still suggest you to do to the following. Windows server 2008 has all these firewall issues
1) turn on the firewall
2) Go to the firewall settings. In this go to inbound rules
3) Create a new rule where you open the port 1433
4) Create a new rule where you open the sqlserv.exe service.
ProgramFiles%\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Binn\sqlservr.exe
5) Browser service is required if you have mutiple instances of sql server runnin on the same machine. In case if you have that then keep the service running and open the firewall rule for that too.
6) in case you want to use ssis, ssrs and ssas you need to create rules for that too
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply