We have a new install of SQL 2000 and I am trying to transfer a DB to the new server (DTS transfer DTS task).
Everything points to where it should and I have all the required SQL and NTFS permissions but when I try to execute the task I get "failed - unspecified error"
When I check the event viewer on the (new) destination server I see these entries (below). I have no idea what they mean, how to fix, what to fix? The event icon is information as opposed to warning/error.
I really want to get this understood and fixed before transferring the DB across - as a bonus I'd also like to get the transfer DB task working too!
Error: 15457, Severity: 0, State: 1
Configuration option 'allow updates' changed from 1 to 0. Run the RECONFIGURE statement to install.