Attach the SQL Server 2000 Databases

In this procedure you set up the correlation databases that are used with the e-procurement sample. You should use these instructions if you are using Microsoft SQL Server 2000 in your BizTalk Server installation. If you are using Microsoft SQL Server 7.0, use the instructions in the following topic titled "Create the SQL Server 7.0 Databases" instead of this one.

The following instructions assume that SQL Server 2000 is installed on the same computer as BizTalk Server. If SQL Server is installed on a different computer, you will need to modify these instructions so that they will work in your environment. The hub database files (CustomCorrelation_Data.*) are located in the \Microsoft .NET Server Solutions for the Enterprise\E-Procurement\Application\eprocurement\hub_database folder, and the supplier database files (SupplierCustomCorrelation_Data.*) are located in the \Microsoft .NET Server Solutions for the Enterprise\E-Procurement\Application\eprocurement\supplier_database folder.

On the Start menu, point to Programs, point to Microsoft SQL Server, 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, point to All Tasks and click Attach Database.
The Attach Database dialog box appears.
Click the browse button ( ).
The Browse For Existing File dialog box appears.
Browse to the folder \Microsoft .NET Server Solutions for the Enterprise\E-Procurement\Application\eprocurement\hub_database.
Click CustomCorrelation_Data.MDF, and then click OK.
A message box appears indicating that the process was successful.
Repeat the steps in this procedure to attach the file SupplierCustomCorrelation_Data.MDF located in the folder \Microsoft .NET Server Solutions for the Enterprise\E-Procurement\Application\eprocurement\supplier_database.

Previous Next