Google Search Appliance: com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host "xyz" port 1433 has failed.
<p>I'm deploying google search appliance connector for database(SQL). When I run my "run.bat", I got an error in my logs which says:</p>

<pre><code> java.io.IOException: com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host "xyz", port 1433 has failed. Error: "null. 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.".
    at com.google.enterprise.adaptor.database.DatabaseAdaptor.getDocIds(DatabaseAdaptor.java:235)
    at com.google.enterprise.adaptor.DocIdSender.pushFullDocIdsFromAdaptor(DocIdSender.java:69)
    at com.google.enterprise.adaptor.GsaCommunicationHandler$PushRunnable.run(GsaCommunicationHandler.java:856)
    at com.google.enterprise.adaptor.OneAtATimeRunnable.run(OneAtATimeRunnable.java:69)
    at com.google.enterprise.adaptor.ShutdownWaiter$NotificationRunnable.run(ShutdownWaiter.java:183)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
</code></pre>

<p>I have tried the below solutions:</p>

<ol>
<li>Remove All the TCP Dynamic Ports and Add value of 1433 to all TCP Port and restart your SQL Server.
My SQL Server Configuration looks like this:</li>
</ol>

<p><a href="https://i.stack.imgur.com/hhLIV.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/hhLIV.png" alt="enter image description here"></a></p>

<p><a href="https://i.stack.imgur.com/oaVpF.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/oaVpF.png" alt="enter image description here"></a></p>

<p><a href="https://i.stack.imgur.com/OqRpk.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/OqRpk.png" alt="enter image description here"></a></p>

<ol start="2">
<li>Check the value of key TcpDynamicPorts. 
<a href="https://i.stack.imgur.com/2mMB9.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/2mMB9.png" alt="enter image description here"></a></li>
</ol>

<p>I don't have my dynamic port set.</p>

<p>Is there any other way to solve this error. Any help would be appreciated. </p>