asked on

CRM 2011 Error Connecting to Report Datasource

Hi

I am modifying some old SSRS reports and I am having a problem connecting to datasource (named CRM). When I run Test Connection, I receive the attached error message.

I need to eliminate this error to make progress on updating the reports.

Thanks
test_connection.png

Feridun Kadir

Still having trouble I see. Try changing localhost to the actual name of the SQL Server, also if you are using a non-default instance you need to specify that too, like this, SERVERNAME\INSTANCENAME

apollo7

ASKER

Thanks, will try these suggestions

apollo7

ASKER

Tried reworking the CRM datasource and seem to making progress.

Also I attached an image of the revised,shared dataset CRM (it is using OLE DB and it shared not embedded)

I am spinning my wheels, however, trying different combinations of the shared datasource, I have attached one.

I am assuming my datasource should point at the related SQL server

Thanks

Thanks
login_fail.png

Feridun Kadir

1) Don't use a shared data source, I don't think that works with CRM
2) You should select just SQL Server, don't go with OLE DB

apollo7

ASKER

Here is the setup I have now for adding new fields to this report:

This is the CRM DataSource, (not shared)

This is DataSet1, based on the CRM DataSource

As you can see, there is some involved SQL that currently works with the report fields as originally added

When I try to use Query Designer, I get the following error which seems to indicate a problem with authentication:

ASKER CERTIFIED SOLUTION

Feridun Kadir

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

apollo7

ASKER

This did the trick, thanks alot