Copy DB Wizard

[jjandswifty]

Hi,

I'm trying to use the copy DB wizard in SQL manager (SQL 2008 ). When the package tries to execute I get an error in the job history with a login failure for anonymous login - but I'm not asking it to use that lgin anywhere... Also, it seems to have trouble saving the package ready for execution and I'm wondering if this might in fact be the issue. Error for this below:


While trying to find a folder on SQL an OLE DB error was encountered with error code 0x80004005 (Login timeout expired).

Thanks

 

[MartinCroft]

I had the same issue on SQL2005 it required Integration services being installed on the local machine your running the database copy wizard. When installing ensure all the options you currently have are selected, as first attempt at fixing this I inadvertently un-installed some elements as they were not ticked.