installing sql server 2005

Posted on 2009-12-18
Medium Priority
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
ID: 26082049
if you dont need the ssis . no need to install the "Integration services " 


Accepted Solution

spikelly earned 500 total points
ID: 26091029
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

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
Loops Section Overview
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?

809 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