SQL Server Performance Forum – Threads Archive

Connecting to SQL Server

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/

well, bit strage.
Following were my recomendations
http://www.aquesthosting.com/HowTo/Sql2005/SQLError26.aspx However, client is saying that we he changed some form authentication in is code it works.
bit strange for me!!! —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
http://dineshasanka.spaces.live.com/

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

]]>