我无法在Ms Sql Server 2005网络配置中找到客户端协议。我该如何配置它们？ [英] I Can't Find Client Protocols In Ms Sql Server 2005 Network Configuration. How Can I Configure Them?

问题描述

我已为我的项目安装了Microsoft SQL Server 2005，但由于以下错误，我无法在运行项目时连接到它



发生了错误在建立与服务器的连接时。连接到SQL Serevr 2005时，这种失败可能是由于默认设置SQL Server不允许远程连接这一事实。（提供者：命名管道提供者，错误：40-无法打开连接到SQL Server）。



我试过以下解决方案来克服这个问题，但仍然得到同样的错误：

1.已安装MS SQL服务器作为网络服务器。

2.允许SQL Server 2005中的远程连接表面区域配置。



我认为主要问题是因为SQL服务器网络配置中没有客户端协议。我无法在网络配置中找到它们。

请帮助解决这个问题并指导我在网络配置中配置这些客户端协议。

谢谢..！

I have installed Microsoft SQL Server 2005 for my project but I can't connect to it while running my project because of following error

"An error has occurred while establishing a connection to the server. When connecting to SQL Serevr 2005,this failure may be caused by the fact that underthe default settings SQL Server does not allow remote connections.(provider: Named Pipes Provider,error: 40- Could not open a connection to SQL Server)."

I have tried following solutions to get over this but still getting the same error:
1. Installed MS SQL sever as network server.
2. Allowed remote connections in SQL Server 2005 Surface Area Configuration.

I think that the main problem is because absence of client protocols in SQL server network configuration. I cant find them in network configuration.
Please help to solve this problem and guide me to configure these client protocols in network configuration.
Thank you..!

推荐答案

你会发现命名管道和TCP / IP协议的激活sql server配置管理器console => sql server network configuration=> MSSSQLSERVER协议，启用它们并重新启动SQL服务器实例。



检查防火墙，如果SQL Server的端口1433启用了发送和接收



Bechir。

Hi,

you will find the activation of "named pipes" and "TCP/IP" protocol in "sql server configuration manager" console => "sql server network configuration" => "protocols for MSSSQLSERVER", enable them and restart your SQL server instance.

Check also you firewall, if the port 1433 for SQL server is enabled for sending and receiving

Bechir.

这篇关于我无法在Ms Sql Server 2005网络配置中找到客户端协议。我该如何配置它们？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！