Log Shipping - Error: Logon failure: unknown user name or bad password

  • Good Day,

    I am trying to set up a log shipping in my primary db server, then I encounter this error messages,"Error: Logon failure: unknown user name or bad password".. I already check the permission of both servers and it has all admin privileges. I tried to run it manually, In Primary db, the backup was successfully executed and then when I go to secondary db to executed the job for copying log file the error occurs... I dont know what to do..

    To know more about the version of my SQL server, below are the details:

    Primary --> SQL Server 2008 (SP2) ENT ED, running on Win. Server 2008 R2 ENT ED.

    Secondary-->SQL Server 2008 ENT ED, running on Win. Server 2008 Standard ED

    Anyone, I need your advice and expertise.

    Thanks.

  • miaka102 (6/30/2014)


    I am trying to set up a log shipping in my primary db server, then I encounter this error messages,"Error: Logon failure: unknown user name or bad password".

    At exactly what point do you get the error?

    Can you post a screenshot?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply