Replace WLID with SqlMembershipProvider

Feb 7, 2011 at 11:02 PM
Edited Feb 8, 2011 at 10:12 PM

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 that mydomain\crmwebuser.  Is this part of the problem?