Post reply

sql trigger error with number 17892

  • July 26, 2012 at 8:43 am

    #278498

    Hi,

    I have a big issue and still can not resolve this.

    I am getting the error concerning a trigger by

    Logon failed for login ‘Sa’ due to trigger execution.

    Changed database context to ‘master’.

    Changed language setting to us_english. (Microsoft SQL Server, Error: 17892)

    And I can not use " sqlcmd -S LocalHost -d master -A " for this

    Could you please help me

  • July 26, 2012 at 8:50 am

    #1517992

    Log in as someone who is not SA and fix your trigger.

    Jared
    CE - Microsoft

  • July 26, 2012 at 8:56 am

    #1517999

    SQLKnowItAll (7/26/2012)

    Log in as someone who is not SA and fix your trigger.

    Do you have anyway to resolve this?

    I have use SQL Server 2008 express and also can not logon by use DAC

  • July 26, 2012 at 8:59 am

    #1518003

    Is SA your only login? There must be others that work?

    Jared
    CE - Microsoft

  • July 26, 2012 at 9:10 am

    #1518011

    Right now, I can used DAC and try to use command sqlcmd -S LocalHost -d master -A

    But I getting the error again

    message is Msg 102, Level 15, State 1 , Server xxxxx(is a name of server), Line 1 Incorrect syntax near 'S'

    Help me please?

  • July 26, 2012 at 9:18 am

    #1518016

    Surprise!!!!

    I already resolve and can access to server

    Thank you so much

  • July 26, 2012 at 9:38 am

    #1518029

    Please tell us what you did so that others can resolve the problem it it happens to them.

    Jared
    CE - Microsoft

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

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