Post reply

Alter Hashed login failure

  • October 25, 2010 at 4:36 am

    #149158

    When I run the following procedure in SQL 2005

    USE MASTER

    ALTER LOGIN [Sa] WITH

    PASSWORD = 0x01004086CEB66433E82F3F8946C27E33641A8179E4AD419C5811

    HASHED, CHECK_POLICY = OFF, CHECK_EXPIRATION = OFF

    I get the following error:

    Msg 102, Level 15, State 1, Line 3

    Incorrect syntax near '0x01004086ceb66433e82f3f8946c27e33641a8179e4ad419c5811'.

    However this works perfectly in SQL Server 2008. It also matches SQL server syntax on BOL. What Am I doing wrong, is there an alternative way to do this ?

  • October 25, 2010 at 5:49 am

    #1241511

    Marvin that is so weird; i pasted your command to my SQL2005 instance, and it ran without an error;

    maybe it's due to a patch level?

    here's my @@version:

    Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86)

    Feb 9 2007 22:47:07

    Copyright (c) 1988-2005 Microsoft Corporation Express Edition

    with Advanced Services on Windows NT 5.1 (Build 2600: Service Pack 2)

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • October 25, 2010 at 5:50 am

    #1241514

    Semi-duplicate thread.

    No more replies to this thread please, direct replies to http://www.sqlservercentral.com/Forums/Topic1002245-146-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • October 25, 2010 at 6:35 am

    #1241534

    This query worked fine for me. Please confirm if you are connected to a SQL Server 2008 instance.

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

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

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