BaseNow - Database Front-End Software
Home Buy Download Details Support
BaseNow Forums 
Login Register Member List
  » BaseNow Forums   » Questions   » DTS PACKAGE ERROR  

Welcome Guest ( Login or Register )

Posted 11/10/2004 1:55 AM
Forum Member
Forum Newbie

Group: Forum Members
Active: 11/10/2004
Posts: 2
      I intend to export an entire SQL Server DB from one Server to another. I am not sure abt the best way to do the same, but I tried diong it using a DTS package. However the package failed to complete with the following error msg
"The login 'anderson' does not exist"
Can anyone help me out in identifying the prob & also ways to have it solved.
Thanx in anticipation,
IP Logged
This member is offline.
Posted 11/10/2004 2:03 PM
Forum Administrator
Forum Administrator

Group: Advanced Members
Active: 3/7/2010
Posts: 64
I think you should be able to transfer data and objects between the servers if you use the "Copy SQL Server Objects" Task in DTS.

Follow these steps:

Create a new package in DTS.

Right-click the background and select 'Add Task/Copy SQL Server Objects Task' from the menu.

A window will pop-up where you will be able to specify the correct Username and Password for both SQL Servers. If a server is running on LAN, you can select the "Use Windows Authentication" option.
IP Logged
This member is offline.
Showing page 1 of 1 - 2 messages found
« Next Oldest :: Next Newest »

Powered by InstantForum.NET v3.4
Copyright © 2002, 2004, InstantASP Ltd. All rights reserved.