Oracle SQL Developer to MS SQL Server

  • Brandie Tarvin

    SSC Guru

    Points: 172517

    I have a coworker in the UK using a MacBook and Oracle SQL Developer to connect to one of our SQL instances. He's having problems connecting and we think it's possibly down to a login issue, but we can't seem to figure out what the issue is.

    Here's the scrubbed info:
    Server name is XKY-1234 with named instance SQLDevInst. His login is part of a Windows Active Directory security group called SQLDevGrp1. So using the below image I got off of Google, I told him to enter his windows username and password at the top, then put XKY-1234;instnce=SQLDevInst in the hostname and the port in the port, then the database name in "Retrieve Database".

    http://www.snapdba.com/wp-content/uploads/2013/12/sql-dev-ss.png

    He can connect to the instance name. He says that's good. But he's getting the error:

    Status: Failure -Test failed: Login failed for user 'user8'.

    He's tested the username part several different ways. Just using "user8" or "domain\user8" or even "domain/user8." Same error. If he deliberately typos the hostname, he gets an error complaining it can't find the host. So we're pretty sure this is related to either the group login or his personal login.

    The security group has access to the instance and database name in question. db_owner, in fact. I've also verified his login is a member of the security group.

    He's able to connect to another MS SQL Server instance for another team, but it looks like he might be using a SQL login rather than windows authentication. And if he clicks Windows Authentication, it asks for a windows domain. Entering the domain didn't work either.

    Where do I go from here? Any thoughts on what could be causing the connection problem?

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • frederico_fonseca

    SSChampion

    Points: 14051

    theres a connection string setting for that. and another JAR that may be required as far as I remember.

    Going to try and find it out as I did do that before (long ago)

  • frederico_fonseca

    SSChampion

    Points: 14051

    have a look at http://blog.bittersweetryan.com/2012/01/using-oracles-free-sql-developer-as.html?m=1

    you will also need jTDS https://sourceforge.net/projects/jtds/ (mentioned on the link above) and follow a few steps

    care must be taken with the exact java home used sqldeveloper contains a conf file with the one being used, so the dll's above need to be copied to the correct one.
    and do read the FAQ http://jtds.sourceforge.net/faq.html

    From what I remember there was a situation where I had to enter the connection string manually and not use the interface but don't remember if it was on SQL Developer or on one other tool I used.

    As far as I  know it can only use NTLM - if your server is set for Kerberos only this won't work either. But I may be wrong on this.

  • Brandie Tarvin

    SSC Guru

    Points: 172517

    Thanks. I'll let our developer know.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • Brandie Tarvin

    SSC Guru

    Points: 172517

    And I get this in response:

    we would like a simpler solution if possible.. Can you recommend a toolthat we can use on our Macbooks that would work out of the box

    Thoughts?

    I already recommended SQL Server client tools, but I'm not sure if those will install on Macs or if the devs actually know how to use SQL Server.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • frederico_fonseca

    SSChampion

    Points: 14051

    https://www.macsqlclient.com/
    never used it, don't know if it is any good

    or  https://docs.microsoft.com/en-us/sql/azure-data-studio/download?view=sql-server-2017 - forgot that this new thing existed

  • Brandie Tarvin

    SSC Guru

    Points: 172517

    Thanks. I'll see if the Mac client works.

    Not sure Azure Data Studio is going to work. He's doing schema development as well as coding and from what I can see, this tool is a complement to SSMS that manages data, not a replacement for SSMS to do actual building of a thing. But I'll keep it in mind.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • frederico_fonseca

    SSChampion

    Points: 14051

    should be able to do any T-SQL required - no designers like SSMS but those do not prevent doing the work.. just makes it that people need to know what they are doing 😀

  • Brandie Tarvin

    SSC Guru

    Points: 172517

    frederico_fonseca - Tuesday, October 23, 2018 5:09 AM

    should be able to do any T-SQL required - no designers like SSMS but those do not prevent doing the work.. just makes it that people need to know what they are doing 😀

    And it doesn't require an Azure database to work? It'll work on a non-cloud instance?

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • frederico_fonseca

    SSChampion

    Points: 14051

    works with any sql database. does not require azure/cloud

Viewing 10 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply