Creating a user and database for BMC BladeLogic Network Automation installation (Windows)

Before installing BMC BladeLogic Network Automation, you must execute the following steps on the host machine where you want to install the BMC BladeLogic Network Automation product:

• Create a BCAN_USER user account for the operating system
• Create a database (for example, bcan) and database owner (for example, BCAN_USER)

To create an operating system user for the BMC BladeLogic Network Automation installation (Windows)

You must create a user account (for example, bcan) when installing the BMC BladeLogic Network Automation product. This account is referred to as the BCAN_USER account.

The user account cannot be an administrator account and must have privileges to log in locally.

This account will own all the installed files in BCAN_HOME and BCAN_DATA. It will also be used to initialize and run the embedded postgres service, if you use that option.
 The BCAN_USER account must be a local and limited account. Assign a password to the account.

1. Log in to your computer as an Administrator.
2. Go to Start -> All Programs -> Administrative Tools -> Computer Management to open the Computer Management window.
3. Under System Tools, go to Local Users and Groups -> Users.
4. Right-click the Users folder and then select New User.
5. In the New User dialog box, create the BCAN_USER user:
   • User Name: BCAN_USER
   • Password: password
6. Click Create.
7. Right-click the new BCAN_USER and then select Properties.
8. Click the Member of tab.
9. Click Add.
10. In the Enter the object names to select field, enter Remote Desktop Users and then click OK.

11. Click OK to close the Properties dialog box. 

    Warning

    Note

    You might need to add the BCAN_USER to the Remote Desktop Group if the installation and upgrades will be done using a Remote Desktop Connection.

    The BCAN_USER account must have access to the TFTP, FTP and SCP directories. This access is the default for a newly created account in Windows.

12. Log off as Administrator.
13. Log in using the BCAN_USER account to ensure the home directory (that is, *C:\User\BCAN_USER) and profile are created.
     If the home directory is not created, the installation will fail. This step will also confirm the
    BCAN_USER account has the required user policy rights.
14. While logged as BCAN_USER, open a command prompt and type echo %USERDOMAIN%.
     During the installation you will be asked to provide this value.
15. Log off as BCAN_USER and log back in as Administrator.
16. To make sure that the Windows service called Secondary Logon is started and the Startup Type is set to Automatic, go to Control Panel -> Administration Tools -> Services.
     Verify the Secondary Logon service is started and has the Startup Type set to Automatic.

To create a database and database user for MS SQL Server

1. Log in to Microsoft SQL Server Management Studio.
2. Create a new database (for example, bcan).
    You can temporarily assign sa as the database owner.
3. Go to Security -> Logins.
4. Right-click the Logins folder and then select New Login.
5. Select SQL Server authentication.
6. Enter a login name and password.
7. Click OK.
8. Right-click the bcan database you created and then select Properties.
9. In the Database Properties dialog box, click Files.
10. Click Owner.
11. Enter the bcan login user you just created and then click Browse.
12. Select the bcan user from the list and then click OK.
13. In the Select Database Owner dialog box, click OK.

14. Click OK to close the Database Properties dialog box. 

    Warning

    Note

    Log in to SQL Server Management Studio as the database user and verify that your password is not expired. Depending on the password policy you used when creating the database user, you sometimes see login problems.