October 22, 2018 at 1:13 pm
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)
October 22, 2018 at 1:38 pm
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.
October 23, 2018 at 3:33 am
Thanks. I'll let our developer know.
October 23, 2018 at 3:48 am
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.
October 23, 2018 at 4:09 am
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
October 23, 2018 at 4:25 am
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.
October 23, 2018 at 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 😀
October 23, 2018 at 5:17 am
frederico_fonseca - Tuesday, October 23, 2018 5:09 AMshould 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?
October 23, 2018 at 5:30 am
works with any sql database. does not require azure/cloud
Viewing 9 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply