Dynamics CRM Customer Portal Accelerator Installation

Posted by saturdayplace on Stack Overflow See other posts from Stack Overflow or by saturdayplace
Published on 2011-02-08T23:21:59Z Indexed on 2011/02/08 23:25 UTC
Read the original article Hit count: 618

Filed under:
|
|

(I've posted this question on the codeplex forums too, but have yet to get a response)

I've got an on-premise installation of CRM and I'm trying to hook the portal to it. My connection string in web.config:

<connectionStrings>
    <add name="Xrm" connectionString="Authentication Type=AD; Server=http://myserver:myport/MyOrgName; User ID=mydomain\crmwebuser; Password=thepassword" />
</connectionStrings>

And my membership provider:

<membership defaultProvider="CustomCRMProvider">
    <providers>
          <add connectionStringName="Xrm" applicationName="/" enablePasswordRetrieval="false"
             enablePasswordReset="true" requiresQuestionAndAnswer="false"
             requiresUniqueEmail="true" passwordFormat="Hashed" minRequiredPasswordLength="1"
             minRequiredNonalphanumericCharacters="0" name="CustomCRMProvider"
             type="System.Web.Security.SqlMembershipProvider" />
    </providers>
</membership>

Now, I'm super new to MS style web development, so please help me if I'm missing something. In Visual Studio 2010, when I go to Project > ASP.NET Configuration it launches the Web Site Administration Tool. When I click the Security Tab there, I get the following error:

There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store.

The following message may help in diagnosing the problem: An error occurred while attempting to initialize a System.Data.SqlClient.SqlConnection object. The value that was provided for the connection string may be wrong, or it may contain an invalid syntax. Parameter name: connectionString

I can't see what I'm doing wrong here. Does the user mydomain\crmwebuser need certain permissions in the SQL database, or somewhere else?

edit:

On the home page of the Web Site Administration Tool, I have the following:

**Application**:/

**Current User Name**:MACHINENAME\USERACCOUNT 

Which is obviously a different set of credentials than mydomain\crmwebuser. Is this part of the problem?

© Stack Overflow or respective owner

Related posts about ASP.NET

Related posts about dynamics-crm