Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Copying a database with the "Copy Database Wizard"

4 views
Skip to first unread message

Jerry J

unread,
May 4, 2006, 9:16:02 AM5/4/06
to

I am using the Copy Database wizard to copy an SQL 2000 database to a 2005
database on another server. When I get to the "Schedule the Package" wizard
and click "Next>" I get an error that says "Proxy account has to be selected
to proceed further". However, the Integration Services Proxy Account box on
the previous screen is disabled?

What am I doing wrong?

--
Jerry J

Jerry J

unread,
May 4, 2006, 9:23:03 AM5/4/06
to

The help screen for "Schedule the package" says, "To create a proxy account
for SSIS package execution, in Object Explorer, expand SQL Server Agent,
expand Proxies, right-click SSIS Package Execution, and then click New
Proxy."

Do I do this on the destination server or the source server with SQL Server
2000? When I expand Server Agent on the source server I do not see 'Proxies' ?

I am the administrator of the destination server, however, how do I know if
I have proper permission on the source server?


--
Jerry J

0 new messages