[RESOLVED] Connection string in web.config problem.

[Krenshau]

I am new to asp .net 2.0, and equally as new to web stuff in general. I am having a hard time understanding the whole web.config file stuff. I had an administrator page that worked fine in the root directory. However, I wanted to make a sub folder and use a web.config file to manage the role access. I did that, but now when I try to access the page it says it cannot connect to the SQL Server database. I am using the login control that comes with Visual Web Developer Express.

I have been reading about the web.config files, and learned that the config file in the directory takes priority over the one in the parent directory. If this is true, how can I get the web.config file to read the connection string in the parent directory?

I have tried the code below, but get:

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)

This is a hosted SQL Server 2005 database, so I know it excepts remote connections. I can connect with files on my main directory.

<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">
  <appSettings>
        <connectionStrings>
          <dataConfiguration defaultDatabase="PEPSqlServer"/>
        </connectionStrings>
  </appSettings>
  <system.web>
    <authentication mode="Forms" />
        <authorization>
            <allow roles="Director" />
            <deny users="*" />
            <deny users="?" />
        </authorization>
  </system.web>
</configuration>

Am I close?