Trail Blazer Knowledge Base:


Home : MS SQL Server : SQL Server change the password

Knowledge Base







User:

Password:



Article ID: KB9
Keyword Name:
Created: June 04, 2007
Viewed: 5018

SQL Server change the password

Change the Password

Customers should change the sa password to a non-blank one with this procedure:

  1. Change the password of the sa account used by the Microsoft Desktop Engine (MSDE):
    1. Go to Start > Search > For Files or Folders to locate the osql.exe file on the Trail Blazer Server. (This assumes that MSDE is installed, because the osql.exe file comes from MSDE.)
    2. Open a DOS window and navigate to the location of osql.exe.
    3. 1. Issue the osql –E command and press Enter. The prompt changes to >.
      or try,
      2. Issue the osql –U sa –P command and press Enter. The prompt changes to >.
    4. Issue the sp_password NULL, ‘newpassword’, ‘sa’ command. Replace the variable newpassword with your desired value. Press Enter.

      Note: You must have the single quotes around newpassword and sa.

    5. Issue the go command and press Enter. The system returns the message, “Password changed.”
    6. Issue the exit command and press Enter.

      In the DOS window, the complete sequence resembles this example, in which the password is changed from blank to "abc123":

      C:\Program Files\Microsoft SQL Server\80\Tools\Binn>osql -U sa -P
      or 
      C:\Program Files\Microsoft SQL Server\80\Tools\Binn>osql -E
      1> sp_password NULL, 'abc123', 'sa'
      2> go
      Password changed.
      > exit
      C:\Program Files\Microsoft SQL Server\80\Tools\Binn
      

Change MSDE Mixed mode Authentication

Alternatively, you may be able to change the authentication mode in the registry. Example below is for a full SQL Server 2000 installation.

Notes: http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q325022

HKLM\Software\Microsoft\MSSQLServer\MSSQLServer\LoginMode
Mode
value: 0 = SQL Authentication 1 = NT Authentication 2 = Both SQL and NT Authentication allowed


Find our more information about Trail Blazer Campaign Services Inc. [click here]


Powered by: ClickCarts KnowledgeBase