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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
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.
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.
---------.


10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

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
PedroCGDCommented:
If you dont have the service you dont have SSIS installed...:-(
Some problem may occur...
Regards,
Pedro
No1CoderAuthor Commented:
If it is not installed, why does the nstaller tell me I can;t install it because it is already installed?
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

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?

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.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.