This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 225517 - Error connecting to MS SQL
Summary: Error connecting to MS SQL
Status: RESOLVED INVALID
Alias: None
Product: javaee
Classification: Unclassified
Component: Persistence (show other bugs)
Version: 7.3.1
Hardware: PC Windows 7
: P3 normal (vote)
Assignee: Sergey Petrov
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-01-30 09:46 UTC by rayem
Modified: 2013-01-30 11:11 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Exception Reporter:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description rayem 2013-01-30 09:46:28 UTC
Hello

I have 2 valid connection to 2 tables in an MS SQL 2012, on the services->database in the main IDE window.

My web project has 2 persistance units that use these 2 tables, but when I run them i get:

WARNING: RAR5038:Unexpected exception while creating resource for pool microsoft_sql_JPSAssets_AssetsUserPool. Exception : javax.resource.spi.ResourceAllocationException: Connection could not be allocated because: The TCP/IP connection to the host localhost, port 1433 has failed. Error: "Connect timed out. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".
WARNING: RAR5117 : Failed to obtain/create connection from connection pool [ microsoft_sql_JPSAssets_AssetsUserPool ]. Reason : com.sun.appserv.connectors.internal.api.PoolingException: Connection could not be allocated because: The TCP/IP connection to the host localhost, port 1433 has failed. Error: "Connect timed out. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".
WARNING: RAR5114 : Error allocating connection : [Error in allocating a connection. Cause: Connection could not be allocated because: The TCP/IP connection to the host localhost, port 1433 has failed. Error: "Connect timed out. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".]
SEVERE: Local Exception Stack: 
Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.2.v20111125-r10461): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Error in allocating a connection. Cause: Connection could not be allocated because: The TCP/IP connection to the host localhost, port 1433 has failed. Error: "Connect timed out. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".

Please advise.

Best regards,
Michael
Comment 1 Jaroslav Havlin 2013-01-30 10:23:24 UTC
This is probably not a bug in NetBeans, but somewhere in system configuration.
Do you run the project on the same machine as your IDE, or remotely?

I guess you should ask in some mailing list or discussion forum.

Sergey, do you have any idea? Thanks.
Comment 2 Jaroslav Havlin 2013-01-30 10:29:22 UTC
(In reply to comment #1)
> Do you run the project on the same machine as your IDE, or remotely?
[From e-mail conversation with reporter:]
Yes both the database and IDE are being run on a windows 7 laptop.
Comment 3 Sergey Petrov 2013-01-30 11:11:02 UTC
I suppose too, see no issues in nb here.
May be firewall etc, block from connection if the same port works fine from nb.
all hints are here "Make
sure that an instance of SQL Server is running on the host and accepting TCP/IP
connections at the port. Make sure that TCP connections to the port are not
blocked by a firewall."." I have no additional.