hi,
on a box set with 2003 Server (x64), I setup sql 2005 Server (x64) with
SSIS. Then SP2.The sql server installed fine, but SSIS did not install.
Then I installed Sharepoint Server.
Now I need to add SSIS, but when I try to run Sql server Setup, I noticed
that check boxes for already installed components - such as sql server - are
NOT greyed out, this looks like the setup wants to install a new sql server
instance (or mess up the already installed instance).
Is there a way to just add the missing SSIS to the already installed (and
working) sql server instance without starting from scratch (that is without
un-installing Sharepoint) ?
Thanks.

Hi there,

As you said you chose SSIS in SQL Server Setup and it didn't install, then
there may be a problem arised while SQL Server Setup installing SQL Server
services and components.

So, I think you better start by checking installed SQL Server services and
components. To do this, go to SQL Server Configuration Manager and there,
you'll see SQL Server 2005 Services node at the left pane and when you click
it you'll see the installed SQL Server services at the right pane. If you
see "SQL Server Integration Services" on the list, then it means it's
installed and may not be running? See its status on the same list.

If you can't see SSIS in the list then you can install SSIS without
uninstalling and installing SQL Server from scratch. To perform this, go to
Control Panel -> Add\Remove Programs. There you'll see SQL Server 2005,
click on it and click on the Change button and proceed. There you can
install SSIS.

Another way is to start SQL Server Setup and simply install SSIS.

--
Ekrem Önsoy



"NewToSql" <NoOne@hotmail.com> wrote in message
news:ep$KjA1qIHA.4884@TK2MSFTNGP06.phx.gbl...
> hi,
> on a box set with 2003 Server (x64), I setup sql 2005 Server (x64) with
> SSIS. Then SP2.The sql server installed fine, but SSIS did not install.
> Then I installed Sharepoint Server.
> Now I need to add SSIS, but when I try to run Sql server Setup, I noticed
> that check boxes for already installed components - such as sql server -
> are NOT greyed out, this looks like the setup wants to install a new sql
> server instance (or mess up the already installed instance).
> Is there a way to just add the missing SSIS to the already installed (and
> working) sql server instance without starting from scratch (that is
> without un-installing Sharepoint) ?
> Thanks.
>
>