Solved

Change SA account password

Posted on 2008-10-22
5
471 Views
Last Modified: 2012-05-05
The SQL Administrator just left our organization, and I would like to reset the "sa" account password within SQL.  It's SQL 2000 Enterprise, and is installed on a 2-node Microsoft cluster (MSCS).

Can I simply go into Enterprise Manager, right-click, and reset the password...simple as that?  Or is there more to it?  Do I need to stop/restart services, etc.  I'm not that familiar with SQL, and don't want to do anything detrimental to our SQL environment as many critical apps are running on it.

Thanks.
0
Comment
Question by:lakeviewmedical
  • 3
5 Comments
 
LVL 17

Expert Comment

by:aflockhart
Comment Utility
Hopefully your apps should not be logging in using the "sa" account, but you may want to double check this before changing the password.
0
 

Author Comment

by:lakeviewmedical
Comment Utility
could you please clarify what you mean by that?  where would users be logging into apps with this account...it was setup during the SQL install and was never given to anyone outside of IT.  Thanks.
0
 
LVL 17

Expert Comment

by:aflockhart
Comment Utility
When your apps retrieve data, they need to supply credentials to the server. This could be done either by sending the user's Active Directory authentication info, or by using "SQL Server" security, where they send a programmed username and password. The server may be set up to accept one or both types.   If you are using the latter type, there may be userids and passwords stored in connection strings, ODBC definitions, etc.

The users would probably never see the password but it could still be programmed in to their app.

0
 
LVL 17

Expert Comment

by:aflockhart
Comment Utility
0
 
LVL 7

Accepted Solution

by:
Hemantgiri S. Goswami earned 250 total points
Comment Utility
IMO, it would take 3~4 mins and you should restart services after you change SA password, and as suggested you should double check if your application running under SA account.
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Join & Write a Comment

Suggested Solutions

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now