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
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
"Max" <Max@.discussions.microsoft.com> wrote in message
news:4B0044FE-CBD5-4426-9CBF-5FB13CD27A48@.microsoft.com...
> 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
>
sqlsql
No comments:
Post a Comment