Hi everyone,
I am having a problem with an web application that connects to CRM. I was testing it on dev server and it would work fine but when I tried changing connectionStrings to connect to the production server, I am not able to access views that need db connection. The only difference between the two server is that dev server has crm and db on the same server whereas production server has one server just for its db. I think I might be missing some config information on my web.config.
I receive an error mentioning about SocketException, WebException and InvalidOperationException.
The most interesting one to read is the invalidOperationException one as it says:
“Metadata contains a reference that cannot be resolved: 'http://xxx:5555/AESCRM/XRMServices/2011/Organization.svc?wsdl'.]”.
The link given there is the actual sqlserver address and not the crmserver one, so I think the app is using the data-source given in connectionString to obtain organization service. At the moment I have info about the app under <appSettings>. In IIS, all those config are shown.
Web.config
<connectionStrings>
<add name="XXCRM_MSCRMEntities" connectionString="metadata=res://*/crm.csdl|res://*/crm.ssdl|res://*/crm.msl; provider=System.Data.SqlClient; provider connection string="data source=sqlserver;initial catalog=XXCRM_MSCRM;integrated security=True;MultipleActiveResultSets=True;App=EntityFramework"" providerName="System.Data.EntityClient" />
</connectionStrings>
<appSettings>
<add key="webpages:Version" value="2.0.0.0" />
<add key="webpages:Enabled" value="false" />
<add key="PreserveLoginUrl" value="true" />
<add key="ClientValidationEnabled" value="true" />
<add key="UnobtrusiveJavaScriptEnabled" value="true" />
<add key="crmpassword" value="XXX" />
<add key="server" value="crmserver:5555/XXCRM" />
<add key="username" value="XXX" />
<add key="domain" value="XX" />
</appSettings>
*This post is locked for comments
I have the same question (0)
