We just set up a new server box and installed SQL Server 2005 on it. I have a number of databases on our old server that I would like to transfer to the new box. When I try to use the Copy Database Wizard, it fails on the last step with an error (from the log): "Login failed for user 'dhausner'. The user is not associated with a trusted SQL Server connection. [CLIENT: <local machine>]".
Both boxes are set up to use Windows Authentication only and I am a member of the sysadmin group on both.
Am I missing sometthing? Is there a better way to put these databases on the new server?
As always, any help is greatly appreciated!