Knowledge Base Article
Article Type: How To
Product: Symphony
Product Version:
Component: Symphony Server
Device Brands:
Created: 31-Jul-2012 3:49:46 PM
Last Updated:

How to reset the sa password for SQL 2005 Express


  1. Log on to the Symphony server where SQL Express 2005 is installed.
  2. Log into OSQL with Windows authentication:
  3. osql -S localhost\Aimetis -E
  4. Enter the following commands on a seperate line:
  5. sp_password @old = null, @new = 'complexpwd',  @loginame ='sa'
  6. Replace "complexpwd" with the new strong password. A strong password includes alpha-numeric and special characters, and a combination of upper and lower case characters.
  7. Re-run the Setup Wizard and enter the new SA password and re-apply changes.

Average rating:
Please log in to rate.
Rated by 0, Viewed by 4165