Step 1:
Change the Enabled property to Yes.
Go to tab IP Address.
Scroll all the way to the bottom. Clear the TCP Dynamic Ports. Specify 1433 in TCP Port.
Restart SQL Express.
Done.
Tuesday, October 23, 2012
SQL Express with JDBC : Connection refused
By default SQL Server Express 2012 is installed with protocol TCP/IP disabled. Follow the steps to enable JDBC connection:
Step 1:
Open SQL Server Configuration Manager. Navigate to SQL Server Nework Configuration, then Protocol for SQLEXPRESS. Double click the TCP/IP protocol at right hand pane.
Change the Enabled property to Yes.
Go to tab IP Address.
Scroll all the way to the bottom. Clear the TCP Dynamic Ports. Specify 1433 in TCP Port.
Restart SQL Express.
Done.
Step 1:
Change the Enabled property to Yes.
Go to tab IP Address.
Scroll all the way to the bottom. Clear the TCP Dynamic Ports. Specify 1433 in TCP Port.
Restart SQL Express.
Done.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment