TCP/IP connection to the host, port 1433 has failed

[Former Member]

com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host SUPERMAN, port 1433 has failed. Error: "Connection refused: connect. Verify the connection properties, check that an instance of SQL Server 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 trying to install the Integration Platform. Windows Server 2008 R2. This is in a peer-to-peer environment, no domain configuration... firewalls are all turned off. I installed SQL Managment Studio to validate that I can connect to my server, and yes it will connect without any issues (Using the "sa" logon ID.).

However, when running the installation of the B1if components, I get to the point where it asks me for the connection information and it fails.

Steps;

• Run UPGRADE.EXE as Administrator (Also logged in as Administrator)
• Click NEXT
• Validate the License Server and port... Click NEXT
• Enter the SITE password... Click NEXT
• Validate SQL server data... 2008... server name... "sa" user ID... and password... Click NEXT
• In the Component Selections window, check the box for "Integration Solution Components"
• System Message appears... Click OK
• Click NEXT
• Upgrade Summary... Click NEXT
• Welcome To... Click NEXT
• Enter USER and COMPANY... Click NEXT (Leaving "all users" defaulted)
• Destination Location... Click NEXT
• Action Review... Click NEXT
• B1admin password is entered... Click NEXT
• Install proceeds for Components and JVM
• Select Database Type... 2008... Click NEXT
• Database Server login...

Here I must change the server name and I enter SERVER\INSTANCE.

The Port remains the same (1433).

Username is "sa".

Enter the password... Click NEXT.

Message... "Test connection to B1if. This may take several seconds."... then the error.

May 8, 2012 5:59:56 PM com.sap.b1i.dboperation.DBCreator excute

WARNING: The TCP/IP connection to the host superman, port 1433 has failed. Error: "Connection refused: connect. Verify the connection properties, check that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port, and that no firewall is blocking TCP connections to the port.".

Any thoughts as to why this is happening?

[Former Member · Accepted solution]

Hi Terry,

I'm having the same problem... I guess the error is due to using a named instance!

On the JDBC connection string we need to specify the named instance,

... jdbc:sqlserver://SERVER:1433; instanceName=INSTANCE...

but I guess that the installation process is not considering this!

In case you can solve the problem, please reply.

Regards,

Júlio

[Former Member · Accepted solution]

Julio,

Yes!... That is exactly what is happening.

I have an open call with SAP to determine the best solution. I am trying several tests to see if we can make this work. Once I am finished working with them, I will report my results here.

Thanks.

Terry.

[Former Member · Accepted solution]

Terry,

Follow these steps:

Solution

1. Open the SQL Server Configuration Manager window. You can access this
window by choosing Start Menu -> All Programs -> Microsoft SQL Server 2005
-> Configuration Tools -> SQL Server Configuration Manager, and all the
installed SQL Server 2005 DB instances will be listed in the left tree.

2. Expand SQL Server 2005 Network Configuration, all the protocol
configurations for each instance are listed there.

3. Choose protocols for the default instance, all the protocols are listed
in the right panel, such as Named Pipes and TCP/IP.

4. Double click on the protocol TCP/IP to open the TCP/IP Properties window.
From IP Address tab, in the IP All configuration group, clear the TCP Dynamic
Ports, and set TCP Port as an available port number other than 1433(For example,
10433).

5. Similar to the previous steps, open TCP/IP Properties window for the SQL
Server instance which you want to install SAP Business One Integration
Technology on, clear the TCP Dynamic Ports, and set TCP Port to 1433.

6. Restart the default SQL Server instance from the SQL Server Configuration
Manager -> SQL Server Services.

7. Restart the SQL Server instance where SAP Business One Integration
Technology will be installed.

After finish all the above steps, SAP Business One Integration Technology can
be installed on the specific DB instance successfully.

Then on Server field in the installation form just enter the server name without the instance name... It worked for me!

[Former Member · Accepted solution]

Well SAP responded with their recommended work-around...

If you are using named SQL instance, then you can fill the Server field via the

following way: WIN2008SRV\SQL2005. Afterwards the Port field should contains the

value: 0000

This does seem to work.

thanks.

[Former Member · Accepted solution]

Terry,

if you have more than one instance, but only your SAP SQL-Installation-Instance have TCP/IP activated (as Julio described it before), you should try to connect without the instance name.

Otherwise - again if you have more than one instance name (e.g. you have preinstalled SBS services like backup and so.) - try to activate TCP/IP for all the instances.

Than you can try to connect with the instancename again as Julio has described it before.

Hope that helps

Heiko

[Former Member · Accepted solution]

This worked for me, thanks

[former_member45129 · Accepted solution]

Thanks Julio This works for me.

I would like to know why we are clearing dynamic ports.

How basically theTCP/IP request is handled ?