Oracle SQL Developer to MS SQL Server
-
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".
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?
-
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)
-
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.htmlFrom 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.
-
Thanks. I'll let our developer know.
-
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.
-
https://www.macsqlclient.com/
never used it, don't know if it is any goodor https://docs.microsoft.com/en-us/sql/azure-data-studio/download?view=sql-server-2017 - forgot that this new thing existed
-
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.
-
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 😀
- frederico_fonseca - Tuesday, October 23, 2018 5:09 AM
And it doesn't require an Azure database to work? It'll work on a non-cloud instance?
-
works with any sql database. does not require azure/cloud
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply