Can't connect to Integration Services while on Server

[JwithaL]

I am very new to Integration Services and have done a full install twice now for SQL Server 2005.

I am launching Microsoft SQL Server Management Studio and connecting to the Server type: Integration Services

Then I get an error:

TITLE: Connect to Server
------------------------------
Cannot connect to SBS1-LAMB.
------------------------------
ADDITIONAL INFORMATION:

Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)

For help, click:

http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

------------------------------
Connect to SSIS Service on machine "SBS1-LAMB" failed:
The specified service does not exist as an installed service.
.
------------------------------
Connect to SSIS Service on machine "SBS1-LAMB" failed:
The specified service does not exist as an installed service.
.

Please help and thanks in advance,
Justin

 

[mrdenny]

When you installed the SQL Server services what options did you select on the page with all the services listed?

Have you started the SSIS service?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[JwithaL]

We installed everything that was available from the SQL CDs that came with windows SBS 2003. Unfortunately, we found out that it comes with the workgroup version and not the enterprise version which I guess gives you the tools, but not access to actual service. So thanks for answering, but I guess there is nothing I can do anymore.

 

[mrdenny]

Standard edition will actually give you SSIS as well.

I'm not sure what's included with SBS.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog