Tuesday, August 13, 2013

SQL Server 2008: Cannot establish a connection. The server sqlexpress is not configured to listen with TCP/IP

I was getting the error:

Cannot establish a connection to jdbc:sqlserver://FEMPUTADORA-PC\SQLEXPRESS;databaseName=pichincha using com.microsoft.sqlserver.jdbc.SQLServerDriver (The server sqlexpress is not configured to listen with TCP/IP.)

I solved it by enabling TCP/IP listen:
1. Run: "start" > "all programs" > "Microsoft SQL server 2008" > "configuration tools" > "SQL Server Configuration Manager"
2. Go to SQL Server Network Configuration > Protocols for SQLEXPRESS.
3. enable TCP/IP.

Reference:
http://stackoverflow.com/questions/11278114/enable-remote-connections-for-sql-server-express-2012

No comments: