Decide the OS user account that will become the instance administrator. Use either a new user, or a user that already exists.
To create a user in Windows, select [Administrative Tools], [Computer Management], and then create the user in [Local Users and Groups]. Refer to "Help and Support" for details.
The following characters can be used for user names:
- (hyphen)
_ (underscore)
Space
A-Z, a-z, 0-9 (alphanumeric)
Note
The following notes apply if using WebAdmin for operations:
After creating the user account of the instance administrator, log in to the operating system. A profile directory is created for the user when logging in to the operating system for the first time. This directory will be used by WebAdmin.
If changing the password for the user account of the instance administrator, always ensure to stop the instance and log out of WebAdmin before making the change. If you mistakenly change the password while logged in to WebAdmin or while the instance is running, log out from WebAdmin, and then log in again, and stop and start the instance.
If using commands for operation, security settings that allow logon as a service are required for the operating system user account of the instance administrator in order to start and stop an instance using a Windows service.
Information
If using WebAdmin for operation, these settings are not required as WebAdmin performs the settings automatically for the user ID (operating system user account) that logged in to the database server.
The following explains how to perform the security settings to allow logon as a service:
In Windows, select [Administrative Tools], and then click [Local Security Policy].
In the [Local Security Policy] window, select [Security Settings], select [Local Policies], and then click [User Rights Assignment].
Under [Policy] in the [User Rights Assignment] window, double-click [Log on as a service].
In the [Log on as a service Properties] window, set the following:
Select the [Local Security Setting] tab.
On the [Local Security Setting] tab, click [Add User or Group].
In the [Select Users or Groups] window, enter the operating system user account of the instance administrator in [Enter the object names to select].
Click [OK].
In the [Log on as a service Properties] window, click [OK].