Enable TCP/IP on SQL Server Express Edition

On SQL Server Express Edition (I don’t know how’s on full version, never had a license for it) the default connection model is through named pipes and TCP/IP is disabled.

How to Enable:
1. From SQL Server Configuration Manager, go and expand “Network Configuration”, choose “Protocols for SQL Server Express” and enable TCP/IP

2. Open TCP/IP properties page, go to the second tab “IP Addresses” and in the last field called “IPAll – TCP Port” enter your port number. You might want to choose 1433.

3. Restart SQL Server Express service.

How To Connect Sql Sever In Netbeans

Step -1: Download ->sqljdbc4.jar

Step -2: Copied  sqljdbc4.jar into the Tomcat lib folder

Step -3:Add New Driver 

            

Select sqljdbc4.jar

Step-4:Connecting

If Show this Error Massage->

Enable TCP/IP on SQL Server Express Edition