Copying SQL Server Object Tasks

Hi,

I am having trouble copying one database from a one SQL Server to and MSDE
instance.

My environment is set up as follows:

Machine 1: Windows XP Pro with SQL Server 2000 client components
Machine 2: Windows 2003 Server with MSDE 2000.
The two machines are networked but are not part of a Domain.

I am trying to copy the database from the XP Pro Machine to the Windows 2003
Server using the 'Copying SQL Server Object Task'. I am having issues with
what appears to be permissions:

Question 1: I am told that SQL Server is running under the loacl system
account and that I should set up an account with network copying
privelidges. How do I do this? Do I set up an accountunder windows? How
do I give to permissions to copy accross the network?

Question 2: It seems to me from the error messages that are being generated
that one must be part of a domain for it to be possible to use the DTS
functionality. Is this true?

Question 3: Is there an easier way to copy the database from the one server
to another?

Any help or advice as to how best to do this will be appreciated.

Regards

Vaughn


.

Relevant Pages

  • Re: Slow booting xp home.
    ... Changing the boot order to boot first from your hard disk might save you a half second, but you won't be able to boot from a CD until you change it back - and the time spent to do that will erase any previous time saved. ... 2- Consider what software you really want to start with Windows and also how you've configured your applications at startup ... Installing and Registering Visual Studio Express Editions Smart Device ...
    (microsoft.public.windowsxp.perform_maintain)
  • Re: Saving WSS site prior to upgrading SQL Server 2005 Express to Standard/Enterprise
    ... Your backup is from a different version of Windows SharePoint Services and ... SQL Server 2005 is available. ... The advantages of the embedded version ("Windows Internal Database") over ...
    (microsoft.public.sharepoint.windowsservices)
  • IIS / SQL Server impersonation
    ... I am attempting to implement impersonation from a windows application ... I have configured the host virtual directory in IIS to require windows ... the database permits Windows Authentication. ... When I try and open a connection to SQL Server: ...
    (microsoft.public.dotnet.security)
  • Re: User setup problem.
    ... login permissions for SQL Server. ... have access to SQL Server and the database through their ... windows group role membership which has the permissions.. ...
    (microsoft.public.sqlserver.security)
  • RE: Executing a DTS package from a Web application.
    ... >> I’ve been only able to find examples of Windows and VB applications. ... >> to a SQL Server database table. ... The SQL Server database is not local. ... the DTS package specifies the full UNC file name. ...
    (microsoft.public.sqlserver.dts)