« Back

SA Password during ADOxx Installation

Combination View Flat View Tree View
Threads [ Previous | Next ]
toggle
SA Password during ADOxx Installation
community webinar installation documentation getting started development environment
Answer
11/07/17 13:25
I don't remember the password for the "sa" user for the SQL Server instance I have installed on my computer. How can I change it?

RE: SA Password during ADOxx Installation
Answer
10/06/13 07:35 as a reply to Anonymous.
"sa" is the default user that has administrator rights on the instance of SQL Server that you are using. The password for "sa" has been defined when SQL Server was installed on your computer. Please ask your system administrator for that password if the installation has been done by your IT department.

In case you have administration rights on your database engine, you can
a) Reset the sa password manually using SQL procedures. Steps to be performed are detailed below.
b) Install a new instance in the SQL server using the SQLExpress installation file in the ADOxx download package and define the password by yourself. This is done in the definition of the Authentication mode, that should be set to "Mixed mode" and the password for the "sa" user has to be entered. After that, please re-install ADOxx and make sure to use this password.

RESET "sa" PASSWORD on ADOxx

1) Check your instance name
As a first step you need to check name of the database instance you wish to connect to. It is shown during installation when question about SA password. Alternative way to check it:
Control panel>Services (on XP available under Administrative Settings) and search for the entry beginning with SQL Server. Most probably it will be SQL Server (SQLEXPRESS) --> in this case instance name is SQLEXPRESS.

2) Start the command line
Go to Start menu and use "Run" (for XP) or "Search programs and files" (Vista and Win 7), type:
CMD
and hit ENTER

3) Connect to the database
Assuming your instance name is SQLEXPRESS type:
osql -E -S .\SQLEXPRESS
and hit ENTER

4) Reset the password and exit
Assuming your new password is "newpassword" (your policy settings may force you to have something more complex) type the following after the prompt ("1>" for the first line etc.) appears. Hit enter after typing each line.
EXEC sp_password @new='newpassword', @loginame = 'sa'
go
EXIT

Please note: this is "loginame", NOT "loginname".