SQL Server Performance

Connecting to SQL Server

Discussion in 'SQL Server 2005 General Developer Questions' started by dineshasanka, Oct 9, 2006.

  1. dineshasanka Moderator

    one of my clients running SQL Server standard 2005 in Windows XP professioanl SP2. He is getting following error when try to connect from .Net code.

    He has enabled Remote connection from Surface area configurator

    An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

    ----------------------------------------
    Contributing Editor, Writer & Forums Moderator
    http://www.SQL-Server-Performance.Com

    Visit my Blog at
    http://dineshasanka.spaces.live.com/
  2. dineshasanka Moderator

  3. Adriaan New Member

    The app probably relied on defaults. On the connect string, always mention server + database + login/trusted.

Share This Page