Posts Tagged ‘ASP.NET’

ASP.NET 2.0 Notes

April 24th, 2009 Comments off

Here are some notes on installing and configuring ASP.NET with IIS…

Read more…

Categories: ASP.NET Tags:

SQL Network Interfaces Error: 26

April 20th, 2009 Comments off

When trying to connect an ASP.NET web application to an instance MS SQL Server Express 2005, I get the following error:

Error: 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)

At first reading I thought that this was the result of the server not being configured for remote connections. As it turns out we needed to change the database connection string to use {hostname}\{name of instance} instead of {IP address}\{name of instance}.

In regards to the issue of allowing remote connections, instructions for doing so can be found at Configuring SQL Server Express 2005 for Remote Access when SQL Server does not allow remote connections

Basically, you go to SQL Server Configuration Manager and under client protocol make sure TCP/IP, named pipes and shared memory is enabled.  Also, go to to SQL Server Surface Area Configuration and under Database –> Remote Connection choose both TCP/IP and Named Pipes.

Categories: Data Tags: ,