连接sql server 2008时出现错误10061 [英] Error 10061 while connecting sql server 2008

问题描述

我正在尝试连接sql server 2008 R2。但是它给了

I am trying to connect sql server 2008 R2. But it gives

A network related or instance specific error has occurred while establishing a connection to the server. The server was not found or was inaccessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.) (Microsoft SQL Server, Error: 10061)

我从Configuration Manager启用了客户端协议。但仍无法正常工作。请帮忙。

先谢谢

I enabled Client Protocols from Configuration Manager .Still Not Working. Please Help.
Thanks In Advance

推荐答案

听起来像Windows防火墙锁tcp / ip连接到sql server：配置Windows防火墙以允许SQL Server访问 [ ^ ]



BTW，请检查这些：

如何：为数据库实例启用TCP / IP协议 [ ^ ]

配置服务器以在备用管道上侦听（SQL Server配置管理器） [ ^ ]

命名管道与TCP / IP套接字 [ ^ ]

Sounds like windows firewall locks tcp/ip connection to the sql server: Configure the Windows Firewall to Allow SQL Server Access[^]

BTW, check these too:
How to: Enable the TCP/IP Protocol for a Database Instance[^]
Configure a Server to Listen on an Alternate Pipe (SQL Server Configuration Manager)[^]
Named Pipes vs. TCP/IP Sockets[^]

这篇关于连接sql server 2008时出现错误10061的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！