Node missing component

for some reason the SQL Reporting service didnt get installed on one of my
nodes... so i was simply just going to install it... apparently it isnt so
simple.
how do i go about adding the reporting services to a node?
Thanks
Justin
SQL Reporting Service is not cluster aware. You can install it by running
SQL setup CD and select the Reporting Service option.
Ayad Shammout
"Justin Rich" <jrich523@.yahoo.spam.com> wrote in message
news:Ofq4xo60HHA.4184@.TK2MSFTNGP06.phx.gbl...
> for some reason the SQL Reporting service didnt get installed on one of my
> nodes... so i was simply just going to install it... apparently it isnt so
> simple.
> how do i go about adding the reporting services to a node?
> Thanks
> Justin
>
|||For SQL 2000, it is a separate CD and install. For SQL 2005, go to
add/remove programs and change SQL 2005. Add the Reporting SErvices
component when you get the features list.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Ayad Shammout" <ashammout1@.hotmail.com> wrote in message
news:u2UZcS70HHA.5772@.TK2MSFTNGP02.phx.gbl...
> SQL Reporting Service is not cluster aware. You can install it by running
> SQL setup CD and select the Reporting Service option.
> Ayad Shammout
>
> "Justin Rich" <jrich523@.yahoo.spam.com> wrote in message
> news:Ofq4xo60HHA.4184@.TK2MSFTNGP06.phx.gbl...
>

No tool to upgrade Access databases

sql server 2k has a tool to upgrade Access databases. I can't find any similar tool in sql server 2005. Am I missing something?

dennist

Do you mean the Import/Export Wizard? This will copy some of the schema and the data from an Access Database. Right click on a Database in SSMS and select import.

If you mean the Access Upsizing wizard this is part of Access and we are still closing those plans.

-Euan

Please reply only to the newsgroup/forum so that others can benefit. When posting,please state the version of SQL Server being used and the error number/exact error message text received, if any.

Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

This posting is provided "AS IS" with no warranties, and confers no rights.