Hello, 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 :-(
A:
In express edition the TCP support is disabled, although you see the corresponding configuration. Either buy a commercial version of use another RDBMS.
bobah
2010-05-14 08:14:13
oh really... I was under impression that it is just disabled as defalt setting but that you can make it enabled...
david
2010-05-14 08:15:43
A:
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
2010-05-14 09:30:22