Alter Hashed login failure

• MarvinTheAndriod

  SSCarpal Tunnel

  Points: 4972

  More actions

  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 ?

• Lowell

  SSC Guru

  Points: 323521

  More actions

  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!

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  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

• Adiga

  One Orange Chip

  Points: 27284

  More actions

  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