Re: Integration Services won't install / not working
- From: Nick Gilbert <nickg@xxxxxxxxxxxxxxxx>
- Date: Fri, 15 Dec 2006 15:18:04 +0000
I think this was the problem. I must have installed it from the wrong CD at some stage as our license is actually for Enterprise Edition. At some stage I will have to reinstall it from the correct CD so it is running Enterprise Edition.
It is EXTREMELY bad that the setup wizard does not tell you that you can't install the Integration Services component. It is on the list - and lets you select it even when running Workgroup edition, but it doesn't install it properly despite the message after installation which tells you it was installed successfully! This is absolutely awful behaviour and has wasted DAYS of my time.
Poor, or non-existent error messages seem to be SQL Server's most dominant feature and have collectively wasted days of my time. Nearly every time consuming single problem I've had with SQL Server 2005 has either been caused by a poor or incorrect error message or has been greatly exacerbated by it (usually lack of information with error messages such as "the package failed").
Nick...
Wei Lu [MSFT] wrote:
Hello Nick,.
Based on this article, SQL Server 2005 Workgroup Edition only support some feature of the SSIS. http://msdn2.microsoft.com/en-us/library/ms143761.aspx#
It does not support the SSIS services which means you could not find the SSIS services in your server. That is the root cause of this issue.
To use the SSIS services, please install the standard or Enterprise edition. Thank you!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues where an initial response from the community or a Microsoft Support Engineer within 1 business day is acceptable. Please note that each follow up response may take approximately 2 business days as the support professional working with you may need further investigation to reach the most efficient resolution. The offering is not appropriate for situations that require urgent, real-time or phone-based interactions or complex project analysis and dump analysis issues. Issues of this nature are best handled working with a dedicated Microsoft Support Engineer by contacting Microsoft Customer Support Services (CSS) at http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================
(This posting is provided "AS IS", with no warranties, and confers no rights.)
- References:
- Re: Integration Services won't install / not working
- From: Nick Gilbert
- Re: Integration Services won't install / not working
- From: Wei Lu [MSFT]
- Re: Integration Services won't install / not working
- From: Wei Lu [MSFT]
- Re: Integration Services won't install / not working
- From: Nick Gilbert
- Re: Integration Services won't install / not working
- From: Wei Lu [MSFT]
- Re: Integration Services won't install / not working
- Prev by Date: Re: Move SQL 2005 .LDF from one disk to another
- Next by Date: Setting up custom listeners on multiple sockets
- Previous by thread: Re: Integration Services won't install / not working
- Next by thread: Need to buy SQL Server 2000
- Index(es):
Relevant Pages
|
