SQL Server Integratio Services

I can't connect to SSIS on a SQL Server Workgtroup installation.  When I run the setup, it says its installed, but I can't connect to it using Enterprise Manager (Its in the connect list, but fails when I try).  I have tries to update the installation, but it always says it is already installed.

When I compare to a machine that works, I see that there is no SSIS service installed.

I think that I installed SSIS after the database installation.  It appears that the service was not installed.  How can I correct this.
No1CoderAsked:
Who is Participating?
 
pssandhuCommented:
@No1Coder, I have been reading up it is a limitation of the SQL Server Workgroup edition. I guess you need to install atleast the standard version to get the services installed. You can read more about it here:
http://en.wikipedia.org/wiki/SQL_Server_Integration_Services
http://www.microsoft.com/Sqlserver/2005/en/us/workgroup.aspx
Hope this helps.
P.
0
 
PedroCGDCommented:
No1Coder,
Check if you have the SSIS Service installed. If not, you didn't installed it yet.
Try install again!
Give more feedback!

Regards,
Pedro
0
 
pssandhuCommented:
I would uninstall the whole SQL Server package and do a full load when you load it again. Sometime, when you try to add modules to existing insallation it does not load well. Between, whats the error message you get when you try to connect?
Also, make sure if you have service loaded it is running.
P.
0
Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

 
No1CoderAuthor Commented:
Regarding the first comment, as I said TWICE, I have installed the SSIS.  When I try and reinstall or update, the installer says its installed.  Here is the error message (below) when I connect.

Regarding the second comment, I cannot uninstall and reinstall.  This is a production server.  How can I get the microsoft installer to install the service?
------------------------------
ADDITIONAL INFORMATION:
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
------------------------------
Connect to SSIS Service on machine "FATBOY" failed:
 The specified service does not exist as an installed service.
------------------------------
Connect to SSIS Service on machine "FATBOY" failed:
 The specified service does not exist as an installed service.
---------.


0
 
wolfman007Commented:
Open SQL Server Configuration Manager and verify that SQL Server Intergation Services is listed under the SQL Server 2005 Services.

If it is not listed then it is not installed properly and you will need a reinstall.

If it is listed make sure that it is started, and is running under an appropriate windows account.

How to: Set Properties of Integration Services Service Using SQL Server Configuration Manager
http://msdn.microsoft.com/en-us/library/ms345173(SQL.90).aspx
0
 
PedroCGDCommented:
If you dont have the service you dont have SSIS installed...:-(
Some problem may occur...
Regards,
Pedro
0
 
No1CoderAuthor Commented:
If it is not installed, why does the nstaller tell me I can;t install it because it is already installed?
0
 
wolfman007Commented:
You could try rebuilding the registry for SQL Server 2005. This will rebuild, verify, and repair a Microsoft SQL Server instance. This procedure is most often used to rebuild the registry for a damaged installation of SQL Server.

How to: Rebuild the Registry for SQL Server 2005
http://msdn.microsoft.com/en-us/library/ms143727(SQL.90).aspx

To repair all files, rebuild the registry, and replace all SQL Server shortcuts from the command prompt
Insert the SQL Server 2005 installation media into the disk drive.

Run the following command from the command prompt:

1) Insert the SQL Server 2005 installation media into the disk drive.

2) Run the following command from the command prompt:

start /wait <CD or DVD Drive>\setup.exe /qb INSTANCENAME=MSSQLSERVER REINSTALL=ALL REBUILDDATABASE=1 REINSTALLMODE=omus SAPWD=<NewStrongPassword>

For INSTANCENAME, use MSSQLSERVER for a default instance. For a named instance, specify the instance name.

When you rebuild the resource database from distribution media, all Service Packs and QFE updates are lost, and therefore must be reapplied.

from

http://msdn.microsoft.com/en-us/library/ms144259(SQL.90).aspx
start /wait <CD or DVD Drive>\setup.exe /qb INSTANCENAME=MSSQLSERVER REINSTALL=ALL REBUILDDATABASE=1 REINSTALLMODE=omus SAPWD=<NewStrongPassword>

Open in new window

0
 
No1CoderAuthor Commented:
The suggestion did not work.  It complained about the version not matching because service packs were installed.

I uninstalled Integration servoices, and then reinstalled.  The service still does not exist, and I cannot connect.  I'm wordering if this may be a lmitation of SQL Server Workgroup.  Does anyone know?  It allows me to install it, and allows me to develop IS packages, but I can't run it.  Is this correct on Workgroup?

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.