Google Groepen ondersteunt geen nieuwe Usenet-berichten of -abonnementen meer. Historische content blijft zichtbaar.

Copying a database with the "Copy Database Wizard"

4 weergaven
Naar het eerste ongelezen bericht

Jerry J

ongelezen,
4 mei 2006, 09:16:0204-05-2006
aan

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

ongelezen,
4 mei 2006, 09:23:0304-05-2006
aan

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 nieuwe berichten