My Oracle Support Banner

Error "Unable to create connection from connect string. Cannot open database requested by the login." When Attempting to Connect to a Database via Databaselogins.bat/sh (Doc ID 2929837.1)

Last updated on FEBRUARY 26, 2023

Applies to:

Primavera P6 Professional Project Management - Version 21.12 and later
Information in this document applies to any platform.

Symptoms

When attempting to establish a connection to a newly restored SQL Server database in the databaselogins.bat /.sh utility (as instructed in How to Administer the Private Database Login Username and Password for P6 EPPM or P6 Professional R8.x and Later Releases(Doc ID 1348248.1)), the following error occurs:

Unable to create connection from connect string <PrivateUser>/<Password>@<SQLServer>:<Port>:<DatabaseName>: SQLServerException (Cannot open database "<DatabaseName>" requested by the login.

The issue can be reproduced at will with the following steps:

  1. Launch <P6 EPPM or P6 Professional installation media>\database\databaselogins.bat.
  2. Enter the database connection information then click Next.
  3. The reported error occurs.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.