本文介绍如何启用SQL Server 2005的远程连接功能，包括使用SQL Server Surface Area Configuration工具来配置服务和连接选项，实现本地及远程连接。
默认情况下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.
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.
扫一扫
2074
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
