SQL 2000 copy database error OMWWIZC
Posted on 2006-06-30
Hello, I have a win2000 domain controller with sql2000 on it, and an XP pro machine with sql 7.0 desktop edition on it with a database I want to copy. Now I'm trying to use copy database wizard to do this, but everytime I try I get an error: "Windows cannot create the share OMWWIZC". PLEASE do not post the same link to Microsoft's support site, I've read it an innumerable amount of times, and it gives me no clues. I have logged on to both sql servers using local accounts that mirrored the sql account "sa", I have tried using the local system account, to which it tells me I have to add permission to send files over the network to my account to go any further. I am lost, utterly confused as I know nothing about SQL and ODBC. any help?