无法连接到 FCLZ-PC\SQLEXPRESS
-
Friday, August 17, 2012 12:01 PM
标题: 连接到服务器
------------------------------无法连接到 FCLZ-PC\SQLEXPRESS。
------------------------------
其他信息:在与 SQL Server 建立连接时出现与网络相关的或特定于实例的错误。未找到或无法访问服务器。请验证实例名称是否正确并且 SQL Server 已配置为允许远程连接。 (provider: SQL 网络接口, error: 26 - 定位指定的服务器/实例时出错) (Microsoft SQL Server,错误: -1)
有关帮助信息,请单击: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476
------------------------------
按钮:确定
------------------------------
All Replies
-
Friday, August 17, 2012 12:02 PMWhich language is that?
Regards,
Basit A. Farooq (MSC Computing, MCITP SQL Server 2005 & 2008, MCDBA SQL Server 2000)
http://basitaalishan.com
Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. -
Friday, August 17, 2012 2:00 PM
This link in your post gives you the resolution about this error.
User Action To resolve this error, try one of the following actions:
-
Check the spelling of the SQL Server instance name that is specified in the connection string.
-
Use the SQL Server Surface Area Configuration tool to enable SQL Server to accept remote connections over the TCP or named pipes protocols. For more information about the SQL Server Surface Area Configuration Tool, see Surface Area Configuration for Services and Connections.
-
Make sure that you have configured the firewall on the server instance of SQL Server to open ports for SQL Server and the SQL Server Browser port (UDP 1434).
-
Make sure that the SQL Server Browser service is started on the server.
Regards,
Basit A. Farooq (MSC Computing, MCITP SQL Server 2005 & 2008, MCDBA SQL Server 2000)
http://basitaalishan.com
Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
- Edited by Basit Farooq Friday, August 17, 2012 2:00 PM
- Edited by Basit Farooq Friday, August 17, 2012 2:01 PM
- Proposed As Answer by Basit Farooq Friday, August 17, 2012 2:01 PM
- Marked As Answer by Iric WenModerator Monday, August 27, 2012 9:14 AM
-

