Cannot find Business Intelligence Project Type in Visual studio 2003

  • Hello,

    I have VS 2003 installed on my laptop(Windows Xp). I have installed SQL Server 2000 Client Tools. When I open up new project in VS 2003, I could not see Business Intelligence Project Type.

    I wanted to create Reports and Delpoy it on to SSRS 2000 Server.

    (I also have SQL Server 2005 Client Tools and VS 2005 on my system and could see BI project type here)

    Please help me.

    -RK

  • thisguyrox (3/19/2010)


    Hello,

    I have VS 2003 installed on my laptop(Windows Xp). I have installed SQL Server 2000 Client Tools. When I open up new project in VS 2003, I could not see Business Intelligence Project Type.

    I wanted to create Reports and Delpoy it on to SSRS 2000 Server.

    (I also have SQL Server 2005 Client Tools and VS 2005 on my system and could see BI project type here)

    Please help me.

    -RK

    SSRS 2000 was an add on to SQL Server 2000 when SQL Server 2000 is SP3a in 2004 so to get those tools require contacting Microsoft with your license. However a simpler solution is to use SQL Server 2005 SSRS implementation with the 2005 tools and use SQL Server 2000 as your datasource.

    Kind regards,
    Gift Peddie

  • Thanks for the response Gift Peddie.

    I have installed SQL Server 2000 Sp4 on the laptop.

    Also, I am trying to deploy a report on to SSRS 2000 and was not able to do it using VS 2005. (I believe we cannot deploy Report from VS 2005 to SSRS 2000).

    So, trying hard to get BI Projects working on VS 2003.

    Would Microsoft charge me something for this request, We dont have a support license for MS and on SQL Server Standard edition.

  • thisguyrox (3/20/2010)


    Thanks for the response Gift Peddie.

    I have installed SQL Server 2000 Sp4 on the laptop.

    Also, I am trying to deploy a report on to SSRS 2000 and was not able to do it using VS 2005. (I believe we cannot deploy Report from VS 2005 to SSRS 2000).

    So, trying hard to get BI Projects working on VS 2003.

    Would Microsoft charge me something for this request, We dont have a support license for MS and on SQL Server Standard edition.

    I am not sure SSRS 2000 runs on SQL Server 2000 standard but both VS2003 and SQL Server 2000 I am not sure are still supported because you can use SQL Server 2005 Express the Tool kit edition in local mode to develop decent reports for free so expecting SSRS 2000 support is not practical. So you should use SQL Server 2005/8 Express toolkit edition to develop the reports for free just make sure you run it in local mode.

    Kind regards,
    Gift Peddie

Viewing 4 posts - 1 through 3 (of 3 total)

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