SQL network interface, error: 26-An error occurred while locating the specified server/instance
"/jecas" Application Server Error in Program . ------------------------------------------------------------------------------ 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) Description: An unhandled exception occurred 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 Code . Exception details: system. Data. sqlclient. sqlexception: 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) Source error: Row 16: {Row 17: noticeboardcontroller ctrlnoticeboard = new noticeboardcontroller (); row 18: This. repeater1.datasource = ctrlnoticeboard. getallnoticeboardnews (); row 19: This. repeater1.databind (); Row 20:} source file: e://jecas1/website/usercontrols/noticeboard. ascx. CS row: 18 stack trace: [sqlexception (0x80131904): 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)] solution
SQL server2005 is secure. By default, only local connections are allowed, and remote connections are not enabled. How to enable remote connections: start> All Programs> ms SQL server2005> Configuration tool> ms SQL server2005 peripheral application configurator> server and connected peripheral application configurator> remote connection under Database Engine select "local connection and remote connection" and select "local connection and remote connection" under "TCP/IP and name pipes" Analysis Services "to restart the database