الثلاثاء، 20 أغسطس 2013

SSRS: Cannot create a connection to data source ‘CRM.’ (rsErrorOpeningConnection) Guid should contain 32 digits with 4 dashes


To run the report from the report server Url, you might find that if you are using normal domain account for username/password you will get the following error:


An error has occurred during report processing (rsProcessingAborted) Cannot create a connection to data source ‘CRM.’ (rsErrorOpeningConnection) Guid should contain 32 digits with 4 dashes (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx).

This is because the Username should be 'systemuserid' and the Password should be 'organizationid'. You can get this by running the query against the CRM database:


SELECT fullname, systemuserid, organizationid FROM FilteredSystemUser Order By fullname

ليست هناك تعليقات:

إرسال تعليق