Logon Account

In SQL Executive, you can log on under "system account" or "other account."

It is generally recommended that you create a user account in the Domain\Administrators group.

On the Start menu in Windows NT 4.0, point to Programs and then Administrative Tools. Click User Manager for Domains.

On the User menu, click Select Domain.

Type the SQL Server name in the Domain box and click OK.

On the User menu, click New User.

Type the following information:

Username: SQLServer

Full Name: SQL Server admin account

Description: SQL Server administration account

Password : (enter password for account)

Confirm Password: (enter password again)

Make sure only the following check boxes are selected:

User Cannot Change Password

Password Never Expires

A frequent cause of failure in this situation is that the account SQL Executive is using has a password that has expired or changed. If this is the case, perform the following:

On the Start menu in Windows NT 4.0, point to Settings and then click Control Panel.

Double-click Services.

Click SQL Executive and then click Startup.

Enter the correct account and password information for SQL Executive and click OK.

Click Start to restart the SQL Executive service.