• Question

  • I started this publishing process about a month ago.  First I was informed that its as simple as a click on the build menu.  This was useful and got me started.  I discovered some run-time errors in the course of executing a task.  I was moving my task and other information via FTP to my server.  The menu I have built executes fine and the only problem I have is in running simple task involving sqlserver express.  I should also note that everything works fine on my local server.  I eliminated a couple of runtime errors by merely setting the framework to 4.0 on the providing host machine  (as it is on my own).  Finally, I got a clean bill of health when I clicked "PUBLISH".  A website directory labeled as precompiled was created.  I ftp'd the webfile in that directory to my host.  Result was as shown below.  This indicated to me that at least I am when I tried on the server, was missing connection strings information that I believe is included in the "WEB.CONFIG" file.  One of my problems is understanding what is supposed to happen when I "Publish".

    Moving on as if I know what I am doing, I FTP'd my WEB file to the remote and at least changed the error  (profuse output pasted in below).  Don't know where to go from here.  All that I am looking for is how to configure the application to run the sqlserver related task.  This is all I have sought from the get-go, and no one has given me a working answer.  

    My partial server dump is pasted below below.  Below that, is my web.config file.  If someone can glean anything from what I have said and conveyed, I will be appreciative.  I will welcome offers to consult for pay as well.

    Server Error in '/' Application.

    Invalid value for key 'attachdbfilename'.

    Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

    Exception Details: System.ArgumentException: Invalid value for key 'attachdbfilename'.

    Source Error:
    An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

    Stack Trace:
    [ArgumentException: Invalid value for key 'attachdbfilename'.]
       System.Data.SqlClient.SqlConnectionString.VerifyLocalHostAndFixup(String& host, Boolean enforceLocalHost, Boolean fixup) +907278
       System.Data.SqlClient.SqlConnectionString..ctor(String connectionString) +4116
       System.Data.SqlClient.SqlConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous) +24
       System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(String connectionString, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions) +150
       System.Data.SqlClient.SqlConnection.ConnectionString_Set(String value) +59
       System.Data.SqlClient.SqlConnection.set_ConnectionString(String value) +4


    <?xml version="1.0"?>

      For more information on how to configure your ASP.NET application, please visit

        <add name="ApplicationServices" connectionString="data source=SQL2008_835653_juledvd;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|\aspnetdb.mdf;User Instance=true"
          providerName="System.Data.SqlClient" />
        <add name="JulieDVDConnectionString" connectionString="Data Source=SQL2008_835653_juledvd;AttachDBFilename=|DataDirectory|\aspnetdb.mdf;User Instance=true"
          providerName="System.Data.SqlClient" />

        <compilation debug="true" strict="false" explicit="true" targetFramework="4.0" />

        <authentication mode="Forms">
          <forms loginUrl="~/Account/Login.aspx" timeout="2880" />

            <add name="AspNetSqlMembershipProvider" type="System.Web.Security.SqlMembershipProvider" connectionStringName="ApplicationServices"
                 enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="false" requiresUniqueEmail="false"
                 maxInvalidPasswordAttempts="5" minRequiredPasswordLength="6" minRequiredNonalphanumericCharacters="0" passwordAttemptWindow="10"
                 applicationName="/" />

            <add name="AspNetSqlProfileProvider" type="System.Web.Profile.SqlProfileProvider" connectionStringName="ApplicationServices" applicationName="/"/>

        <roleManager enabled="false">
            <add name="AspNetSqlRoleProvider" type="System.Web.Security.SqlRoleProvider" connectionStringName="ApplicationServices" applicationName="/" />
            <add name="AspNetWindowsTokenRoleProvider" type="System.Web.Security.WindowsTokenRoleProvider" applicationName="/" />


         <modules runAllManagedModulesForAllRequests="true"/>


    I  hope this gets to someone who will NOT tell me I have mis-posted!


    • Moved by Tim Lovell-Smith Wednesday, May 2, 2012 6:44 PM your question seems to be about asp.net - please try asp.net forums (From:Windows Workflow Foundation 4)
    Wednesday, May 2, 2012 6:19 PM