Check the Configuration Manager and enable SQL Server protocols.

An error occurred while establishing a connection with the server.
Common solutions:
1. Check the default logon method of SQL server. The default logon mode is windows integrated logon. to log on with an account, you must change it to SQL hybrid logon mode.
2. Check the Configuration Manager and enable the SQL server protocol.
3. Check

Level:

Posted on:2007-06-28 14:13:56 Landlord The error message is: An error occurred while establishing a connection with the server. When you connect to SQL Server 2005, the default setting does not allow remote connection to SQL Server may cause this failure. (Provider: SQL network interface, error: 26-An error occurred while locating the specified server/instance ). My settings: 1. All SQL Server 2005 services in SQL Server Configuration Manager have been started. 2. In SQL Server Configuration Manager, SQL2005 protocol under SQL Server 2005 network Configuration is not started except VIA, and all others are started. 3. The remote connection in the database engine in the SQL Server peripheral application configurator selects the local connection and remote connection (both TCP/IP and named pipes are used) 4. The remote connection in Analysis Services in the SQL Server peripheral application configurator selects the local connection and remote connection.

Level:

Posted on:2007-06-28 14:13:56 Landlord The error message is: An error occurred while establishing a connection with the server. When you connect to SQL Server 2005, the default setting does not allow remote connection to SQL Server may cause this failure. (Provider: SQL network interface, error: 26-An error occurred while locating the specified server/instance ). My settings: 1. All SQL Server 2005 services in SQL Server Configuration Manager have been started. 2. In SQL Server Configuration Manager, sql2005 protocol under SQL Server 2005 network configuration is not started except via, and all others are started. 3. The remote connection in the database engine in the SQL Server peripheral application configurator selects the local connection and remote connection (both TCP/IP and named pipes are used) 4. The remote connection in Analysis Services in the SQL Server peripheral application configurator selects the local connection and remote connection.

 

 

 

 

The error message is: An error occurred while establishing a connection with the server. When you connect to SQL Server 2005, the default setting does not allow remote connection to SQL Server may cause this failure. (Provider: SQL network interface, error: 26-An error occurred while locating the specified server/instance ). My settings: 1. All SQL Server 2005 services in SQL Server Configuration Manager have been started. 2. In SQL Server Configuration Manager, SQL2005 protocol under SQL Server 2005 network Configuration is not started except VIA, and all others are started. 3. The remote connection in the Database Engine in the SQL Server peripheral application configurator selects the local connection and remote connection (both TCP/IP and named pipes are used) 4. The remote connection in Analysis Services in the SQL Server peripheral application configurator selects the local connection and remote connection.