There is no selection of SSIS SSAS when I am running the change just now... where are they?

Can I just install SSAS SSIS engines??

I have built a report and I just want to see how it may look like on

http://localhost/reportserver

Also, do you know why SSIS, SSAS are showing on the avaiable server...

Installing SQL 2005 again?

Do I need to remove it 1st? then install again??

I m using Vista Home Prem, understood SSRS wont work on my PC. But at least SSAS ans SSIS should work!!

BUT I can not even find the engines from drop...

I didn't install anything else than the original SQL 2005 Standard CD.

When it asked me which component I wished to install, I selected RS AS IS and all sample databases...

No, I am using Standard Ed SQL 2005. All BI components are fully selected while installing.

I know it sounds really odd... any idea??

No.. Vista Home Prem doesn't support SSAS nor SSIS.

Both service instances are missing.

When I open Mgmt Studio, Connect -> SSAS -> there is nothing to be connected to ...

"Server Type" drop down list shows all the services names.

But "Server Name" drop down list only shows "Database Engine" is available.

I have been playing around with SQL 2005 for a while, but not so its SSAS IS RS components.

thanks for ur advice, I have got SQL 2008 Standard Ed disc...

thanks Gift, understand now..

With no intention to change my OS by now, I'd better install SQL 2008 instead.

Isn't it silly that Microsoft's infamous vista doesn't support SQL 2005 BI components!!

thanks Gift,

do you think it is a good idea to totall un-install SQL 2005 and intall SQL 2008 instead??

I am happy to do that if it can solve the IIS7...

thanks Dan,

I am not 100% sure I have install SQL 2005 - BI component properly.

Let us assume it's not.

Can you please list things I need to re-install? only IIS-7 needed...

thanks for reply.

I m using Vista Home Prem, but I have got IIS-7 installed already.

when you said IIS-7 configured, do u have any instruction / website I can refer...