Sign In
www.adoxx.org
Welcome
Download
Tutorial
Olive Webinar
Introduction Webinar
Interaction with external API webinar
ADOxx Training Registration
ADOxx Training Overview
Frequently Asked Questions
Developer Community
Realization Cases
Falcon
Building Blocks_
Documentation
Introduction to ADOxx
Modelling Language Implementation
Mechanisms and Algorithms Implementation on ADOxx
ADOxx Development Tools And Services
ADOxx Development Languages
ADOxx Development Languages: Syntax Support in Notepad++
ADOxx Development Languages: Syntax Support in Microsoft Visual Studio Code
AdoScript Documentation
CoChaCo4ADOxx
Contact
ADOxx.org
Frequently Asked Questions
Technical Questions and Installation
SA Password during ADOxx Installation
Message Boards Home
Recent Posts
Statistics
Answer
(
Unmark
)
Mark as an Answer
« Back
SA Password during ADOxx Installation
Threads [
Previous
| Next ]
Anonymous
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?
Sign in to vote.
Top
Wilfrid Utz
Moderator
Rank:
Senior Member
Posts:
178
Join Date:
30/01/13
Recent Posts
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".
Sign in to vote.
Top