DavidWGoodall


I am a bit out of my league here so any help would be greatly appreciated.

On a Windows SBS 2003 R2 server. I am trying to add Integration Services at the request or an external Consultant group. I ran the install & followed the bouncing ball from this article

http://msdn2.microsoft.com/en-us/library/bb326043.aspx

The only odd thing is that it didn't give the option to pick an instance (only Microsoft SQL Server 2005).

It seems to install fine, no pop up error or anything but the SSIS service isn't installed. If I try & connect to it via the SQL Server Management studio - Selecting Integration Service in Server Type I can browse for the server name but on connecting it says " Connect to SSIS service on machine "Riley" failed

The specified service does not exist as an installed service.

& looking through the list of Services I can't find it.

I have uninstalled Integration services & reinstalled twice now but the same result (no service) ... what am I doing wrong, it seemed so simple from the instructions.




Re: Sql 2005 Intergration Services Installed But Service isn't there

Jamie Thomson


Can you see the SSIS service in the Services panel The service is called "SQL Server Integration Services"

-Jamie







Re: Sql 2005 Intergration Services Installed But Service isn't there

DavidWGoodall

No it's not there, but everything tells me it should be.






Re: Sql 2005 Intergration Services Installed But Service isn't there

DavidWGoodall

Could it be an SBS thing Like you don't get the service in the SQL that comes with SBS 2003 R2



Re: Sql 2005 Intergration Services Installed But Service isn't there

Nantallen

I have the same issue, but on Windows Server 2003 Standard Edition x64 SP2. We are using SQL Server Workgroup Edition SP2.

I have tried removing, and reinstalling Integration Services. But the Intergration Service is still not listed in the SQL Server Configuration Manager or in Service.msc. When I open the Business Intelligence Studio, I can design and debug packages directly in there. I can even build them, and deploy to the server. But I have no access to SSIS through the SQL Server Management Studio.

Any other suggestions besides a full reinstall would be greatly appreciated. A full reinstall is not available, due to this being an in-use production server.

Thanks.





Re: Sql 2005 Intergration Services Installed But Service isn't there

jwelch

Integration Services isn't included with Workgroup edition.

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx






Re: Sql 2005 Intergration Services Installed But Service isn't there

iistudio

so apart from buying a standard or enterprise edition of SQL Server 2005, is there anything we can do to include SSIS service on workgroup like purchase SSIS as seperate feature pack or pay cost to upgrade workgroup to standard

thanks





Re: Sql 2005 Intergration Services Installed But Service isn't there

jwelch

You have to have Standard, Enterprise, or Developer - and Developer can't be used in production.






Re: Sql 2005 Intergration Services Installed But Service isn't there

iistudio

well yeah, but not able to get SSIS seperately or upgrade workgroup to standard or enterprise are just painful, we bought a Windows 2003 small business server package comes with workgroup version of SQL Server, but now we want some SSIS transformation done; so I guess what microsoft says is if you ever gonna upgrade, you have to pay the full price for standard or enterprise edition, your workgroup or developer edition should be thrown out of window, thats just lame imho.




Re: Sql 2005 Intergration Services Installed But Service isn't there

Jamie Thomson

iistudio wrote:

so I guess what microsoft says is if you ever gonna upgrade, you have to pay the full price for standard or enterprise edition, your workgroup or developer edition should be thrown out of window, thats just lame imho.

Why It says on the box that workgroup is a lesser version of the product. If you want full functionality then you have to pony up the money - SSIS isn't free.

Don't get me wrong, Microsoft aren't exactly in my good books today but I don't think you can blame them for saying you have to pay if you want everything within SQL Server.

By the way, SSIS is in Developer Edition. Developer edition is just Enterprise without the production license.

-Jamie






Re: Sql 2005 Intergration Services Installed But Service isn't there

iistudio

yeah without production license means its good for your development scenario but not others.

The workgroup edition is a lesser version of the product doesnt change the fact if your business needs more feature now you will have to toss the workgroup edition you purchased 1 year ago andpay the full price of standard or enterpise edition for ONLY just SSIS service rather than upgrade.

anyway, if there is no other options I guess I have to buy it. end of story then.

cheers

Steven