SQL Server Performance Forum – Threads Archive
Errors in transfering logins
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 />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
(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
]]>