Microsoft Support

Article ID: 305365 - Last Review: October 16, 2003 - Revision: 3.2

PRB: DTS Package Fails with "Unspecified Error" Error Message When You Use Transfer Logins Task to Move a SQL Server Login

View products that this article applies to.

System TipThis article applies to a different operating system than the one you are using. Article content that may not be relevant to you is disabled.

This article was previously published under Q305365

Expand all | Collapse all

SYMPTOMS

When you use a Data Transformation Services (DTS) Transfer Logins Task to move a SQL Server login that is based on a local Microsoft Windows NT account, the DTS package fails with this error message:

"Unspecified Error".

Here is an example of the DTS package output log:

Package Name: (null)
Package Description: (null)
Package ID: {6014C46B-F76E-4072-8266-466A2B8CA45D}
Package Version: {6014C46B-F76E-4072-8266-466A2B8CA45D}
Package Execution Lineage: {8333062F-A287-48B0-8E8C-3A4EF9A18CB8}
Executed On: SERVER2
Executed By: administrator
Execution Started: 8/7/2001 5:11:03 PM
Execution Completed: 8/7/2001 5:11:05 PM
Total Execution Time: 1.131 seconds

Package Steps execution information:

Step 'DTSStep_OMWCustomTasks.OMWTransferLogins_1' failed

Step Error Source: Microsoft Data Transformation Services (DTS) Package
Step Error Description:Unspecified error
Step Error code: 80004005
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:700

Step Execution Started: 8/7/2001 5:11:03 PM
Step Execution Completed: 8/7/2001 5:11:05 PM
Total Step Execution Time: 1.131 seconds
Progress count in Step: 0
Task Log for this step:
-----Start Task Log-----

Error = 1 (00000001), Description = Script    Login    BUILTIN\Administrators    
Error = 1 (00000001), Description = Script    Login    test    
Error = 1 (00000001), Description = Script    Login    sa    
Error = 1 (00000001), Description = Script    Login    server1\test    
Error = 1 (00000001), Description = Transfer    Login    BUILTIN\Administrators    
Error = 1 (00000001), Description = Transfer    Login    test    
Error = 1 (00000001), Description = Transfer    Login    sa    
Error = 0 (00000000), Description = Transfer    Login    server1\test    

-----End Task Log-----

Back to the top

CAUSE

Local Windows NT accounts are comprised of MachineName\UserName. Because the destination computer name is different, the transfer fails. Even if the machine names are the same, the security identifier (SID) of the local Windows NT account cannot be specified and are not likely to be the same.

Back to the top

RESOLUTION

If you plan to use the DTS Transfer Logins Task to move logins between servers, keep the following points in mind:

Logins to transfer cannot be based on a local Windows NT account.
Logins can either be Windows NT domain accounts or standard SQL Server logins.
Windows NT Domain accounts must be valid on both the destination and the computer that is running SQL Server. If the servers are in different domains, you can accomplish this through a trust relationship.

Back to the top

STATUS

This behavior is by design.

Back to the top

APPLIES TO

Microsoft SQL Server 2000 Standard Edition

Back to the top

kbprb KB305365

Back to the top