Re: Copying SQL Server Object Tasks

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

The way I approach copying a DB from one place to another specially if it is the whole DB is by using Backup and Restore. Simple, it works.

--


Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com




"Vaughn Haybittle" <vhaybittle@xxxxxxxxxx> wrote in message news:uwd4yYBOHHA.4604@xxxxxxxxxxxxxxxxxxxx:

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: VS2005: SQL Debugging "T-SQL execution ended without debugging. You may not have sufficient
    ... > account also must be a member of the sysadmin role in the target SQL ... and the Windows firewall is disabled on both client & server. ... to the remote SQL Server 2005. ... But I'm still getting the "T-SQL execution ended without debugging. ...
    (microsoft.public.vsnet.debugging)
  • Re: Utter madness!
    ... It is just Windows security stuff. ... You can get a trusted connection back to SQL server. ... ASP.NET account (either processModel or app pool identity depending on ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Passthrough authenication w/ SQL trusted connection
    ... separate connection will be used for each security context (each user ... account will have it's own pool). ... if you are using a Windows 2000 Domain, ... backend SQL Server. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Search services not available
    ... Let me clarify that our SQL server uses Windows Authentication, ... account, even if it was just for now to get it working, that would be easier ... I have configured the Search service to use this ...
    (microsoft.public.sharepoint.windowsservices)
  • connecting to sql server with windows authentication
    ... using windows authentication. ... Use delegation to leverage the current user's account. ... development machine, a live machine, and local installs of IIS for all your ... our DBA wants to keep SQL Server authentication ...
    (microsoft.public.dotnet.framework.aspnet.security)