sql server clustering: copy database wizard in cluster sql 2005 -- sql server clustering

copy database wizard in cluster sql 2005

Max
10/17/2006 8:41:01 AM

sql server clustering:

Hi all,

I have a issue when i tried to copy database from a machine with MSDE
database to a new sql 2005 cluster server. I could not copy it with copy
database wizard. Here is the message i got.

TITLE: Copy Database Wizard
------------------------------

The action you attempted to perform on a remote instance of SQL Server has
failed because the action requires a SQL Server component that is not
installed on the remote computer. To proceed, install SQL Server 2005
Management Tools on the remote computer, and then try again. For more
information, see "How to: Install SQL Server 2005 (Setup)" in SQL Server 2005
Books Online, or find the article on MSDN at
http://go.microsoft.com/fwlink/?LinkID=57083 .

For help, click: http://go.microsoft.com/fwlink/?LinkID=57083

--------

Help.

Thanks,

MP

Re: copy database wizard in cluster sql 2005

Geoff N. Hiten
10/17/2006 12:01:54 PM

You probably ran into one of the more significant changes on clustering in
SQL 20005, the tools install. SQL 2005 tools are not installed to all
cluster nodes. You have to install to each node individually. Go to each
node and install the SQL 2005 client tools and you should be good to go.

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP

[quoted text, click to view]