IntroductionToday i face another issue with sql server 2005 connect with ASP.NET web application.The error message as like below, "A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)" But I found the way how to resolve it. Step by Steps to resolve1. Enable TCP/IP Go to Programs -> Microsoft SQL Server 2005 -> Configuration Tools -> SQL Server Configuration Manager Make sure TCP/IP is Enabled 2. Make sure MS SQL allow remote connection with TCP/IP protocol.
Go to Programs -> Microsoft SQL Server 2005 -> Configuration Tools -> SQL Server Surface Area Configuration Click on Surface Area Configuration for Services and Connections Make sure Local and remote connections and using TCP/IP only is selected. 3. Open port for Port: 1433, sqlbrowser.exe and sqlservr.exe in windows firewall. Launch the Windows Firewall configuration tool from the control panel.
Click the Exceptions Tab
Click on Add Port, key in information as below Repeat above but this time click the "Add Programs." button and select "sqlservr.exe" from the
location where you install SQL Server Express (normally in C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn)
Report the same steps but select "sqlbrowser.exe" (normally in: C:\Program Files\Microsoft SQL Server\90\Shared) Try again and the problem solved. Hope this help. |