Microsoft KB Archive/302549

= BUG: Database Errors Occur While Running the PIP Administrator =

Article ID: 302549

Article Last Modified on 9/12/2001

-

APPLIES TO


 * Microsoft BizTalk Accelerator for RosettaNet 1.0 Enterprise Edition

-



This article was previously published under Q302549



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.



STATUS
Microsoft has confirmed that this is a bug in Microsoft BizTalk Server Accelerator for RosettaNet.



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  /dbname  /sqlscript 

where:

 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).

Keywords: kbbug KB302549

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.