Note that this tool only is available if you have SQL Server installed. If you use MSDE there is no Enterprise Manager. In that case you have to use OSQL command line utility.

 

Step 1:        Open Enterprise Manager

Step 2: Expand the tree on the left side:

 

Console Root [ Microsoft SQL Servers [ SQL Server Group [ your Server [ Databases

 

Step 3: Right click on Databases and choose New Database

.Step 5: Double-Click on the newly created database. From menu above choose „Tools [ SQL Query Analyzer“

 

Step 6: Now create the table structure:

 

In the SQL Query Analyzer open the script create.sql in the Activation Server directory (e.g. c:\inetpub\wwwroot\lpweb\db\create.sql)

 

Step 7:        Execute it by using the menu item „Query[Execute “ (green arrow)

 

 Important: The target database has to be selected correctly (on the right side of the green arrow)

 

 

Now the database setup is complete. Continue with the customization of the config-files.

 

Note

If you do not want to use the user sa for this database then create a user who has full read and write access.

 

 

Page url: http://www.helpserver.biz/onlinehelp/lp/easygo/2.7/help2000/index.html?in_using_sql_server_enterprise_ma.htm