连接sql server 2008时出现错误10061
问题描述:
我正在尝试连接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[^]