开启sql server 2005的远程访问功能
- 作者：互联网
- 时间：2009-05-31 00:08:20
默认情况下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.
相关阅读
- sql server 2005中新增的bulk功能 2009-05-31
- Sql server 2005带来的分页便利 2009-05-31
- sql server 2005中的output子句 2009-05-31
- Sql server安装2005中AdventureWork 2009-05-31
- 使用 SQL Server 2005 数据库镜像功能时需要考虑的问题 2009-05-31
- 建立Microsoft SQL Server 2005数据仓库 2009-05-31