eService ASP problems

Mar 5, 2009 at 4:42 PM
Edited Mar 5, 2009 at 4:47 PM
I am trying to install eService but I am putting it in an environment where the SQL Server instance is on SQL Server 2005 and located on a different Server entirely from the webserver. It seems like no matter what I try, I cannot get the connection string in web.config correct for the sService portal to authenticate a web user.
The CRM application and the portal are installed on VSCRM while SQL Server 2005 is on a server named VSSQL. 
At the bottom is the web.cfg as I have it right now. I have tried many things but I can't seem to get the connection strings right. What fixes one problem just creates other problems.
Currently, the error I get if I try to click on a registration link in an email is:

 

Server Error in '/' Application.

Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.


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.Data.SqlClient.SqlException: Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.

Source Error:

Line 44: 		_contactId = new Guid(plainText);
Line 45: 		CreateUserWizard1.CreatedUser += new EventHandler(CreateUserWizard1_CreatedUser);
Line 46: ProfileInfoCollection allProfiles = ProfileManager.GetAllProfiles(ProfileAuthenticationOption.Authenticated);Line 47: 		foreach (ProfileInfo profileInfo in allProfiles)
Line 48: 		{

Source File: c:\Program Files\Microsoft Dynamics CRM Customer Portal\Controls\CreateUserAccount.ascx.cs    Line: 46

Stack Trace:

[SqlException (0x80131904): Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +1950890
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4846875
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2392
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +204
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +954
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162
   System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +175
   System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +137
   System.Web.Util.SecUtility.CheckSchemaVersion(ProviderBase provider, SqlConnection connection, String[] features, String version, Int32& schemaVersionCheck) +378
   System.Web.Profile.SqlProfileProvider.CheckSchemaVersion(SqlConnection connection) +69
   System.Web.Profile.SqlProfileProvider.GetProfilesForQuery(SqlParameter[] args, ProfileAuthenticationOption authenticationOption, Int32 pageIndex, Int32 pageSize, Int32& totalRecords) +987
   System.Web.Profile.SqlProfileProvider.GetAllProfiles(ProfileAuthenticationOption authenticationOption, Int32 pageIndex, Int32 pageSize, Int32& totalRecords) +40
   System.Web.Profile.ProfileManager.GetAllProfiles(ProfileAuthenticationOption authenticationOption) +36
   Controls_CreateUserAccount.OnLoad(EventArgs e) in c:\Program Files\Microsoft Dynamics CRM Customer Portal\Controls\CreateUserAccount.ascx.cs:46
   System.Web.UI.Control.LoadRecursive() +50
   System.Web.UI.Control.LoadRecursive() +141
   System.Web.UI.Control.LoadRecursive() +141
   System.Web.UI.Control.LoadRecursive() +141
   System.Web.UI.Control.LoadRecursive() +141
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627


Version Information: Microsoft .NET Framework Version:2.0.50727.3082; ASP.NET Version:2.0.50727.3082 <!-- [SqlException]: Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at System.Web.Util.SecUtility.CheckSchemaVersion(ProviderBase provider, SqlConnection connection, String[] features, String version, Int32& schemaVersionCheck) at System.Web.Profile.SqlProfileProvider.CheckSchemaVersion(SqlConnection connection) at System.Web.Profile.SqlProfileProvider.GetProfilesForQuery(SqlParameter[] args, ProfileAuthenticationOption authenticationOption, Int32 pageIndex, Int32 pageSize, Int32& totalRecords) at System.Web.Profile.SqlProfileProvider.GetAllProfiles(ProfileAuthenticationOption authenticationOption, Int32 pageIndex, Int32 pageSize, Int32& totalRecords) at System.Web.Profile.ProfileManager.GetAllProfiles(ProfileAuthenticationOption authenticationOption) at Controls_CreateUserAccount.OnLoad(EventArgs e) in c:\Program Files\Microsoft Dynamics CRM Customer Portal\Controls\CreateUserAccount.ascx.cs:line 46 at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) [HttpUnhandledException]: Exception of type 'System.Web.HttpUnhandledException' was thrown. at System.Web.UI.Page.HandleError(Exception e) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest() at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context) at System.Web.UI.Page.ProcessRequest(HttpContext context) at ASP.createuseraccount_aspx.ProcessRequest(HttpContext context) in c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\0a61a278\c03e1fcb\App_Web_dtz8jijy.2.cs:line 0 at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) -->

************************************************************************************************************************
I am assuming this is because my connection strings are incorrect but I am not sure at this point. I have wasted over 12 hours trying to solve this and I am at my wits end at this point.
************************************************************************************************************************

<?xml version="1.0"?>
<configuration>
 <!-- Register a new config section-->
 <configSections>
  <section name="SmallBusinessDataProviders" type="SmallBusinessDataProvidersSection" requirePermission="false"/>
 </configSections>
 <!-- Connection string, currently configured for SQL Express-->
 <connectionStrings>
  <remove name="SQLConnectionString"/>
  <remove name="LocalSqlServer"/>
  <add name="SQLConnectionString" connectionString="Data Source=VSSQL;integrated

