SQL Reporting Services

  • Hi All,

    I am getting an error while Building a Report using Report Builder.It is working Fine when the report is builded in local host.And I m getting an error that could not able to connect to the datasource1 while i m using connectionstring with Integrated Security =true(windows Authentication)

    Can any one help on this

  • I encountered an error similar to the one you're getting.

    Try executing your report from the report server in order to get the complete error messsage. I don't believe the entire error message is being passed.

    Check out this link to enable remote errors:

    http://msdn2.microsoft.com/en-us/library/aa337165.aspx

    Check your connection string. Does it have the keyword "Provider="?

    If so, try creating a new data source by using the wizard. At the top of the dialog window you will see a disabled text box for Provider. This should read "SQLClient Data Provider". Your connection string should now start with "Data Source=" instead of "Provider=".

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply