如何解决SqlServer2008 r2登录错误? [英] How to Solve SqlServer2008 r2 Login Error?
本文介绍了如何解决SqlServer2008 r2登录错误?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我希望Sql Server2008 r2未在下面打开错误来了
网络相关或特定于实例的错误发生时建立与sql server的连接。找不到服务器或者无法访问服务器。验证实例名称是否正确,并且sql server配置为允许远程连接(提供者:命名管道提供程序,错误:40 - 无法打开连接到sql server)
解决方案
检查你的连接字符串,特别注意集成安全性
或用户ID
和密码
部分。
前者通常只有用于开发,后者几乎总是用于生产。后者需要完全有效的id和密码,因此请根据DBA给出的数据仔细检查。
http://www.codeproject.com/Questions/335874/A-网络相关或 - 实例特定-误差发生
Hi,
I want Sql Server2008 r2 not open below error came
A network-related or instance-specific error occured 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)
解决方案
Check your connection string, paying particular attention to theIntegrated Security
orUser ID
andPassword
sections.
The former is normally only used for development, the later is almost always used for production. The latter requires fully valid id and password, so double check those against the data you were given by the DBA.
http://www.codeproject.com/Questions/335874/A-network-related-or-instance-specific-error-occur
这篇关于如何解决SqlServer2008 r2登录错误?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文