Wrox Programmer Forums
|
BOOK: Professional ASP.NET 3.5 : in C# and VB ISBN: 978-0-470-18757-9
This is the forum to discuss the Wrox book Professional ASP.NET 3.5: In C# and VB by Bill Evjen, Scott Hanselman, Devin Rader; ISBN: 9780470187579
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Professional ASP.NET 3.5 : in C# and VB ISBN: 978-0-470-18757-9 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old March 14th, 2009, 07:43 AM
Authorized User
 
Join Date: Jan 2009
Posts: 12
Thanks: 5
Thanked 0 Times in 0 Posts
Default [newbie]A network-related or instance-specific error...

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.
(URL: http://www.mydigitallife.info/2007/1...e-connections/)

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:

...
connectionStringName="LocalSqlServer"
...







Similar Threads
Thread Thread Starter Forum Replies Last Post
SQL user instance error ckerin BOOK: Beginning ASP.NET 2.0 BOOK VB ISBN: 978-0-7645-8850-1; C# ISBN: 978-0-470-04258-8 0 April 28th, 2008 12:30 AM
Network related help required... shankhan Internet Information Services 0 September 22nd, 2007 01:34 AM
Error to change user instance csharpa SQL Server 2005 1 February 10th, 2007 09:44 AM
error related to vb6 Rajesh Pachouri Pro VB 6 0 September 16th, 2006 03:14 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.