question

John 5 avatar image
John 5 asked

SSIS not installing on VM

I have been working with a client trying to setup a SSIS package on his virtual server. Here are the paticulars:

  • He is running VMware EXC with 4G ram
  • He has installed SQL 2005 SP3 on the VM
  • When He attempted to SSIS on the VM he received a message indicating that SSIS was installed.
  • The SSIS service is NOT on the VM server.
  • Using logmein.com I was able verify the above conditions. I also uninstalled and restalled SSIS. All looked normal on the reinstall but still no SSIS service.

Does anyone have any thoughts on this issue?? I have not found anything on the web so far.

Thanks in advance for your help and comments.

John

ssisinstallation
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Scot Hauder avatar image Scot Hauder commented ·
Does disabling the Windows firewall on the host and VM server help? If yes you may need to open port TCP 135
0 Likes 0 ·

1 Answer

·
Daniel Ross avatar image
Daniel Ross answered

When you go to add remove programs, and you select Microsoft SQL server 2005 and click on change, the first window that opens shows the instances installed and components.

Mine says;

SQL Server 2005 instances:

MSSQLSERVER: Analysis Services, Database Engine, Reporting Services

SQL SERVER 2005 Common Components

Integration Services

Workstation Components

It may be that there is an extra instance on the server, and ssis is on the wrong one?

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.