Tuesday, March 22, 2016

How to install Cisco VPN on Windows 10/ Cisco VPN on Windows 8.1/10 – Reason 442: Failed to enable Virtual Adapter


 

How to install the Cisco VPN client on Windows 10. If you're here you probably know that Cisco's VPN client is not supported on Windows 10 and that Cisco has ceased supporting their VPN client at all. The below steps will show you how to get it working on Windows 10.

Step 1: Download Dell Sonic Wall
32 bit
http://help.mysonicwall.com/applications/vpnclient/GVCSetup32_4.9.0.1202_EN.exe
64 bit
http://help.mysonicwall.com/applications/vpnclient/GVCSetup64_4.9.0.1202_EN.exe

Step 2: install Cisco vpn
Cisco Systems VPN Client 5.0.07.0290

https://drive.google.com/file/d/0Bw6xF1R9rrTLZDZScW1jNmhzM1U/view?pref=2&pli=1

To fix: the below error.


Click Start and type regedit in the Search field and hit enter.

Navigate to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\CVirtA
Find the String Value called Display Name

Right click and select Modify from the context menu.

For Windows 8/10 32bit (x86) operating systems, change the value data from @oem8.inf,%CVirtA_Desc%;Cisco Systems VPN Adapter to Cisco Systems VPN Adapter
















For Windows 8/10 64bit (x64) operating systems, change the value data from @oem8.inf,%CVirtA_Desc%;Cisco Systems VPN Adapter for 64-bit Windows to Cisco 

Systems VPN Adapter for 64-bit Windows Click Ok.




Close Registry Editor.

Retry your Cisco VPN Client connection.

Thursday, March 17, 2016

SQLServerException: The TCP/IP connection to the host, port 1433 has failed.

Error Description:

I had installed SQL SERVER 2014 Express edition and I was trying to connect to SQL SERVER from Java program using JDBC, but I was repeatedly getting following error:

com.microsoft.sqlserver.jdbc.SQLServerException: 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.".Error while closing connection !!null
 at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190)
 at com.microsoft.sqlserver.jdbc.SQLServerException.ConvertConnectExceptionToSQLServerException(SQLServerException.java:241)
 at com.microsoft.sqlserver.jdbc.SocketFinder.findSocket(IOBuffer.java:2243)
 at com.microsoft.sqlserver.jdbc.TDSChannel.open(IOBuffer.java:491)
 at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1309)
 at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:991)
 at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:827)
 at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1012)
 at java.sql.DriverManager.getConnection(Unknown Source)
 at java.sql.DriverManager.getConnection(Unknown Source)
 at Testing.main(Testing.java:42)

SQLServerException: The TCP/IP connection to the host [name], 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/IP connections to the port.”
Solution:
                1.       Run the SQL Server Configuration Manager.
                2.       Expand the SQL Server 2005 Network Configuration item.
                3.       Select the Protocols for SQLEXPRESS item.
                4.       Right-click on TCP/IP.
                5.       Select Enable.

                6.       Next, right-click on TCP/IP and choose Properties.
                7.       Click on the IP Addresses tab.
                8.       In the IPALL section, enter the port number 1433 in the TCP Portfield

                9.       Click Apply.
               10.  Click OK.
               11.   Close the SQL Server Configuration Manager.
               12.   Finally go to the Windows Control Panel > Administrative Tools > Services area and Stop            and then Start the SQL Server (Express) service for the changes to take effect.