SQL2005怎样远程连接以及使用sa用户登录

 

---------------------------------------------------允许远程访问的设置--------------------------------------------------------

1.打开SQL Server Surface area configuration
->Surface area configuration for services and Connections
->Database Engine
->Remote Connections
->Local and remote connections
->Using both TCP/IP and named pipes

2.不启用远程防火墙

----------------------------------------------------使用sa登录的设置---------------------------------------------------------

1.打开SQL Server configuration manager
->SQL Server 2005 Services
->SQL Server(SQLEXPRESS)
->Log On
->Built-in account: Local System
2.登录Microsoft SQL Server Mangement Studio Express后双击0CEC730E5609436(这里是计算机名，后同)/SQLEXPRESS
->选择安全性
->选择SQL Server和Windows身份验证模式(s)
3.登录Microsoft SQL Server Mangement Studio Express后在安全性中选择登录名，选中sa用户，启用该用户并输入密码
4.重新启动0CEC730E5609436/SQLEXPRESS(右键点击它选择“重新启动”即可)