Create the SQL Server 7.0 Databases

You should use the following procedure if you are using Microsoft SQL Server 7.0 in your BizTalk Server installation. If you are using Microsoft SQL Server 2000, use the instructions in the preceding topic titled "Attach the SQL Server 2000 Databases" instead of this one.

On the Start menu, point to Programs, point to Microsoft SQL Server 7.0, and then click Enterprise Manager.
The SQL Server Enterprise Manager appears.
Expand Microsoft SQL Servers, expand SQL Server Group, and then expand the server on which you want to attach the database.
Click Databases.
On the Action menu, click New Database.
The Database Properties menu appears.
In the Name field, type CustomCorrelation as the name of the database.
Click OK.
On the Action menu, click New Database.
The Database Properties menu appears.
In the Name field, type SupplierCustomCorrelation as the name of the database.
Click OK.
Close the SQL Server Enterprise Manager.
On the Start menu, point to Programs, point to Microsoft SQL Server 7.0, and then click Query Analyzer.
The Connect to SQL Server menu appears.
Ensure that the correct information to connect to SQL Server is entered. Click OK.
On the menu bar, make sure that the value in the DB field is CustomCorrelation. If it is not, click the DB drop-down list box and select CustomCorrelation.
On the File menu, click Open.
Browse to the folder \Microsoft .NET Server Solutions for the Enterprise\E-Procurement\Application\eprocurement\hub_database.
Click the CustomCorrelationTable.sql file.
On the Query menu, click Execute.
This will process the CustomCorrelationTable.sql file. If the SQL file has been run, you will see a message stating: The command(s) completed successfully.
Repeat the steps in this procedure for the SupplierCustomCorrelationTable.sql file located in the folder \Microsoft .NET Server Solutions for the Enterprise\E-Procurement\Application\eprocurement\supplier_database.
Close Query Manager.

Previous Next