Do I need to install Visual Studio 2005 SP1 on my SQL Server 2005 server?

Posted on 2010-01-05
Last Modified: 2013-11-26
I have a database server running Windows Server 2003, and SQL Server 2005.

When I originally installed SQL Server 2005, it installed a version of Visual Studio 2005.  It was never clear to me whether it was a full version of the software.

Now I see there is a Visual Studio 2005 SP1 available.

Is it safe to instal VS 2005 SP1 on my database server?  My concern is that the VS 2005 version I have might not not be a full version.

Question by:eeaccount2
    LVL 57

    Accepted Solution

    >> Is it safe to instal VS 2005 SP1 on my database server?  

    As far as Microsoft products are concerned, its recommended to stay up to date with the latest Service Packs and patches.
    And hence its safe to go for VS 2005 SP1

    Also apply SQL Server 2005 SP3 since it is available..

    >> My concern is that the VS 2005 version I have might not not be a full version.

    Yes, You are correct..
    Visual Studio 2005 installed as part of your SQL Server 2005 installation would consists of only the basic set of features required for SQL Server 2005 and hence it is not a Full version..
    But you can apply SP1 for this version too..
    LVL 24

    Expert Comment

    What would have been installed is the IDE for BIS (Business Intellegance Suite) IE Reporting Services development

    Author Closing Comment

    LVL 57

    Expert Comment

    by:Raja Jegan R

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    More often than not, we developers are confronted with a need: a need to make some kind of magic happen via code. Whether it is for a client, for the boss, or for our own personal projects, the need must be satisfied. Most of the time, the Framework…
    In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now