3

I have my web config as follows

<?xml version="1.0"?>
<configuration>
<appSettings/>
<connectionStrings>
      <add name="MySqlConnection" connectionString="Data Source=server;Initial    Catalog=BD;User Id=usr; Password=psswd" />
</connectionStrings>
<system.web>
    <!--<authentication mode="Forms" />-->
    <roleManager enabled="true" />
    <compilation debug="true" targetFramework="4.0">
        <assemblies>
            <add assembly="System.Design, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
            <add assembly="System.Web.Extensions.Design, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
            <!--add assembly="System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>-->
        </assemblies>
    </compilation>

    <authentication mode="Forms">
        <forms loginUrl="login.aspx" name=".ASPXFORMSAUTH"/>
    </authentication>
    <authorization>
        <deny users="?" />
    </authorization>


    <membership defaultProvider="SqlProvider" userIsOnlineTimeWindow="15">
        <providers>
            <clear />
            <add
  name="SqlProvider"
  type="System.Web.Security.SqlMembershipProvider"
  connectionStringName="MySqlConnection"
  applicationName="/"
  enablePasswordRetrieval="false"
  enablePasswordReset="true"
  requiresQuestionAndAnswer="true"
  requiresUniqueEmail="true"
  passwordFormat="Hashed" />
        </providers>
    </membership>

    <pages controlRenderingCompatibilityVersion="3.5" clientIDMode="AutoID"/></system.web>
<system.codedom>
</system.codedom>

<system.webServer>
</system.webServer>

<system.web>
    <caching>
        <sqlCacheDependency enabled="true">
            <databases>
                <add name="AtentoMIG"
   connectionStringName="MySqlConnection"
   pollTime="5000" />
            </databases>
        </sqlCacheDependency>
    </caching>
</system.web>
    <location path="MasterPage">
    <system.web>
        <authorization>
            <allow users="*"/>
        </authorization>
    </system.web>
</location> 
<location path="assets">
    <system.web>
        <authorization>
            <allow users="*"/>
        </authorization>
    </system.web>
</location> 

i need to encrypt the connection string but i can't find whats wrong wwith my command it's says that it can't find the property connectionString

this is my command

aspnet_regiis.exe -pef "configuration/connectionStrings" C:\
Jorge
  • 17,896
  • 19
  • 80
  • 126

2 Answers2

5

Drop the configuration/ - it is assumed:

aspnet_regiis.exe -pef "connectionStrings" C:\

Of course, this also assumed that the web.config file is sitting on the root of your c drive.

Oded
  • 489,969
  • 99
  • 883
  • 1,009
0

aspnet_regiis -pef "connectionStrings" "drive:\location\of\web.config\folder\"

and if you have Custom Encryption key it becomes

aspnet_regiis -pef "connectionStrings" "drive:\location\of\web.config\folder\" -prov "CustomProvider"

donkz
  • 313
  • 2
  • 12