Dynamics CRM 4.0 SQL Reports XML Connection String
Posted on 2011-04-27
"An error has occurred during report processing.
Cannot create a connection to data source 'LASER'."
<ConnectString>Data Source=MySQLServer;User ID=SA; Password=Password;Initial Catalog=LASER</ConnectString>
I created a report in SQL Reports using .net 2005 and imported it into CRM. The data source is on a SQL Server other than the CRM SQL Server. I got this error so I tried editing the XML Connection String by adding User ID and Password, but I don't know if this is correct as I do not know XML. I still get the same error. Is there a correct way to code the connection string or is there another way using CRM to connect to the SQL Data source? I have previously created and imported a report that uses the CRM data only.