4. Enables TCP/IP in SQL server Configuration Manager
[Start]-[All Program]-
[Microsoft SQL Server2005]-
[Configuration Tools]-
[SQL Server Configuration Manager]
Right click on the SQL Server Browser and select
properties. Then, go to the Service tab. Go to
“Start Mode” and make it automatic. Then go
back and start the service.
Set “TCP/IP” and “Named Pipes” in “Protocols for
SQL EXPRESS to be “Enabled”.