开启sqlserver2005的远程访问功能

默认情况下Sqlserver2005的远程访问功能是关闭的，你可以通过以下步骤开启.
Start--->Programs--->Microsoft SQLServer2005--->Configuration Tools--->SQL Server Surface Area Configuration:


Pulls up SQL Server2005 Surface Area Configuration--->Click on Surface Area Configuration For Services and Connections:


Pulls up Surface Area Configuration for Service and Connections Window--->Highlight Remote Connections--->Select Local and Remote Connections:


Restart service to make it take effect:


You can take the same steps to configurate sqlexpress.

转载于:https://www.cnblogs.com/netboy/archive/2006/03/29/361453.html