Connecting to a Registered Database in ArcGIS Pro as a Different User and Publishing Data

[JEMOO-01]

I am using ArcGIS Pro and ArcGIS Enterprise Portal.
In our organization, User1 has already registered a database with the portal. Now, I am signing in as User2 and need to connect to the same registered database to publish data. Here’s what I’ve done and the issue I’m facing:
Database Registration:

• The database was registered by User1 and is visible in the Data Store of the portal under Registered Databases under share section in ArcGIS Pro. I can see the registered database in the portal, but I’m unsure how to connect to it in ArcGIS Pro as User2 [ Only Appear and try to select it to be the registered database I want but nothing happens].

Publishing Data:

• My goal is to publish data (e.g., feature layers or web maps) to the portal using the registered database. I want to ensure that I don’t need to re-register the database and can directly use the existing registration.

Questions:

• Do I need to re-register the database as User2, or can I directly connect to the database that User1 already registered?
• What steps should I follow to connect to the registered database in ArcGIS Pro as User2 and publish data?
• Are there any specific permissions or settings I need to configure to access the registered database and publish data?

Additional Details: 

• Portal Version: [ ArcGIS Enterprise Portal version11.3]

• ArcGIS Pro Version: [ArcGIS Pro 3.3]

• Database Type: [The Database is Enterprise SQL Server]

• Permissions: I have confirmed that User2 has the necessary permissions to access the portal and publish data [ Publisher Role able to publish & register data, I thought that there are some privileges / permissions should give to user so I try with the portal Administrator and the same issue database appear in portal datastore but can select it to be my register data] 

[dgiersz_cuyahoga · Accepted solution]

To use an existing registered data store, you need to connect to it the same way the data store was connected to when registering.  For example, if an .sde connection file was used, you will need an .sde connection file with the same parameters (database, username, password, etc). 

If it is a folder, the same path needs used. For example, if a UNC path was registered (\\servername\registeredfolder), you have to use UNC when publishing. You can not use a mapped drive to the same folder ( Q:\registeredfolder).