Start--->Programs--->Microsoft SQLServer2005--->Configuration Tools--->SQL Server Surface Area Configuration:
![1.PNG](https://i-blog.csdnimg.cn/blog_migrate/473a22e2367894fa7eb04853a51cca88.png)
Pulls up SQL Server2005 Surface Area Configuration--->Click on Surface Area Configuration For Services and Connections:
![2.PNG](https://i-blog.csdnimg.cn/blog_migrate/9e66da1deb8909203e1d2babdbe8eda8.png)
Pulls up Surface Area Configuration for Service and Connections Window--->Highlight Remote Connections--->Select Local and Remote Connections:
![3.PNG](https://i-blog.csdnimg.cn/blog_migrate/6247c47a63776e836ec7cb209357a1ca.png)
Restart service to make it take effect:
![4.PNG](https://i-blog.csdnimg.cn/blog_migrate/6384315405ee073161ec1f7742a053b4.png)
You can take the same steps to configurate sqlexpress.