SQL Server Performance

Errors in transfering logins

Discussion in 'SQL Server DTS-Related Questions' started by siva_pothireddy, Sep 12, 2003.

  1. siva_pothireddy New Member

    I'm getting the following error when transferring the logins, the command used is as below<br /><br />dts /S DB1 /N xxx_LOGINS /L dts.log<br /><br />Thanks.<br /><br />Siva<br /><br />The execution of the following DTS Package succeeded: <br /><br />Package Name: xxxx<br />Package Description: (null)<br />Package ID: {8CE2C4F9-2F7F-460B-9C90-1BE3564C741E}<br />Package Version: {D72A6FF0-6B13-4835-8091-685337542239}<br />Package Execution Lineage: {BB61E83C-2BE9-4104-90F4-7F8973E03003}<br />Executed On: DB1<br />Executed By: xxxxx<br />Execution Started: 9/11/2003 6:14:58 PM<br />Execution Completed: 9/11/2003 6:15:12 PM<br />Total Execution Time: 14.64 seconds<br /><br />Package Steps execution information:<br /><br /><br />Step 'DTSStep_OMWCustomTasks.OMWTransferLogins_1' failed<br /><br />Step Error Source: Microsoft Data Transformation Services (DTS) Package<br />Step Error Description:Unspecified error<br /><br />Step Error code: 80004005<br />Step Error Help File<img src='/community/emoticons/emotion-7.gif' alt=':s' />qldts80.hlp<br />Step Error Help Context ID:700<br /><br />Step Execution Started: 9/11/2003 6:14:58 PM<br />Step Execution Completed: 9/11/2003 6:15:12 PM<br />Total Step Execution Time: 14.64 seconds<br />Progress count in Step: 0<br />Task Log for this step:<br />-----Start Task Log-----<br /><br />Error = 1 (00000001), Description = Script Login xxx/xxxx<br />...<br />...<br />...<br />-----End Task Log-----<br />
  2. gaurav_bindlish New Member

    siva, don't place the login names on the public forum. This may be a potential security threat.

    I would recommend that you edit the message and put some dummy logins

    Gaurav
    Moderator
    Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard
  3. satya Moderator

    (First of all this is not appropriate forum, topic moved to DTS)

    Error 80004005 represents connection problems between client and server.
    - As many connection's bugs were fixed in SQL Server service packs, you should use the latest service pack.
    - Check that the client and the server run the same network protocol.
    - Check that the client and the server use the same Net-Library.
    - If you get the error message indicates that login failed for user 'username', you should check spelling of the login name and password.

    Also I'm quite sure this KBA http://support.microsoft.com/defaul...ort/kb/articles/q305/3/65.ASP&NoWebContent=1] is applicable, refer thru it.

    HTH

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com

Share This Page