Post-Installation Configuration

After you have determined your installation to be a success, you need to take care of a few post-install tasks.

Changing the sa Password

If you initially configured the sa account with a blank password or if you used a generic password that was shared with non-administrators assisting in the install, now is the time to change it. The sa password, like any other, can be changed from the Properties sheet for the account under the Enterprise Manager Security folder or with the sp_password stored procedure. For more information on changing passwords, see Chapter 15, “Security and User Administration.”

Setting Up System Administrator Accounts

The sa account is not the only one with full access to your SQL Server installation. ...

Get Microsoft® SQL Server™ 2000 Unleashed, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.