locked
Job execution error RRS feed

  • Question

  • Hi,

       I have configured log shipping and status mail job for that. From toady morning im getting error on that job stating('Executed as user: Domain\Servername. Login failed for user 'XYZ'. [SQLSTATE 28000] (Error 18456).  The step failed.').

    But the user XYZ doesn't exist in this server. kindly help me.

    Friday, December 6, 2013 10:11 AM

Answers

  • Hi Winoa,

    As mentioned by VR Babu, please ensure that the XYZ user exists on both the server (Primary and the Secondary). First create the XYZ account on the primary server and then use sp_revlogin or Login transfer SSIS task to copy the XYZ to the secondary server with the SID.

    Also ensure that the SQL Server Agent service is running using the same domain service account on both the servers and the service account has sysadmin privileges on both the servers. 


    Thanks and Regards Alankar Chakravorty MCITP Database Administrator SQL Server 2008 MCITP Database Administrator SQL Server 2005

    • Proposed as answer by Sofiya Li Tuesday, December 10, 2013 1:58 AM
    • Marked as answer by Sofiya Li Monday, December 16, 2013 8:49 AM
    Monday, December 9, 2013 8:08 AM

All replies

  • Hi ,

    Please follow the below URL for prerequisites of sql log shipping configuration

     1) The SQL Server Agent service should be running on both primary and secondary are same account

    •  and that service accounts should have required access on shared folder.

    http://technet.microsoft.com/en-us/library/ms190640.aspx#Prerequisites

    Friday, December 6, 2013 10:20 AM
  • please make sure that user exist in xyz user exist

    Ramesh Babu Vavilla MCTS,MSBI

    Friday, December 6, 2013 11:16 AM
  • Check Errorlog http://sqlserver-help.com/2011/06/26/help-where-is-sql-server-errorlog/ and look for completemessageofLoginFailed

    Balmukund Lakhani | Please mark solved if I've answered your question, vote for it as helpful to help other users find a solution quicker
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog | Team Blog | @Twitter
    Author: SQL Server 2012 AlwaysOn - Paperback, Kindle

    Friday, December 6, 2013 11:21 AM
  • Hi Winoa,

    As mentioned by VR Babu, please ensure that the XYZ user exists on both the server (Primary and the Secondary). First create the XYZ account on the primary server and then use sp_revlogin or Login transfer SSIS task to copy the XYZ to the secondary server with the SID.

    Also ensure that the SQL Server Agent service is running using the same domain service account on both the servers and the service account has sysadmin privileges on both the servers. 


    Thanks and Regards Alankar Chakravorty MCITP Database Administrator SQL Server 2008 MCITP Database Administrator SQL Server 2005

    • Proposed as answer by Sofiya Li Tuesday, December 10, 2013 1:58 AM
    • Marked as answer by Sofiya Li Monday, December 16, 2013 8:49 AM
    Monday, December 9, 2013 8:08 AM