Problemas de Conexion con SQL

04/05/2006 - 18:50 por Brian | Informe spam
Tengo problemas para conectar la una aplicacion desarrollada en C# con
Framework 2.0, en la m[aquina local en donde estba instalada, funcionaba
perfectamente, pero la intento correr en otro equipo y tiene conexi[on a un
servidor de SQL 2000 remoto, pero no me permite conectar, aparece un error
como este:

Server Error in '/******' Application.

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)
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information about
the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: 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)

Stack Trace:


[SqlException (0x80131904): 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)]
CONTROLLER.Controladora.An8edsActual(String cUsuarioActual) in
C:\DEVELOP_NET\TERESA_WEB\CONTROLLER\Controladora.cs:604
Login_aspx.LoginButton_Click(Object sender, EventArgs e) in
c:\Inetpub\wwwroot\TERESA_WEB\Login.aspx.cs:43
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +105
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
+107

System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102




Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET
Version:2.0.50727.42


Si alguine me puede ayudar, muchas gracias.
 

Leer las respuestas

#1 Guillermo guille
04/05/2006 - 22:31 | Informe spam
Eso suena como si en la cadena de conexión estuvieras usando un nombre de
servidor (o instancia) que no existe.

Por ejemplo, para conectar a la instancia normal, deberás usar (local) o el
nombre del equipo.
Y para acceder a la instancia de SQL Server 2005 Express sería algo así:
(local)\SQLEXPRESS

Mira esto a ver si te aclara un poco esto de las instancias:
http://www.elguille.info/NET/ADONET...server.htm

Nos vemos.
Guillermo
Microsoft VB MVP desde 1997
Mentor Asociado de Solid Quality Learning Iberoamericana

Te recuerdo que puedes entrar en mi sitio desde:
http://www.elguille.info/ y http://www.mundoprogramacion.com/
Los foros en: http://foros.elguille.info/
Si buscas un buen plan de alojamiento:
http://www.elguille.info/hostings/o...guille.htm

"Brian" escribió en el mensaje
news:
Tengo problemas para conectar la una aplicacion desarrollada en C# con
Framework 2.0, en la m[aquina local en donde estba instalada, funcionaba
perfectamente, pero la intento correr en otro equipo y tiene conexi[on a
un
servidor de SQL 2000 remoto, pero no me permite conectar, aparece un error
como este:

Server Error in '/******' Application.

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)
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about
the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: 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)

Stack Trace:


[SqlException (0x80131904): 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)]
CONTROLLER.Controladora.An8edsActual(String cUsuarioActual) in
C:\DEVELOP_NET\TERESA_WEB\CONTROLLER\Controladora.cs:604
Login_aspx.LoginButton_Click(Object sender, EventArgs e) in
c:\Inetpub\wwwroot\TERESA_WEB\Login.aspx.cs:43
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +105
System.Web.UI.WebControls.Button.RaisePostBackEvent(String
eventArgument)
+107

System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String
eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102




Version Information: Microsoft .NET Framework Version:2.0.50727.42;
ASP.NET
Version:2.0.50727.42


Si alguine me puede ayudar, muchas gracias.

Preguntas similares