Where is web.config.sqlfull?

bryan_cook · January 14th, 2008, 01:15 PM

I'm having issues setting up the WroxUnited web site on my computer. I'm working with the Cassini, Visual Studio Full, SQL Server Full setup. I'm told to rename web.config.sqlfull to web.config, but from the FinalApplication.zip I downloaded off of the code section for my book (http://www.wrox.com/WileyCDA/WroxTit...load_code.html), there does not exist a web.config.sqlfull, only a web.config. I've searched through all the files and folders provided with FinalApplication.zip, and have not found any instance of web.config.sqlfull ...

Where can I obtain a copy of web.config.sqlfull? I walked through the updated Appendix B, and attempted to make the changes to web.config manually, but that's given me both errors and a headache. Any help would be greatly appreciated, be it a copy of web.config.sqlfull, or a helpful walk-through of the necessary changes to make to web.config.

Thanks.

bryan_cook · January 14th, 2008, 05:09 PM

Let me document the errors that I get when I change my web.config, in case it may benefit others down the line ...

Here's what I've changed my web.config to ...

Code:

<connectionStrings>
        <clear />
        <add name="WroxUnited"
          connectionString="Data Source=PROGRAM4DT06\BMC_SQL01;Integrated Security=True;Initial Catalog=WroxUnited"
          providerName="System.Data.SqlClient" />
        <add name="WroxUnitedMembership"
          connectionString="Data Source=PROGRAM4DT06\BMC_SQL01;Integrated Security=True;Initial Catalog=WroxUnitedMembership"
          providerName="System.Data.SqlClient"/>
</connectionStrings>

... and I get the following error in my browser ...

Quote:

quote:
Server Error in '/WroxUnited' Application.
Parser Error Message: The connection name 'LocalSqlServer' was not found in the applications configuration or the connection string is empty.
Source File: c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Conf ig\machine.config Line: 150

Code:

Line 148:    <roleManager>
Line 149:      <providers>
Line 150:        <add name="AspNetSqlRoleProvider" connectionStringName="LocalSqlServer" applicationName="/" type="System.Web.Security.SqlRoleProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>
Line 151:        <add name="AspNetWindowsTokenRoleProvider" applicationName="/" type="System.Web.Security.WindowsTokenRoleProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>
Line 152:      </providers>

It seems like it's looking in web.config for the LocalSqlServer connection? Not sure ...