What are the challenges you face when working across database platforms? Take the survey

SSAS & SSRS Unhandled exception trying to connent

cwalliscwallis Posts: 6
edited November 18, 2011 1:17PM in SQL Prompt Previous Versions

Using SSMS 2008 R2 and SQL Prompt

When trying to connect to either SSAS or SSRS from SSMS we receive an Microsoft .NET Framework error:

Unhandled exception has occurred in a component in your application. If you click Continue, the application will ignore this error and attempt to continue.
Value cannot be null.
Parameter name: Data Source

If we try from a machine that does not have SQL Prompt installed you can connect without error.

Can post the error details if required, but quite long!



  • Options
    Hi Chris,

    Thanks for the feedback - and sorry to hear Prompt's not playing nicely!

    If you could PM me the error details, that'd be really useful.

    Additionally - could you also include the version of the Analysis/Reporting servers you're trying to connect to, and any other SSMS add-ins (Red-Gate or otherwise) installed on the machine (such as our SQL Search).

    Thanks again,
    James Allison

    Software Engineer - SQL Prompt
    Red Gate Software Ltd.
Sign In or Register to comment.