Issues Connecting to SQLExpress using Oracle SQL Developer
- by ArtDeveloper
Hey Guys,
I'm trying to create a connection inside Oracle SQL Developer to a SQLExpress database I have
Everything I have resides on the same machine so there isn't any network issues I should have to deal with
but everytime I follow the instructions and I try to connect I get the following message
"Failure - Unable to get information from SQL Server: localhost."
I can connect to the SQLExpress DB using the SQL Management Studio and through an ODBC connection.
I've installed the third party extensions and I've enabled the TCP protocol on the SQL Server Configuration manager as well as enabled the IP Addresses
I'm assuming that the SQLExpress Database is on port 1433 because I didn't change this when I installed but if someone can tell me how to double check that I would appreciate that info as well.
I setup the new connection with the following information
name: databasename
I'm using windows authentication so the username and password aren't filled in
host:localhost
port:1433/databasename;instance=SQLEXPRESS
*databasename - this is replaced with the actual DB name I've just changed the name here to protect the innocent
I've spent about a full day on this trying to get it connected and many google attempts where other ppl have had this issue but have gotten it solved through various methods that I've tried and it hasn't resolved my issue.
Any information would be much appreciated
Thank you in Advance,
AD