sql server - MvcSiteMapNodeProvider with security trimming enabled throws sql exception -


when run mvc5 ef6 mssql 2012 application receive following exception.

excetption

i tracked issue down line in config

<add key="mvcsitemapprovider_securitytrimmingenabled" value="true" /> 

once remove line, site builds properly, off course security trimming off menus broken.

the whole appsettings section follows

<appsettings> <add key="webpages:version" value="3.0.0.0" /> <add key="webpages:enabled" value="false" /> <add key="clientvalidationenabled" value="true" /> <add key="unobtrusivejavascriptenabled" value="true" /> <add key="skipapplicationauthorizationrole" value="developer" /> <add key="mvcsitemapprovider_useexternaldicontainer" value="false" /> <add key="mvcsitemapprovider_scanassembliesforsitemapnodes" value="false" /> <add key="mvcsitemapprovider_includeassembliesforscan" value="triton.web" /> <add key="mvcsitemapprovider_securitytrimmingenabled" value="true" /> <add key="mvcsitemapprovider_attributestoignore" value="type" /> <add key="mvcsitemapprovider_defaultsitemapnodevisibiltyprovider" value="mvcsitemapprovider.filteredsitemapnodevisibilityprovider, mvcsitemapprovider" /> <add key="mvc" /> <add key="twilio.sid" value="pnf8944dec9bf751ad111f87e1a7ece2b3" /> <add key="twilio.token" value="2d1a16e5f7109c56307cc6b696ff1de4" /> <add key="twilio.phone" value="3362522181" /> 

any thoughts on how resolve issue?

edit forgot mention when run locally connection string point production sql server, not problem, provide connection string nonetheless.

<add name="defaultconnection" connectionstring="data source=localhost;initial catalog=name; user id=user;password=password;integrated security=false;" providername="system.data.sqlclient" /> 

adding following code web.config fixed issue. overrides other config files on hosting companies server keys.

<membership>   <providers>     <clear />     <add name="aspnetsqlmembershipprovider" type="system.web.security.sqlmembershipprovider" connectionstringname="defaultconnection" enablepasswordretrieval="false" enablepasswordreset="true" requiresquestionandanswer="false" requiresuniqueemail="false" maxinvalidpasswordattempts="5" minrequiredpasswordlength="6" minrequirednonalphanumericcharacters="0" passwordattemptwindow="10" applicationname="/" />   </providers> </membership> <profile>   <providers>     <clear />     <add name="aspnetsqlprofileprovider" type="system.web.profile.sqlprofileprovider" connectionstringname="defaultconnection" applicationname="/" />   </providers> </profile> <rolemanager enabled="false">   <providers>     <clear />     <add name="aspnetsqlroleprovider" type="system.web.security.sqlroleprovider" connectionstringname="defaultconnection" applicationname="/" />     <add name="aspnetwindowstokenroleprovider" type="system.web.security.windowstokenroleprovider" applicationname="/" />   </providers> </rolemanager> 

Comments