Hi,
I download the JDBC, I read this tread SQL Server 2014 connexion
but I'm not able to connect to my DB SS.
I also configured TCP/IP port
Where is my error?
Thanks for the help
Put 1433 ONLY in the "Port" box and press the button below it to populate databases. Choose one from the drop down list and... viola!
Cheers,
Gaz.
Nothing!
I think "localhost" is not sufficient. I use Express version and I need to use instance name. In effect with SS Management Studio I use localhost/SQL2014 to connect the database.
I already tried localhost\SQL2014
Is "localhost" uncommented in your C:\Windows\System32\drivers\etc\hosts file?
Does you machine have a hostname? Have you tried that instead of "localhost"?
Have you asked this question on a sQlSeRvEr community help forum?
Cheers,
Gaz.
Sorry Gaz,
but if I use localhosts with SQL Server Management Studio, I think all is correct. I don't understand why ask in a SS community, the problem is with an Oracle product, not with an SS product.
PS: Localhost alrady run with APEX...
I suggested to check sQlSeRvEr forums as other people may have experienced the issue you are facing, and in some cases it turns out to be a sQlSeRvEr ExPrReSs problem not SQL Developer problem.
Check the SQL Server Browser service is running.
...and try again. If it still fails, please show your setup.
Cheers,
Gaz.
Hi Gaz,
you're right...
I tested one more time, I have not changed anything, I I'm not be able to connect with Windows Authentication, but with "sa" user is good.
It works and it's good for me.
you might need to get a copy of ntlmauth.dll and copy it to your sqldev/bin directory
Oracle ACE Director Kent Graziano talks about that on his blog here
https://kentgraziano.com/2013/01/14/tech-tip-connect-to-sql-server-using-oracle-sql-developer/
