My web site is working when I click Start Debugging(F5). The data can be retrived from the database correctly. The url is http://localhost:1708/mywebsite/home.aspx. But when I type http://localhost/mywebsite/home.aspx in the url directly, I got the following error message: 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) .

I use SQL Server 2000 (not 2005) and the database is on another server myWebsiteDB. The connectString set up is: <add name="LocalSqlServer" connectionString="Data Source=dbServer;Initial Catalog=myWebsiteDB;Persist Security Info=True;User ID=sa;Password=mypw#" providerName="System.Data.SqlClient"/>.

Could any one tell me why the localhost doesn't work? Thanks in advance!

Are you sure that "http://localhost/mywebsite" is really pointing to the same place as "http://localhost:1708/mywebsite/"? I ask only because it is very strange that you would have this problem as you describe it.

-Peter
compiledthoughts.com

I have had this before at work, I think it is because of the ACL on the folder.

Ensure you have set the ACL on the folder to allow the ASP Machine account is given full access to the folder. This can often occur when a directory is moved from one location to the wwwroot folder..

Hope this helps, if not please shout and I will check settings once I am back in the office, I have definately experienced the same problem that you are having though.

Rob
http://robzyc.spaces.live.com

How can I tell they are pointing to the same place?

Thanks Rob. The localhost is not working only when the page needs to retrive data. [u]http://localhost/mywebsite/home.aspx</u> is a page has SqlDataSource and GridView. But the login page [u]http://localhost/mywebsite/login.aspx</u> is working. So I guess it's nothing to do with ACL on the folder.

You'll have to check the IIS virtual directory configuration for where it points to. It should be pointing to the same dir/project you are opening in visual studio.

-Peter
compiledthoughts.com

Hi, sorry for the delay in replying, been swamped of late!

Is this problem still outstanding? Resolved?

Rob
http://robzyc.spaces.live.com