An error occurred while establishing a connection with the server. When you connect to SQLServer2005, the remote connection not allowed by SQLServer by default may cause this failure. (Provider: SQL network interface, error: 26
An error occurred while establishing a connection with the server. When connecting to SQL Server 2005, SQL Server does not allow remote connection under the default settings, which may cause this failure. (Provider: SQL network interface, error: 26-An error occurred while locating the specified server/instance) Description: during the execution of the current Web request
InCreateAndServerOfConnectionHourError. InConnectionTo SQL Server 2005, SQL Server is not allowed to be remotely in the default settings.ConnectionThis failure may occur. (Provider: SQL network interface, error: 26-locate the specifiedServer/Instance timeError)
Note: An unhandled exception occurs during the execution of the current Web request. Check the stack trace information for details about the error and the source of the error in the code.
Exception details: System. Data. SqlClient. SqlException: InCreateAndServerOfConnectionHourError. InConnectionTo SQL Server 2005, SQL Server is not allowed to be remotely in the default settings.ConnectionThis failure may occur. (Provider: SQL network interface, error: 26-locate the specifiedServer/Instance timeError)
Solution:
Start> All Programs> Ms SQL Server> Configuration tool> SQL server peripheral application configurator> services andConnection-> Open the Database Engine node under the MSSQLSERVER node and select "service" to start the service. If yesConnectionIf the problem persists, select remoteConnection", Next we recommend that you select" use TCP/IP and named pipes at the same time ". After confirming, restart the database service.