I am using oracle sql developer to manage my oracle database. I recently added third party database jdbc drivers to be able to connect to my new MySQL and SQL Server installations. I need help with the right settings for the SQL Server connection i.e UserName, Host Name, Port including formats
Sql-server – Connecting to SQL Server using Oracle SQL Developer
oracleoracle-11g-r2oracle-sql-developersql server
Related Solutions
First of all check whether your pluggable database is opened or not.
SQL> select name, open_mode from v$pdbs where name='PDBORCL';
If it is in mounted mode then,
SQL> alter pluggable database pdborcl open;
Now on SQL Developer Create new connection as,
Connection Name: demo-pdborcl
Username: demo
Password: *****
Connection Type: Basic(If you wish to use TNS connection type you have to create TNS Network Alias in client side.)
Hostname: ip/dns
Port: 1521
SID: (If you use SID like 'ORCL' you will be connected to root container, therefore use Service name instead of SID)
Service name: (You can get your pdb's service name by firing $ lsnrctl serivce, also you can use USE_SID_AS_SERVICE_listener parameter on $ORACLE_HOME/network/admin/listner.ora file as USE_SID_AS_SERVICE_listener=on and any given SID will be treated as service name.
Some useful links-
When you connect from the connection properties dialog, two things will happen in the UI:
- the connection icon gets a 'connected' overlay
- you get a SQL Worksheet***
If your connection is not successful, you'll get an error message, with the text shown at the bottom of the connection properties window.
***For #2 above, this is conditional on the following preference being enabled, which the default is TRUE.
'Open a Worksheet on connect'
Best Answer
I followed these instructions to add the jTDS Java library to Oracle SQL Developer. Basically it's about downloading the jTDS zip, unzipping it in some place you can reach later and then add the jTDS.jar as a JDBC third party driver in SQL Developer ((In the main menu) Tools > Preferences > (On the tree menu in the new window) Database > Third party JDBC drivers > Click on 'Add entry')
I was then able to use my credentials to connect to a SQL Server instance/database using the following connection details. I'm currently using Oracle Developer 4.0.1.14.
The default port for SQL Server instance is 1433, however your SQL Server instance may be running on a non default port. The following site has different methods to determine the port.
http://www.mssqltips.com/sqlservertip/2495/identify-sql-server-tcp-ip-port-being-used/