Answered 无法连接到 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 PM
     
     
    Which 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
     
     Answered

    This link in your post gives you the resolution about this error.

    http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476

    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.