Edit button is grayed out in Shared Data Source Properties when setting up Visual Studio/BIDS for reporting

Version 1

    Details

    When setting up Business Intelligence Development Studio to directly connect to the Staging database, in step 5 of the process document, the Edit button for the Connection String on the Shared Data Source Properties screen is grayed our and inoperative.


    Resolution

     

    Visual Studio 2010 doesn't support Reporting services


    From Microsoft:

    Microsoft Visual Studio 2010 does not support Business Intelligence Development Studio Integration Services, Report Services and Analysis Services projects for SQL Server 2008 and SQL Server 2008 R2. To work around this issue, you can install Visual Studio 2008 alongside Visual Studio 2010 on the same machine and then open the Business Intelligence Development Studio projects in Visual Studio 2008.