BUG: Database Errors Occur While Running the PIP Administrator (302549)

SYMPTOMS

When you run the Partner Interface Process (PIP) Administrator, you may receive one of the following error messages:

PIP Administrator
Run-time error '-2147467259 (80004005)':

A connection to the PIP SDK database could not be established. Verify that the Accelerator for RosettaNet system DSN is configured correctly.
------------------------------------

Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection

-or-

PIP Administrator
Run-time error '-2147467259 (80004005)':

A connection to the PIP SDK database could not be established. Verify that the Accelerator for RosettaNet system DSN is configured correctly.
------------------------------------

cannot open database requested in login 'databasename'. Login fails.

CAUSE

These errors usually occur as a result of a failed BTSKInstances database setup during the installation of the BizTalk Server Accelerator for RosettaNet. These errors may also occur if the BTSKInstances database becomes corrupted or is deleted.

RESOLUTION

After you set up the BizTalk Server Accelerator for RosettaNet, you must set up the database through the use of a script. The script Create_rn_db.vbs is located on the BizTalk Server Accelerator for RosettaNet CD-ROM.

Steps to Resolve This Problem

Open a command prompt.
Run the following command:
cscript create_rn_db.vbs /server localhost /dbname BTSKInstances

NOTE: Microsoft BizTalk Server Accelerator for RosettaNet must be installed in order for the script to run successfully.

MORE INFORMATION

The Create_rn_db.vbs script utility for Microsoft BizTalk Server Accelerator for RosettaNet has the following syntax:

cscript create_rn_db.vbs /server <sql-server> /dbname <database-name> /sqlscript <sql-file>

where:

<sql-server> is the name of the Microsoft SQL Server computer on which to create the database (defaults to the local computer if not specified).

<database-name> is the name of the database (defaults to BTSKInstances if not specified).

<sql-file> is the SQL script file to run (defaults to <install-dir>\PIP SDK\Database\BTSKInstances.sql if not specified).