我无法连接到我的Sql Server 2012 [英] I Can't Connect to my Sql Server 2012
问题描述
我打开我的Sql Server管理
突然之后我收到此错误？
标题：连接到服务器
无法连接到BRIAN。
附加信息：
建立与SQL Server的连接时发生与网络相关或特定于实例的错误。服务器未找到或无法访问。验证实例名称是否正确，以及SQL Server是否配置为允许远程连接。 （提供者：命名管道提供程序，错误：40 - 无法打开与SQL Server的连接）（Microsoft SQL Server，错误：2）
如需帮助，请单击： http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&EvtSrc=MSSQLServer&EvtID=2&LinkId=20476
系统无法找到指定的文件
按钮：
OK
你能帮帮我吗？
在此先感谢！
由于多种原因会发生此错误
查看以下链接
http ：//www.sswug.org/articlesection/default.aspx？TargetID = 44331 [ ^ ]
希望它能帮助您解决..
< blockquote>错误信息非常明确：它无法连接 - 它为您提供了一个开始检查的事物列表的链接。
我们可以做不再需要：您需要从连接字符串开始并一直检查它。我们无法访问字符串或您正在使用的环境。
请按照链接查看内容，如果您无法从中进行排序，请尝试建立通过服务器资源管理器窗格在VS中建立连接 - 当你正确使用它时，它将为你提供一个工作连接字符串。
如果BRIAN是本地SQL，那么检查 SQL Server 服务是否正在运行。
如果BRIAN是远程/网络SQL，请检查您的网络连接和SQL Server服务。
I Open My Sql Server Management
when suddenly I Get this error?
TITLE: Connect to Server
Cannot connect to BRIAN.
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: 2)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&EvtSrc=MSSQLServer&EvtID=2&LinkId=20476
The system cannot find the file specified
BUTTONS:
OK
Can You Help me out here?
Thanks In Advance!
This Error can happen due to many reasons
Check the below link
http://www.sswug.org/articlesection/default.aspx?TargetID=44331[^]
Hope it will help you to resolve..
The error message is pretty explicit: it can't connect - and it provides you with a link to a list of things to start checking.
We can do no more: you need to start with your connection string and check it all the way through. We don't have access to the string, or the environment you are working in.
So follow the link, see what it says, and if you can't sort it out from that, try establishing a connection in VS via the Server Explorer pane - which will give you a working connection string when you get it right.
If BRIAN is a local SQL then check SQL Server Service is running or not.
If BRIAN is a Remote/Network SQL then check your Network connection and SQL Server Service there.
这篇关于我无法连接到我的Sql Server 2012的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
