本文介绍了连接到SQL SERVER 2008 r2时遇到问题的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
i连接到SQL SERVER 2008 r2时遇到问题，它显示以下内容
Hi,
i am facing problem while connecting to SQL SERVER 2008 r2 and it is displaying the following content
TITLE: Connect to Server
------------------------------
Cannot connect to xxxxxxx\SQLEXPRESS.
------------------------------
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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)
------------------------------
我尝试了什么：
i已经打开服务并自动启动SQL服务器并单击应用并确定...仍然收到相同的消息..
What I have tried:
i had opened services and start SQL server automatically and clicked apply and ok... still getting the same message..
推荐答案
you need to start this two services in SQL SERVER CONFIGURATION MANAGER.
1. SQL Server(MSSQLSERVER)
2. SQL Server Browser
And one more thing you need to enable the Protocols for MSSQLSERVER
Shared Memory Enabled
Named Pipes Enabled
TCP/IP Enabled
VIA Disabled
这篇关于连接到SQL SERVER 2008 r2时遇到问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！