Senstar
Safeguarding people, places and property
Contact       Xnet Login       English
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

Solution

  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'
    
    go
    
  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 3407