I get the following error after setting up a new store as a demo...we have been having problems with our existing store after the last patch and I wanted to set up a fresh one for comparison.


I checked the Web.config file and this entry only exists in this one place.

Rob

<H1>Server Error in '/DemoStore' Application.
<HR width="100%" color=silver SIZE=1>
</H1>
<H2>Configuration Error </H2>
[color=#ffffcc>

[tr ][td ]<CODE>
Line]Line 35: &lt;connectionStrings&gt;
Line 36: &lt;add name="Bvc5Database" connectionString="Data Source=WEBDEV1;Initial Catalog=DemoStore;Integrated Security=True;Application Name=BVC5SiteManager"/&gt;
[/color]Line 37: &lt;/connectionStrings&gt;
Line 38: &lt;system.web&gt;</PRE>[/code][/td][/tr]</TABLE>


<B>

<FONT face=Verdana>Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42 &lt;!--
[ConfigurationErrorsException]: The entry 'Bvc5Database' has already been added. (c:\inetpub\wwwroot\DemoStore\web.config line 36)
at System.Configuration.BaseConfigurationRecord.EvaluateOne(String[] keys, SectionInput input, Boolean isTrusted, FactoryRecord factoryRecord, SectionRecord sectionRecord, Object parentResult)
at System.Configuration.BaseConfigurationRecord.Evaluate(FactoryRecord factoryRecord, SectionRecord sectionRecord, Object parentResult, Boolean getLkg, Boolean getRuntimeObject, Object& result, Object& resultRuntimeObject)
at System.Configuration.BaseConfigurationRecord.GetSectionRecursive(String configKey, Boolean getLkg, Boolean checkPermission, Boolean getRuntimeObject, Boolean requestIsHere, Object& result, Object& resultRuntimeObject)
at System.Configuration.BaseConfigurationRecord.GetSection(String configKey, Boolean getLkg, Boolean checkPermission)
at System.Configuration.BaseConfigurationRecord.GetSection(String configKey)
at System.Web.Configuration.HttpConfigurationSystem.System.Configuration.Internal.IInternalConfigSystem.GetSection(String configKey)
at System.Configuration.ConfigurationManager.GetSection(String sectionName)
at System.Configuration.ConfigurationManager.get_ConnectionStrings()
at System.Web.Configuration.WebConfigurationManager.get_ConnectionStrings()
at BVSoftware.Bvc5.Core.WebAppSettings.get_ConnectionString()
at BVSoftware.Bvc5.Core.Datalayer.DataRequest..ctor()
at BVSoftware.Bvc5.Core.WebAppSettings.Mapper.Find(String settingName)
at BVSoftware.Bvc5.Core.WebAppSettings.GetSettingFromDB(String settingName)
at BVSoftware.Bvc5.Core.WebAppSettings.GetStringSetting(String settingName)
at BVSoftware.Bvc5.Core.WebAppSettings.GetEncryptedStringSetting(String settingName)
at BVSoftware.Bvc5.Core.WebAppSettings.get_PaypalUserName()
at ASP.global_asax..cctor()
[TypeInitializationException]: The type initializer for 'ASP.global_asax' threw an exception.
[TargetInvocationException]: Exception has been thrown by the target of an invocation.
at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandle& ctor, Boolean& bNeedSecurityCheck)
at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean fillCache)
at System.RuntimeType.CreateInstanceImpl(Boolean publicOnly, Boolean skipVisibilityChecks, Boolean fillCache)
at System.Activator.CreateInstance(Type type, Boolean nonPublic)
at System.RuntimeType.CreateInstanceImpl(BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes)
at System.Activator.CreateInstance(Type type, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes)
at System.Web.HttpApplicationFactory.GetSpecialApplicationInstance()
at System.Web.HttpApplicationFactory.FireApplicationOnStart(HttpContext context)
at System.Web.HttpApplicationFactory.EnsureAppStartCalled(HttpContext context)
at System.Web.HttpApplicationFactory.GetApplicationInstance(HttpContext context)
at System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
--&gt;

Also,

Check your web.config file because it probably already has a connection strings section.

Is the error staying the same as above? If it is still saying that the entry already exists, then you need to check your machine.config file, and also check any folders above this web.config to make sure that you don't have any other web.config files that are being loaded up first. Asp.net allows a different web.config in each folder of a website.

Rob, what happens when you try to view the store side.

Remove the "/bvadmin/" and anything after from the URL and try again.

Do you see any error messages?

The "can't find table" error comes from a permissions (DB permissions) problem.

Nick,


We had the store working just fine until I tried to install a new demo store. The only problem there was that it Overwrote the existing SQL database.



I am familiar enough with SQL2005 to go over the settings.



Rob

Nick

SQL Server is installed with mixed mode authentication

Nick,


That did it. Thanks a lot. I don't know why this suddenly changed, we never had to go through this with the initial setup, but it is working agin.



Rob