sql server连接问题 [英] sql server connectivity problem

问题描述

其他信息:

建立与SQL Server的连接时发生与网络相关或特定于实例的错误.服务器未找到或无法访问.验证实例名称正确，并且已将SQL Server配置为允许远程连接. (提供程序:共享内存提供程序，错误:40-无法打开与SQL Server的连接)(Microsoft SQL Server，错误:2

当我连接sql server 2005时会显示此msg，所以我该怎么做?

ADDITIONAL INFORMATION:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Shared Memory Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2

this msg is show when i connect the sql server 2005 so what i do??

推荐答案

您可以:
1.)确认实例名称正确
2.)验证SQL Server已配置为允许远程连接.
3.)将错误消息复制并粘贴到Google，然后找到类似以下内容的内容:
http: //social.technet.microsoft.com/wiki/contents/articles/2102.how-to-troubleshoot-connecting-to-the-sql-server-database-engine.aspx [

You can:
1.) Verify that the instance name is correct
2.) Verify that SQL Server is configured to allow remote connections.
3.) Copy&paste the error message to google and find something like this:
http://social.technet.microsoft.com/wiki/contents/articles/2102.how-to-troubleshoot-connecting-to-the-sql-server-database-engine.aspx[^]

Regards

您是否检查了防火墙中是否打开了1433端口以允许连接?如果没有，您将无法与SQL Server通信，更不用说找到实例.还要检查是否已启用SQL浏览器服务.

Did you check if the 1433 port is open in the firewall to allow connections ?If not there is no way that you''ll be able to communicate to SQL server let alone find the instance.Also check if have enabled the SQL browser service started or not.

http://connectionstrings.com/sql-server-2005

该链接可能会对您有所帮助.

http://connectionstrings.com/sql-server-2005

The link may be help you.

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