VSI Templates install failed

I just installed SQL2005 (and VS2005). When I run VSSQLCLRTemplates.vsi from the SQLCLR Project all the templates fail to install. It gives the error "Installation stopped because the directory for the ProjectType value did not exist. The project type is invalid for your installation of Visual Studio."


I do have a \my documents\visual studio 2005\ directory. I am trying to start writting user defined aggregates. If I can install the templates manually, that'd be fine.

Thanks in advance.


Answer this question

VSI Templates install failed

  • sk1234

    Yes this is the VS that comes with SQL Server 2005. So are you saying I need to get a "full" version of VS and I can't use the one bundled with SQL

    Thanks for your help!

  • easyjiggle

    Hi,
    I'm the guy responsible for the SQLCLRProject. My assumption is that you try and run the VSI file on the VS environment installed by SQL Server. I.e. you have not done a separate install of VS

    If so, it won't work my templates requires support for C#/VB.NET and the SQL installation of VS does not install that support.

    If you're not running on the SQL VS, please drop me an email and I'll see what I can do.

    Niels

  • Sara_111

    Okay, that's not a big deal. One more question please just to clarify things, the VS that comes with SQL2005 doesn't allow me to create any kind of "sql server template" I have templates for Analysis services, Reporting services, but nothing that lets me build assemblys like UDAGGs. Are your templates the only way to create these assemblys seeing how I did not have anything comparable by default.

    Thanks for your time!

  • Geethanga

    Nielsb, thank you so much for your replies.

    I had exactly the same problem installing other software and got the same dreaded error.

    Checking the installed version of VS 2005, I noticed this version was automatically installed
    with SQL Server 2005 Enterprise Edition.

    Your replies got me on the right track. Thanks!


  • Sean A.

    The fiull blown VS, has templates for aggregates, functions etc. The version that comes with SQL has only BI (Business Intelligence) functionality.

    Niels


  • netk

    Yes, unfortunately that is what I am saying.

    Niels

  • VSI Templates install failed