Creating database and user on SQL Server

After you install Microsoft SQL Server, run the create_sql_user.bat script to create database, filegroups, and a user with appropriate rights. Filegroup is a grouping of database objects and files. Filegroup is used for the administrative and data placement purposes.

The create_sql_user.bat script creates two users:

• Schema Owner: When prompted for the Database user name, the script creates the user with the provided name. This user is used to create schema while installing BMC ProactiveNet Report Engine.  
• Read-only User: The script does not prompt for user name, however, by default, creates the user with reuniv name with the password for this user is RE#Adm1n. You can change the password after the successful installation. This user is used by BusinessObjects while creating universe connections. 

To create the database, user, and filegroups, perform the following steps:

1. Navigate to the Util folder. Copy the AdminDatabaseScripts folder to the computer where you have installed BMC ProactiveNet Report Engine database. 
2. Log in to the Microsoft SQL Management Studio with the SQL admin user (default is SA).
3. In the Microsoft SQL Management Studio, navigate to Explorer.
4. Expand SQL Server > Databases. 

5. Right-click Databases > New Database.
   
   

   Note

    Ensure that you are using default collation as case insensitive collation. For example, in English, the default collation is  SQL_Latin1_General_CP1_CI_AS.

    

6. In the New Database window, enter the Database name and click OK.
7. The newly created database is added to the list of databases.
8. At the command prompt, navigate to the location where you have copied the AdminDatabaseScripts folder, as mentioned in step 1. 

1. Execute the create_sql_user.bat script only from the location where you have copied the AdminDatabaseScripts folder. 
2. Enter the required data for the script:
   
   1. 
      
      1. Enter the database server name:
         Type the BMC ProactiveNet Report Engine database host name.
      2. Enter the database server instance name:
         Type the BMC ProactiveNet Report Engine database server instance name. You can find the SQL Server instance name from services.msc.
      3. Enter the database server port:
         Type the BMC ProactiveNet Report Engine database port. By default, the port number is 1433. You can also specify the port number with which you have installed SQL Server.
      4. Enter the Authentication mode for the sysadmin user. <1 -SQL 2 -Windows>
         Select 1 for SQL sysadmin user (sa) or 2 for Windows sysadmin user (hostname\administrator). The default value is SQL sysadmin (sa). If you have selected 1, go to step v. If you have selected 2, skip to step vii.
      5. Enter the database administrator user:
         Type the sysadmin user name.
      6. Enter the database administrator password:
         Type the sysadmin password.
      7. Enter the database name:
         Type the SQL Server database name you created in step 5.
      8. Enter the type of login you want to create <1-SQL Server Authentication 2-Windows Authentication>
         Select 1 for SQL Server login or 2 for Windows login. The default value is SQL Server login. If you have selected 1, go to the next step. If you have selected 2, skip to step xi.
      9. Enter the database login name:
         Type the login name.
      10. Enter the database login password:
          Type the  database login password.
      11. Enter the domain\loginname:
          Type the domain and the login name. 
      12. Enter the database user name:
          Type the database user name.
      13. Enter the path for file groups:
          Specify the location where you want the file groups to be created.
      14. Enter the BPPMR dbsize..<Default small>:
          Select the BMC ProactiveNet Performance Management Reporting database size as small, medium, or large. The default values is small.
          
          The system executes the script, and the user and file groups are created.