Post reply

Login failed for SQL Agent account

  • May 14, 2012 at 1:57 am

    #392253

    Hi there - why would an account with SA rights fail to login to SQL. This is a scheduled backup job that re-ran successfully, but something at that particular time stopped it from logging in.

    The only error I can see is a Failed to login to SQL Server, anyone any ideas on how I can troubleshoot this?

    Thanks

  • May 14, 2012 at 2:02 am

    #1486976

    what error, severity, state numbers do you have for this?

    something like error 18456, severity 14, state 11?

  • May 14, 2012 at 2:12 am

    #1486978

    I am using Ola Hallengren's scripts http://ola.hallengren.com/ and the error was pulled from the log files it creates, of which it looks to be a custom one of Msg 50000, Level 16, State 1.

    There is nothing in the event viewer other than something to say there was a job failure, and there is nothing in the SQL log.

  • May 14, 2012 at 4:31 am

    #1487011

    Error 50000 is a user-defined error.

    Look for the "RAISERROR()" and check what the code is around that and the conditions that will cause the error to fire.

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

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

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