Solved

SQL 2000 copy database error OMWWIZC

Posted on 2006-06-30
8
341 Views
Last Modified: 2017-02-28
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?

0
Comment
Question by:coilbraze
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
  • 2
8 Comments
 
LVL 10

Expert Comment

by:fm250
ID: 17021140
Do you have ownership on that database? try to take onwership if not and see what happens.
0
 
LVL 4

Accepted Solution

by:
johanvz1 earned 500 total points
ID: 17024310
Hi,

From where to where do you want to copy the database?. if you want to remove it from your pc. just dismount the database and manaully copy the mdf file over the network.

Kind Regards,

Johan
0
 

Author Comment

by:coilbraze
ID: 17042856
if I could just move the database without import/export and just mount it, I would, but as far as I know, you cant just detach and attach a database from sql 7.0 to sql 2000. If I'm wrong, please let me know, but that's what I was told.
0
Connect further...control easier

With the ATEN CE624, you can now enjoy a high-quality visual experience powered by HDBaseT technology and the convenience of a single Cat6 cable to transmit uncompressed video with zero latency and multi-streaming for dual-view applications where remote access is required.

 

Author Comment

by:coilbraze
ID: 17042903
Also, fm250, I have noticed under sql 7.0 that the defined owner of the database is computername/Administrator. All the other databases are under sa. How do I change the owner of a database? thanks for the help so far.
0
 

Author Comment

by:coilbraze
ID: 17081649
tried mounting the database, and only the tables copied. None of the other information. I going to try backing up and restoring, but I can't seem to figure out a way to let it back up to disk. It wants to device it's writing to to be on a raid which is not an option for us.
0
 
LVL 10

Expert Comment

by:fm250
ID: 17083328
I am not if you have the tools or just the sql server, (the free sql or you bought it). if it is the free one and you don't have the tools you can use the command line, look here
http://www.thescripts.com/forum/thread79663.html

or you can download the free dbmgr tools and use the properties of the db to change ownership, you can also backup dbs easily with it though gui interface. here is the link: http://www.asql.biz/en/DbaMgr.aspx 

hope this helps!
0
 

Author Comment

by:coilbraze
ID: 17084025
When I tried to move the DB from the SQL 7.0 to SQL 2000, i got that error msg, but that was using CDW. Instead I tried to move the DB using import/export from the SQL 7.0 side. It SAID it was moving the info, but really it only moved the tables and nothing else. As an alternative I was going to try to make a backup of the SQL 7.0 DB and use SQL 2000 to restore it. that failed before I could make the backup because on SQL 7.0 every time I try to it tells me the device/file path I have listed is not a raid device and I need to choose WITH FORMAT or something like that. Not only have I never seen this format option they speak of, but I can't find anywhere where you can designate a device thats not on a RAID. I have made new backup devices in SQL Enterprise Manager, but I get the same msg. Also, when I designate a file path to backup, I have to list a FILE NAME not a DIRECTORY NAME, which is weird because you can only rewrite backups or append to them? I have just about had it with Microsoft and their plethora of "less-than-effective" software and OS's. Any help would be appreciated.
0
 
LVL 4

Expert Comment

by:johanvz1
ID: 17404160
Hi,

Details steps worked for me. Sorry I have not logged in a lot recently.

http://www.15seconds.com/issue/050127.htm
0

Featured Post

Building an interactive eFuture classroom

Watch and learn how ATEN provided a total control system solution including seamless switching matrix switch, HDBaseT extenders, PDU, lighting control to build an interactive eFuture classroom.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you're not part of the solution, you're part of the problem.   Tips on how to secure IoT devices, even the dumbest ones, so they can't be used as part of a DDoS botnet.  Use PRTG Network Monitor as one of the building blocks, to detect unusual…
When it comes to security, there are always trade-offs between security and convenience/ease of administration. This article examines some of the main pros and cons of using key authentication vs password authentication for hosting an SFTP server.
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
Suggested Courses
Course of the Month10 days, 17 hours left to enroll

628 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question