I mistakenly posted this in the general
accelerators forum, and felt like it was actually more appropriate to post here....
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:
<add name="Xrm" connectionString="Authentication Type=AD; Server=http://myserver:myport/MyOrgName; User ID=mydomain\crmwebuser; Password=thepassword" />
And my membership provider:
<add connectionStringName="Xrm" applicationName="/" enablePasswordRetrieval="false"
requiresUniqueEmail="true" passwordFormat="Hashed" minRequiredPasswordLength="1"
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?