installing sql server 2005

Posted on 2009-12-18
Last Modified: 2012-05-08
I need to install sql 2005 dev edition. I need to install all modules and disable ssis. how would I do that. Also, while installing, for the service account, which do i use. should i request for a dedicated domain account?
Question by:sqlserverdba
    LVL 75

    Expert Comment

    by:Aneesh Retnakaran
    if you dont need the ssis . no need to install the "Integration services "
    LVL 5

    Accepted Solution

    For the service account to use, you can use the LOCAL SYSTEM account.
    About the installation, you should not choose installing the Integration Services.but if you want to install all the features and then disable SSIS it's still possible; So install all the features normally, once everything is ok, just go into windows services and disable MSSQL Integration Services. to go to services, right-click on My Computer--> Manage-->Services or go to -->Run then type this:services.msc;
    there you will disable the SSIS service and you're done!

    Featured Post

    IT, Stop Being Called Into Every Meeting

    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!

    Join & Write a Comment

    In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

    745 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

    14 Experts available now in Live!

    Get 1:1 Help Now