|
From: Neville R. <row...@ho...> - 2016-05-12 06:09:44
|
Hmmm. So HeidiSQL is written in Delphi / Object Pascal and uses a custom DB connection layer - not jdbc therefore going to be a different set of problems. DBeaver on the other hand is java based and uses jdbc. On installation when I first start to create a jtds connection to MS SQL, DBeaver comes up with a screen 'missing files, you can download them automatically' which includes the ntlmauth.dll. It seems to use Maven to sort that out. The dll is then installed in a dbeaver/metadata folder in the users home directory. Also DBeaver distributes and uses a specific JRE rather than the one installed in the system by default - which presumably means they can have more flexibility. I'll think about what we could do with this.... At the very least a sensible error message should be possible but maybe we could do something cleverer. I'm sure that DLL doesn't have to be in the JRE directory, we should be able to tell the JVM where to find it. Neville > From: don...@gm... > To: squ...@li... > Date: Wed, 11 May 2016 20:40:10 -0600 > Subject: [Squirrel-sql-users] Cannot connect MSSQL > > Well, it is solved! > Thank you for all your suggestions. The actual answer was quite convoluted. > There is a dll that needed to be loaded in the Java bin directory that > allows for Windows Single Sign on (SSO). > The file is ntlmauth.dll. This file comes with the jtds-1.3.1-dist from > SourceForge. > > Regardless if your OS is 64 bit or not, you need to use the version of > ntlmauth.dll that corresponds to your Java (32 or 64 bit) version. > So if you're running a 64 bit Windows, but Java is 32 bit, then you need > copy the ntlmauth.dll in the x86 folder to the Java bin under > C:\Program(x86)\Java\jreXX.XX\bin > > Then remember not to use a username and password when logging on. This > worked for a networked server at work, as well as a local server on my > computer at home. > > Solved. It was well worth it for the query building capabilities in the > Squirrel if for nothing else! > > It is interesting that two other clients; HeidiSQL, and DBeaver, didn't have > this problem at all and allowed me to connect immediately (hint, hinit??) > > Don > ------------------------------ > > Message: 3 > Date: Tue, 10 May 2016 12:12:11 +0100 > From: Neville Rowe <row...@ho...> > Subject: Re: [Squirrel-sql-users] Cannot connect MSSQL > To: Don Barton <don...@gm...> > Cc: squ...@li... > Message-ID: <DUB...@ph...l> > Content-Type: text/plain; charset="us-ascii" > > Hi Don, > A quick check - have you got the driver loaded? I don't use the JTDS driver > but I just up that URL into Squirrel here and got that error. > Neville > > > > > ------------------------------------------------------------------------------ > Mobile security can be enabling, not merely restricting. Employees who > bring their own devices (BYOD) to work are irked by the imposition of MDM > restrictions. Mobile Device Manager Plus allows you to control only the > apps on BYO-devices by containerizing them, leaving personal data untouched! > https://ad.doubleclick.net/ddm/clk/304595813;131938128;j > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
