sql server 2005连接失败

michelle_weimei 2009-10-13 02:05:10
我用sa账号登陆sql server 失败,什么原因呢?下面是错误信息:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
...全文
48 4 打赏 收藏 转发到动态 举报
写回复
用AI写文章
4 条回复
切换为时间正序
请发表友善的回复…
发表回复
michelle_weimei 2009-10-13
  • 打赏
  • 举报
回复
connect to from a remote computer. To do this, follow these steps:
Click Start, point to Programs, point to Microsoft SQL Server 2005, point to Configuration Tools, and then click SQL Server Surface Area Configuration.
On the SQL Server 2005 Surface Area Configuration page, click Surface Area Configuration for Services and Connections.
On the Surface Area Configuration for Services and Connections page, expand Database Engine, click Remote Connections, click Local and remote connections, click the appropriate protocol to enable for your environment, and then click Apply.

Note Click OK when you receive the following message:
Changes to Connection Settings will not take effect until you restart the Database Engine service.
On the Surface Area Configuration for Services and Connections page, expand Database Engine, click Service, click Stop, wait until the MSSQLSERVER service stops, and then click Start to restart the MSSQLSERVER service.

我按照这个步骤做,MSSQLSERVER ->Database Engine->Service:
状态:stop.
当我start时,报如下错误:
A error occurred while performing this operation.
为什么不能start呢
-狙击手- 2009-10-13
  • 打赏
  • 举报
回复
改成tcp/IP连接
你不是在局网内?
-狙击手- 2009-10-13
  • 打赏
  • 举报
回复
改tcp/IP连接
--小F-- 2009-10-13
  • 打赏
  • 举报
回复
http://blog.csdn.net/fredrickhu/archive/2009/09/22/4580618.aspx

SQL2005使用中遇到的问题及解答

34,592

社区成员

发帖
与我相关
我的任务
社区描述
MS-SQL Server相关内容讨论专区
社区管理员
  • 基础类社区
  • 二月十六
  • 卖水果的net
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