Hi there, Can some please help me with this - I have just started learning ASP.net with the book named "ASP.NET 2.0 Instant Results". I have been through the first chapter and now trying to run "Online Diary" on my PC. I am using Visual Studio 2005, SQL Server 2005 running on Windows Server 2003 on a stand alone PC.

I unzip the ziped file to a folder to c:\Inetpub\wwwroot. It looks like c:\Inetpub\wwwroot\OnlineDiary.

I browse to the folder, open the File in Visual Studio. I set login page as start up page. I hit the F5 to start running the site. I enter the user name and password as mentioned in the chapter 1.

I get this "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) ...."

Can someone please tell me what exactly I need to do step by step to make it work on my PC?

Thanks in advance.

gsrai31

Hi there,

Did you install SQL Server 2005 Express Edition? This is the database that is used by .NET by default.

If you are running a full version of SQL Server, you may want to take a look here: http://imar.spaanjaars.com/QuickDocId.aspx?quickdoc=395

Cheers,

Imar


---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of Beginning ASP.NET 3.5 : in C# and VB, ASP.NET 2.0 Instant Results and Dreamweaver MX 2004
Want to be my colleague? Then check out this post.

Thanks for a quick reply. Yes, I am running full version of SQL Server 2005. I will go through the article for the link you sent and see if I can make it work. Thank you. gsrai31