Can you please tell me which version of SQL developer are you using?
You should use SQL developer versions 3.2.10 and up.
The port should be 22 not 2222
You have to create a user in the Identity console with database developer rights.
Please see the steps in the tutorial :
Let me know if you still have issues with it.
I'm having exactly the same error - I have followed all the guidelines and exhausted the efforts of CHAT support - they have verified I'm using the correct details - so why do I get this unable to connect to sftp server with provided details?
Can anyone help
can you please provide me the additional details:
1. Can you please attach also a print screen of the setting you have on the advance section? ( under the URL, there is an Advanced button)
2. Can you please tell us which version of Windows do you have on your PC? It should be Windows on 32bit , or 64.
3. Do you have a trial database account? What is your identity domain?
4. Did you reset the sft account password via identity manager console?
5. Did you create a new user , with developer rights?
thanks for your response, I'm running Windows 7 64Bit on a Macbook Pro in Bootcamp, however I'm using the Mac OS X to run SQL Developer.
I tried using WinSCP and Putty from windows as suggested in this discussion but also got Access Denied although the server did respond.
Sorry don't know how to do a screen dump from SQL Developer using a Mac but the Advanced settings are as follows:
Server Path: /apex/
Service Name: _sqldev/
I have a trial account with identity domain: trialaqjh.
I reset the sftp user password 3 times at different attempts - (the one listed as the service sftp user in the service details).
I created a new APEX user but developer rights were greyed out. I was able to assign the 3 privileges at the bottom of Create User.
I tried using my new user and also using the Admin account created by default for the trial database account.
Hope this helps
In the edit connection settings ( main screen before pressin advance) you should have
1. port 2222
2.username: the user with the developer rights
3. for the url something like : https://database-trialabze.db.us1.oraclecloudapps.com/apex/
4.Please try adding the developer rights using Identity Manager console, and check if you have dev rights on both parts( identity console and in apex)
5. Please reset also the password for the dev user, before trying to connect to the cloud.
let me know of the results.
Is it Port 22 or 2222 - the advice I get keeps changing, but I have tried both many times and neither work. I beleive it should be 22 because I can connect to the server on this port - it's just that authentication fails after prompting me for the password - so let's forget about the port for now!
The connection from SQL Developer complicates the issue, so lets just consider why I can't make a simple sftp connection from Filezilla (or other clients) as if I'm going to retreive and export of data - this doesn't work either and has no relationship to the APEX account does it ? - i.e. it just requires a Host (sftp host). sftp username and password - which I have reset several times.
FYI, the APEX administrator account created for the trial does not allow me to assign Developer rights when I create a new Apex user - the option is greyed out.
Please help - I've been trying to get this resolved for 10 days now
Please create the developer user through the Identity Console, and add there the developer rights,
After that, log in to the db instance using the new created developer account , so that you can reset the pwd, and set the securrity questions.
then log out the db instance
log in with the admin account to the db instance
and add all 3 groups the the new developer created.:D
let me know if now it works.
I added developer privilleges through identity console and was able to connect - then I revoked them and am still able to connect with both Filezilla and SQL Develper - I can now deploy a Cart OK. So I'm wondering what has changed since last week? Why is the above assignment of Developer privilleges using Identity Console not mentioned in any of the documentation - and why does it not seem to make any difference?
Yes revoked the rights from Identity Console, and in APEX the user I created only has the SQL Developer User Group, not the other 2.
however, the APEX administrator account has all 3 User Groups. This is the one I'm using for the SQL Developer cloud connection - as I discovered in the forums somewhere there it was no longer required to create a new APEX user - any user with APEX Administrator rights will do. I noted earlier today that in Identity Console, this Admin user which is created by default when the trial is started does have Developer privileges.
However, I still think the problem was sftp authentication - does this actually require any APEX user?
As far as i know ussually it takes a few minutes( maximum 15 minutes) to the role assignation to take into account..Maybe that is why you managed to log -in .
We usually recommend to create a new user, for the cloud connection.( for security reasons ...the admin account should be used mainly to manage the other accounts...unlock users, reset passwords etc) I 've read also somewhere that now you can log in with the apex initial admin account, but to be honest i didn't get a chance to test it yet .
Please let us know if you need any other info from our side regarding this topic, otherwise please close this thread.