如何摆脱SQL Server 2008错误40中的sqlserver实例特定错误 [英] how to get rid of sqlserver instance specific error in sql server 2008 error 40
问题描述
我刚刚安装了sqlserver 2008并尝试连接。但我得到以下错误
无法连接到HEMANTH-PC。
附加信息：
建立与SQL Server的连接时发生与网络相关或特定于实例的错误。服务器未找到或无法访问。验证实例名称是否正确，以及SQL Server是否配置为允许远程连接。 （提供者：命名管道提供程序，错误：40 - 无法打开与SQL Server的连接）（Microsoft SQL Server，错误：53）
在服务器协议中 - 我已经检查了tcp-ip端口并将其设置为启用。
和命名管道启用，并检查它正在运行的实例并且我添加了端口1433到Windows防火墙也但仍然无法连接到服务器。得到同样的错误请帮帮我。提前谢谢。
i have installed sqlserver 2008 just now and trying to connect. but iam getting the following error
Cannot connect to HEMANTH-PC.
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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)
in the server protocols - i have checked the tcp-ip port and set it to enable.
and named pipes to enable, and checked the instance it is running and i have added the port 1433 to the windows firewall also but still not able to connecting to the server. getting the same error please help me out. thanks in advance.
推荐答案
你尝试过简单的东西吗？更改是服务器实例名称错误，或者您的授权类型或用户名/密码组合错误。
尝试通过SSMS或Visual Studio Server资源管理器窗格进行连接。当它工作时，你会更好地知道连接字符串应该是什么（VS甚至会为你提供一个特定数据库的工作字符串）
如果没有要做到这一点，我们需要更多关于你想要尝试连接的信息。
Have you tried the simple stuff? Changes are that the Server instance name is wrong, or you have the wrong authorization type or username / password combination.
Try to connect via SSMS or the Visual Studio Server Explorer pane. When that works, you'll have a better idea what the connection string should be (VS will even give you a working string for a specific database)
If that doesn't do it, we'd need a fair amount more info as to exactly what you are toing to try to connect.
这篇关于如何摆脱SQL Server 2008错误40中的sqlserver实例特定错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
