Install help

I have recently inherited a Windows 2003 server box that has both
SQLExpress installed along with a Named 2005 instance. The problem I'm
having is that on the named instance they didn't(or it failed) install
Integrated Services. I went into add/remove programs and tried to change the
install options(add SSIS). I choose the named Instance but it never allows
me choose Integrated Services to install.
How can I get SSIS installed?
I looked at the folder structure and the named instance doesn't have
reference to SSIS being there.
Thanks.
SSIS isn't instance aware. Or rather, you cannot have several instances in SSIS, and basically SSIS
isn't tied to a specific instance. I haven't done this myself, but I'd just run setup from the
install DVD and add SSIS from there.
There's is one connection for SSIS to an instance, and this is in which MSDB to store the packages,
and you configure this in below XML file (after installation):
C:\Program Files\Microsoft SQL Server\90\DTS\Binn\MsDtsSrvr.ini.xml
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"AHartman" <Hoosbruin@.Kconline.com> wrote in message news:unCHtdj2HHA.3764@.TK2MSFTNGP04.phx.gbl...
> I have recently inherited a Windows 2003 server box that has both SQLExpress installed along with
> a Named 2005 instance. The problem I'm having is that on the named instance they didn't(or it
> failed) install Integrated Services. I went into add/remove programs and tried to change the
> install options(add SSIS). I choose the named Instance but it never allows me choose Integrated
> Services to install.
> How can I get SSIS installed?
> I looked at the folder structure and the named instance doesn't have reference to SSIS being
> there.
>
> Thanks.
|||This file exists "C:\Program Files\Microsoft SQL
Server\90\DTS\Binn\MsDtsSrvr.ini.xml" but I still don't have any service to
start?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:e3WL1hl2HHA.3940@.TK2MSFTNGP05.phx.gbl...
> SSIS isn't instance aware. Or rather, you cannot have several instances in
> SSIS, and basically SSIS isn't tied to a specific instance. I haven't done
> this myself, but I'd just run setup from the install DVD and add SSIS from
> there.
> There's is one connection for SSIS to an instance, and this is in which
> MSDB to store the packages, and you configure this in below XML file
> (after installation):
> C:\Program Files\Microsoft SQL Server\90\DTS\Binn\MsDtsSrvr.ini.xml
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "AHartman" <Hoosbruin@.Kconline.com> wrote in message
> news:unCHtdj2HHA.3764@.TK2MSFTNGP04.phx.gbl...
>
|||You need to modify that file so that it will point to your
named instance. Modify the section for the server:
<ServerName>.</ServerName>
to point to your named instance:
<ServerName>ServerName\InstanceName</ServerName>
There is a topic in books online that explains this. Look up
the topic:
Configuring the Integration Services Service
and check the section regarding configuring a named
instance.
-Sue
On Thu, 9 Aug 2007 05:44:05 -0400, "AHartman"
<Hoosbruin@.Kconline.com> wrote:
[vbcol=seagreen]
>This file exists "C:\Program Files\Microsoft SQL
>Server\90\DTS\Binn\MsDtsSrvr.ini.xml" but I still don't have any service to
>start?
>
>
>
>"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
>message news:e3WL1hl2HHA.3940@.TK2MSFTNGP05.phx.gbl...