security=true;AttachDBFilename=|DataDirectory|TestCompany_MSCRM.mdf;User Instance=true"/>
  <!--This setting is for the asp.net membership store db-->
    <add name="LocalSqlServer" connectionString="Data Source=VSSQL;Integrated Security=true"/>
 </connectionStrings>
 <appSettings>
  <!--
  These settings are for the portal pages and controls to call the
  crm web services. If you are setting this up on the stndard vpc image then
  set the domain value to "." if you are having problems.
  -->
  <add key="msa.CRMOrganizationName" value="TestCompany"/>
  <add key="msa.CRMServerUrl" value="http://VSCRM/MSCRMServices"/>
  <add key="msa.CRMWebServicesUser" value="crmwebuser"/>
  <add key="msa.CRMWebServicesPassword" value="rosebud1!"/>
  <add key="msa.CRMDomain" value="DOMAIN"/>
 </appSettings>
 <!-- Register the providers and specify which ones to use for data access for each of the 4 pages-->
 <SmallBusinessDataProviders peopleProviderName="xmlProvider" testimonialsProviderName="xmlProvider" catalogProviderName="xmlProvider"

newsProviderName="xmlProvider">
  <!-- Register providers for People - Similarly for other pages-->
  <PeopleProviders>
   <add name="sqlProvider" type="SqlPeopleProvider" connectionStringName="SQLConnectionString"/>
   <add name="xmlProvider" type="XmlPeopleProvider" schemaFile="People.xsd" dataFile="People.xml"/>
  </PeopleProviders>
  <TestimonialsProviders>
   <add name="sqlProvider" type="SqlTestimonialProvider" connectionStringName="SQLConnectionString"/>
   <add name="xmlProvider" type="XmlTestimonialProvider" schemaFile="Testimonials.xsd" dataFile="Testimonials.xml"/>
  </TestimonialsProviders>
  <CatalogProviders>
   <add name="sqlProvider" type="SqlCatalogProvider" connectionStringName="SQLConnectionString"/>
   <add name="xmlProvider" type="XmlCatalogProvider" schemaFile="Items.xsd" dataFile="Items.xml"/>
  </CatalogProviders>
  <NewsProviders>
   <add name="sqlProvider" type="SqlNewsProvider" connectionStringName="SQLConnectionString"/>
   <add name="xmlProvider" type="XmlNewsProvider" schemaFile="News.xsd" dataFile="News.xml"/>
  </NewsProviders>
 </SmallBusinessDataProviders>
  <system.net>
 <!--These mail settings are used if the send kb setting is set to SMTP-->
    <mailSettings>
      <smtp from="emailaddress@domain.com" deliveryMethod="Network">
        <network host="mailservername" port="25" />
      </smtp>
    </mailSettings>
  </system.net>
  <system.web>
<membership defaultProvider="AspNetSqlMembershipProvider">
<providers>
<remove name="AspNetSqlMembershipProvider"/>
<add connectionStringName="LocalSqlServer" name="AspNetSqlMembershipProvider" enablePasswordRetrieval="false" enablePasswordReset="true"

applicationName="/" requiresUniqueEmail="false" passwordFormat="Hashed" maxInvalidPasswordAttempts="5" minRequiredPasswordLength="6"

minRequiredNonalphanumericCharacters="0" passwordAttemptWindow="10" passwordStrengthRegularExpression="" requiresQuestionAndAnswer="true"

type="System.Web.Security.SqlMembershipProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
</providers>
</membership>
  <globalization culture="auto" uiCulture="auto" enableClientBasedCulture="true"/>
  <profile>
   <properties>
    <add name="ContactId" allowAnonymous="false" type="System.Guid"/>
   </properties>
  </profile>
  <identity impersonate="true"/>
  <authentication mode="Forms">
   <forms loginUrl="CustomerLogin.aspx"/>
  </authentication>
  <customErrors mode="Off" />
  <pages theme="Standard">
   <!--This registers the user controls fr use in the web portal-->
   <controls>
    <add tagPrefix="msa" tagName="NotesEditor" src="~/Controls/NotesEditor.ascx" />
    <add tagPrefix="msa" tagName="CasesGrid" src="~/Controls/CasesGrid.ascx" />
    <add tagPrefix="msa" tagName="CaseEditor" src="~/Controls/CaseEditor.ascx" />
    <add tagPrefix="msa" tagName="KBSearch" src="~/Controls/KBSearch.ascx" />
    <add tagPrefix="msa" tagName="NewEntity" src="~/Controls/NewEntity.ascx" />
    <add tagPrefix="msa" tagName="ViewKBArticle" src="~/Controls/ViewKBArticle.ascx" />
    <add tagPrefix="msa" tagName="ServiceScheduler" src="~/Controls/ServiceScheduler.ascx" />
    <add tagPrefix="msa" tagName="ScheduledServicesGrid" src="~/Controls/ScheduledServicesGrid.ascx" />
    <add tagPrefix="msa" tagName="ProfileEditor" src="~/Controls/ProfileEditor.ascx" />
    <add tagPrefix="msa" tagName="CreateUserAccount" src="~/Controls/CreateUserAccount.ascx" />
    <add tagPrefix="msa" tagName="Login" src="~/Controls/LoginControl.ascx" />
   </controls>
  </pages>  
  <httpHandlers>
   <remove verb="*" path="*.asmx"/>
  </httpHandlers>
  <compilation debug="true"/></system.web>
 <system.codedom>
 </system.codedom>
 <system.webServer>
  <validation validateIntegratedModeConfiguration="false"/>
  <modules>
   <remove name="ScriptModule"/>
  </modules>
  <handlers>
   <remove name="WebServiceHandlerFactory-Integrated"/>
   <remove name="ScriptHandlerFactory"/>
   <remove name="ScriptHandlerFactoryAppServices"/>
   <remove name="ScriptResource"/>
  </handlers>
 </system.webServer>
 <location path="CustomerService" >
  <system.web>
   <authorization>
    <deny users="?"/>
   </authorization>
  </system.web>
 </location> 
 <location path="eService" >
  <system.web>
   <authorization>
    <deny users="?"/>
   </authorization>
 
</system.web>  

 </location> 
</configuration>