View Single Post
  #2 (permalink)  
Old 06-03-2007, 11:12
Tinkerer Tinkerer is offline
Junior Member
 
Join Date: Mar 2007
Posts: 15
Default ASP.NET Login - remote connection error

I think I may need to do what is listed in this article - but having tried several approaches nothing seems to work for me.

I am trying to create a section of my web that requires login
I have all the files in the WWW Directory.
I have created a Private directory - which contains a single test page OK.aspx
I have put the login.aspx in the www directory.

on my pc (locally) I open up ok.aspx -> it redirects me to login.aspx -> I login -> I am directed back to ok.aspx.

I load the files to my domain and try it there & get

I open up ok.aspx -> it redirects me to login.aspx -> I login ->

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)

Specifically:

"Make sure you grant the folder "app_data" with read/write/execute/modify (or delete) permission on the Network Service user."

How Do I do this?? or more importantly where, which application? (I have Web Expression, Visual Studio 2005, SQL Server 2005 express)


"Quote:
[add name="LocalSqlServer" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirector y|\ASPNETDB.MDF;user instance=true;Integrated Security=True;Initial Catalog=ASPNETDB;" providerName="System.Data.SqlClient" /] "

This causes more errors but I think it is because I don't really understand it is this what I should have in the web.config file in the root(www) directory & do I need to edit the web.config files in the directories that I am protecting?
Reply With Quote