且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

我无法连接到我的Sql Server 2012

更新时间:2022-12-23 22:46:49

由于多种原因会发生此错误



查看以下链接



http ://www.sswug.org/articlesection/default.aspx?TargetID = 44331 [ ^ ]



希望它能帮助您解决..


错误信息非常明确:它无法连接 - 它为您提供了一个开始检查的事物列表的链接。



我们可以做不再需要:您需要从连接字符串开始并一直检查它。我们无法访问字符串或您正在使用的环境。

请按照链接查看内容,如果您无法从中进行排序,请尝试建立通过服务器资源管理器窗格在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.