Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 tranfer logins DTS task

Author  Topic 

swoodring
Starting Member

5 Posts

Posted - 2002-07-03 : 15:13:05
I am trying to use the DTS transfer login task to transfer my logins from my SQL 7.0 server to my sql 2000 server. These are on different machines. I've created a new package on my new server - SQL 2000. I've selected the transfer log-in task, under properties/source I have PRFDSS which is my sql 7.0 server/under destination I have PRF_SQL which is my SQL 2000 server. Under Log-ins I selected all server logins detected at run time.

When I run the task I get an error stating unspecified error. I'm running this task from the new server. SQL 2000 server. Any ideas whats wrong?

Stacy

Kevin Snow
Posting Yak Master

149 Posts

Posted - 2002-07-05 : 10:18:29
You may consider an alternative to DTS.

http://www.sql-server-performance.com/dd_creating_logins.asp

This site has some suggestions on how to move logins without using DTS.
Go to Top of Page
   

- Advertisement -