Change SA account password
Posted on 2008-10-22
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.