copy database wizard in cluster sql 2005

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Max - 17 Oct 2006 16:41 GMT

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

Reply to this Message

Geoff N. Hiten - 17 Oct 2006 17:01 GMT

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.

Signature

Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP

> Hi all,
>
[quoted text clipped - 23 lines]
>
> MP

Reply to this Message