Changing the MSDE SQL Server Sys Admin account password is not supported by the I/NET Seven DbCreate Utility

[Product_Support]

Issue

Changing the MSDE SQL Server Sys Admin account password is not supported by the I/NET Seven DbCreate Utility. Users have been advised to uninstall and then reinstall MSDE to change the password.

Product Line

TAC INET

Environment

• I/NET Seven
• MS SQL Server (MSDE)

Cause

Need to change password

Resolution

Use the Microsoft OSQL Utility to change the Sys Admin account (user name, SA). Developed for Course 2002 I/NET Seven Installation and Startup - MSDE SQL Server OSQL Utility; Rev. 1/4/2007, by: M. Myers, TAC-KSG

How to change your INetDb SQL Server SA account password using the OSQL Utility:

1. On the I/NET Seven host workstation computer, shut down I/NET Seven completely, including the I/NET Seven I/O Server.
2. Open the command prompt window. Select Windows Start > Run. Type the command, cmd, in the Run window, Open the dialog entry space, and click on OK. Enter the text exactly as is between the quotations.
3. Connect to the I/NET Seven MSDE instance using the sa account. At the operating system drive, command prompt (i.e. C:\>), type the following OSQL command and press ENTER:
   osql -U sa
   Enter the command text exactly as it appears, including a dash before the capital U, and the spaces after the l and the U.
   OSQL will reply with the following prompt:
   Password:
4. At the Password: prompt, type in the current SQL Server sa account password, and press ENTER. If the log-on command is correct, OSQL will return a line prompt:1>.
5. Type the following string command at the 1> line prompt and press ENTER:
   sp_password @old = ‘old password‘, @new = 'new password', @loginame = 'sa'
   Enter the old and new passwords and the SQL System Administrator account name, sa, in apostrophes. Be sure to type each space and comma in the command.
   OSQL will return a second line prompt: 2>
6. Type the go command at the 2> line prompt and press ENTER: go
   OSQL will return the password changed message and the 1> line prompt:
   Password changed.1>
7. To close OSQL, type Exit at the 1> prompt and press ENTER. The Command Prompt will appear:
   C:\>_
   To close the Command Prompt window, type Exit at the command prompt and press ENTER.