When connecting to an Oracle database the following error is generated:
Connection failed because of the following error: NET: Invalid SID
Incorrect data provider used.
On the Connections window, be sure to select a correct provider (e.g. if using an Oracle client then use Native Client Connection).
Also, be sure that the database being connected to is reachable via the following: