When I run code Listing 16-3, I am getting the following 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)
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
So far I have tried the following, after re-installing SQL Server 2005 Express Edition:
1. Starting up SQL Server browser and checking that remote connections is allowed. Firewall is disabled.
2. Installed SQL Server SP2 (see #117)
3. Run C:\Windows\Microsoft .NET\Framework\v2.0.50727\aspnet_regsql.exe. It is important to update servername\INSTANCENAME within the wizard (e.g. mine is dev01\JOEY.)
By any chance does the <connectionStringName> within the web.config file
have to be modified. It currently reads: