error connecting to remote sql server
-
hi, when i try to connect to a remote sql server 2008 from my application i get the below error. '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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)' but the remote sql server is accessible from other machines through the same application without any error. thanks & regards karthikeyan
-
hi, when i try to connect to a remote sql server 2008 from my application i get the below error. '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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)' but the remote sql server is accessible from other machines through the same application without any error. thanks & regards karthikeyan
-
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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) this was the complete error message. please note that i am connecting to sql server 2008 on a server and sql 2005 which is installed with visual studio 2005 is in the local machine.
-
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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) this was the complete error message. please note that i am connecting to sql server 2008 on a server and sql 2005 which is installed with visual studio 2005 is in the local machine.
karthi84 wrote:
please note that i am connecting to sql server 2008 on a server
Are you positive about this? I am asking because it seems weird to me that the error message mentions SQL Server 2005 (When connecting to SQL Server 2005 ...) when you are connecting to SQL Server 2008.
-
karthi84 wrote:
please note that i am connecting to sql server 2008 on a server
Are you positive about this? I am asking because it seems weird to me that the error message mentions SQL Server 2005 (When connecting to SQL Server 2005 ...) when you are connecting to SQL Server 2008.