Post reply

Chaning orphan SQL user password

  • December 14, 2005 at 9:40 am

    #111029

    hi team,

    I was looking at the article : http://msdn2.microsoft.com/en-us/library/ms174428.aspx to change the password of users without knowing the old pwd.

     

    As per the info, it asks to use the below command :

    ALTER LOGIN Victoria WITH PASSWORD = 'B3r1000d#2-36';

    Go

     

    However, I get the error message

    Server: Msg 170, Level 15, State 1, Line 1

    Line 1: Incorrect syntax near 'LOGIN'.

    Any clue ? Thanks !

    Rgds, A

    Get busy living ....or get busy dying....

  • December 14, 2005 at 10:17 pm

    #609641

    Looks like you are attempting to use SQL 2005 syntax (ALTER LOGIN) on SQL 2000, use sp_password, from BOL:

    Examples
    A. Change the password of a login without a former password

    This example changes the password for the login Victoria from a NULL password to "B3r12-36".

    EXEC sp_password NULL, 'B3r12-36', 'Victoria'
    Andy

  • December 15, 2005 at 12:33 am

    #609645

    Thanks. That was the catch. I have SQL'2000 only.

    Get busy living ....or get busy dying....

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

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