1 Reply Latest reply: Feb 7, 2012 2:18 AM by Detlev RSS

    Error: provider: Named Pipes Provider, error: 40 while updating DRM

    Detlev
      Recently we ran into this error while applying a patch on DRM 11.1.2.1 (SQl2008, Win2008).

      Oracle Hyperion Data Relationship Management
      Database Update Manager
      Version 11.1.2.1.103
      Copyright (c) 2011 Oracle Corporation

      Application 'APP-NAME':

      Exception: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible.
      Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

      Process completed with errors.

      Press any key to continue...

      namedpipes was indeed disabled on the remote SQL server but tcp/ip was enabled off course.
        • 1. Re: Error: provider: Named Pipes Provider, error: 40 while updating DRM
          Detlev
          It took me some time but finally I came to the conclusion that an "@" in the password caused this failure.
          Perhaps the way jdbc and DRM construct rthe db string makes the db thinks its username is posted twice.

          Removing the "@" from the password in SQL accounts, and changing the password accordingly in the DRM console settings made it all work again. I posted in on support.oracle.com. Let see if they patch this too.


          Detlev