Hi All

I'm attempting to copy a DB from SQL 2k to SQL 2k on a new server.

When i run the Copy Database Wizard i recieve the 'Failed to create the share OMWWIZD' error message. Which according to Microsoft Knowledge Base article 274463 occurs if:

'If the destination SQL Server is started under a domain account that does not have local administrator privileges on the source computer then the following error message may be generated by the wizard'

http://support.microsoft.com/default.aspx?scid=kb;en-us

I went to SQL Server Properties-> Security -> Startup Service Account. Made a note of the login and gave the Account Admin Privlages on the Win2k Server.

However i still get the same Error message when i run the wizard.

All i can think of is that i have missunderstood the article.

Any ideas where i am going wrong?

Cheers