Macromedia live cycle 7.2 매뉴얼

Installing and Configuring LiveCycle for JBoss

 Creating a SQL Server database     46

You can create a SQL Server database that LiveCycle products will use to store run-time and configuration 
data. For information on creating a SQL Server database, refer to the SQL Server documentation. LiveCycle 
products support SQL Server 2000 SP3a. 

Create a SQL Server database and create a user with DB_OWNER privileges that can be used when 
configuring the data source on the application server. For information about creating the database and 
user, see the SQL Server documentation.

The SQL Server database can be configured with the Windows or SQL Server authentication types. To run 
the database with JBoss, the authentication type should be set to SQL Server. 

LiveCycle PDF Generator also requires a JMS database on SQL Server. (See 

.)

For LiveCycle PDF Generator deployed on JBoss, in addition to the LiveCycle database, you also need to 
create a Java Message Service (JMS) database on the SQL Server.

➤

1. Select Start > Programs > Microsoft SQL Server > Enterprise Manager. 

2. In the navigation tree, select Console Root > Microsoft SQL Servers > SQL Server Group > 

[servername] > Databases.

3. Right-click Databases and click New Database.

4. In the Name box, type a name for the database and click OK.

5. In the navigation tree, select Console Root > Microsoft SQL Servers > SQL Server Group > 

[servername] > Security > Logins. 

6. Right-click Logins and select New Login. 

7. On the SQL Server Properties screen, type a name for this login in the Name box, select SQL Server 

Authentication, and type a password in the Password box.

8. Click the Database Access tab, select the database that you created in step 

 and, in the Permit in 

Database Role list, select public and db_owner. 

9. Click the Server Roles tab, select Database Creators, and then click OK.

10. On the Confirm Password screen, type the password you created in step 

 and click OK.

11. In the navigation tree, select and right-click Logins, select New Login, type 

guest

 in the Name box, 

and select SQL Server Authentication.