SQLServer Enterprise Beans Configuration

Step 1 Step 2 Step 3 Step 4



Since many of the Enterprise Bean Samples require database access, it is required that you follow the instructions for Database Configuration before configuring and running Enterprise Beans.


Step 1: Create a Database User.

  • Create a SQLServer user named EJB for the SAMPLE database.

  • Using SQLServer's Query Analyzer, separately execute each of these commands:

    1. sp_addlogin EJB, ejbuser, SAMPLE
    2. use SAMPLE
    3. sp_adduser EJB
    4. grant all to EJB


Take Note!
  • The password for EJB(all upper case) is ejbuser, all lower case.
  • The EJB user may have already been created as a part of the installation process. In that case, you may use this existing EJB user provided the EJB user has access to the SAMPLE database.