sorry for answer but how to enable TCP in SQL server 2005 express edition? I used configuration manager, find network configuration/protocols and there enabled TCP, after that I have restarted sql server service and tried installation of problematic software again (software which told me that TCP is not enabled) but I have the same problem :-(
Asked
Active
Viewed 4,575 times
3 Answers
5
In Sql Server Configuration Manager.
- Sql Server Network Configuration > Protocols for SQLEXPRESS
- Select TCP/IP
- Protocol Tab, Change Enabled
- IP Address Tab, Section IPALL set the TCP Port to 1433
- Restart Service.
To verify that it works, go to cmd
> netstat -an
and you will see
...
TCP 0.0.0.0:1433 0.0.0.0:0 LISTENING
...
Then try on cmd
> sqlcmd -U sa -S .\sqlexpress,1433
And you will be connected...hope so
*Remember to enable and start the Sql Server Browser Service

jjchiw
- 4,375
- 1
- 29
- 30
-
don't understand why I have to provide the port manually, but worked! thx – Bernhard Döbler Aug 06 '13 at 10:46
1
You can connect to SQL2005 Express edition over TCP/IP.
Did you open 1433 port on your firewall? Server should accept incoming connections on 1433 port.
After that enable TCP/IP in SQL Server 2005 Surface area configuration utility (see MSSQLSERVER > Database Engine > Local and remote connections > Using TCP/IP only)

SQLDev
- 216
- 2
- 4
0
In express edition the TCP support is disabled, although you see the corresponding configuration. Either buy a commercial version of use another RDBMS.

bobah
- 18,364
- 2
- 37
- 70
-
oh really... I was under impression that it is just disabled as defalt setting but that you can make it enabled... – david May 14 '10 at 08:15