Re: Problem trying to connect to SQL Server 2008 R2 box

John,

I have the latest STABLE version 3.3.0.  I will try and get the latest snapshot version.  Does anyone know when
3.4.0 version is coming out?  I may wait for that.

Also, I did download the latest SQL Server drivers from the MS site.

Thanks again.

-----Original Message-----
From: John Hardin [mailto:jhardin <at> impsec.org] 
Sent: Monday, July 23, 2012 2:49 PM
To: Savoy, Melinda
Cc: squirrel-sql-users <at> lists.sourceforge.net
Subject: RE: [Squirrel-sql-users] Problem trying to connect to SQL Server 2008 R2 box

On Mon, 23 Jul 2012, Savoy, Melinda wrote:

> Thanks John.  I appreciate ALL your help.

Ok, since my last post I installed Squirrel on my Linux laptop (It's gloomy here and this is better than
sitting in front of the teevee...) and confirmed it works against my MSSQL2008 dev install on my work box
using a SQL Server login. I did not try a Domain login.

(1) I upgraded to the current snapshot version. Are you using stable or snapshot? If stable, you might want
try switching to the snapshot.

(2) I downloaded the MSSQL JDBC drivers from the MSFT website. Did you do that? Here is the URL:

http://download.microsoft.com/download/0/2/A/02AAE597-3865-456C-AE7F-613F99F850A8/sqljdbc_4.0.2206.100_enu.tar.gz

> Still trying to get a zip file to install on my windows box and see if 
> I can get it to work just like you have it working.  Still prefer to 
> get it working on Linux if I can.
>
> Have a GREAT vacation!
>
> Regards.
>
> -----Original Message-----
> From: John Hardin [mailto:jhardin <at> impsec.org]
> Sent: Monday, July 23, 2012 1:10 PM
> To: Savoy, Melinda
> Cc: squirrel-sql-users <at> lists.sourceforge.net
> Subject: RE: [Squirrel-sql-users] Problem trying to connect to SQL 
> Server 2008 R2 box
>
> On Mon, 23 Jul 2012, Savoy, Melinda wrote:
>
>> Sorry.  Yes, I have indeed tried the SQL Server login as well as the windows authentication but to no avail.
>
> Bother.
>
> Unfortunately I don't have Squirrel set up on Linux here (I need to do
> that) or I'd test in my environment.
>
> I might do that this week (I'm on vaca) and let you know if nobody else offers a solution.
>
>> -----Original Message-----
>> From: John Hardin [mailto:jhardin <at> impsec.org]
>> Sent: Monday, July 23, 2012 12:55 PM
>> To: Savoy, Melinda
>> Cc: squirrel-sql-users <at> lists.sourceforge.net
>> Subject: RE: [Squirrel-sql-users] Problem trying to connect to SQL 
>> Server 2008 R2 box
>>
>> On Mon, 23 Jul 2012, Savoy, Melinda wrote:
>>
>>> Hi John.  Yes each SQL Server is setup to accept both Windows and 
>>> SQL authentication (mixed mode).
>>>
>>> I am able to login from my SQL Server 2008 Client via the management 
>>> studio to each of these boxes.  I just can't seem to connect via 
>>> SQuirreL from my Debian 6 Linux box.
>>
>> I could see attempting to use a Domain login having problems in that situation. Have you tried a SQL Server
login? You haven't clearly stated whether you've tried that, and if you have, whether or not it works.
>>
>>> Thanks.
>>>
>>> -----Original Message-----
>>> From: John Hardin [mailto:jhardin <at> impsec.org]
>>> Sent: Monday, July 23, 2012 12:44 PM
>>> To: Savoy, Melinda
>>> Cc: squirrel-sql-users <at> lists.sourceforge.net
>>> Subject: Re: [Squirrel-sql-users] Problem trying to connect to SQL 
>>> Server 2008 R2 box
>>>
>>> On Mon, 23 Jul 2012, Savoy, Melinda wrote:
>>>
>>>> I have downloaded SQuirreL 3.3.0 on my Debian 6 Linux box and it loaded great.  I'm trying to setup my
Alias to connect to the 3 SQL Server 2008 R2 boxes on our network.
>>>>
>>>> I can connect to these boxes remotely from my own SQL Server 2008 client on my Windows 7 box but when I try
to connect to these SQL Server boxes from my SQuirreL client in Debian I get the following error:
>>>>
>>>> Golden: Login failed for user 'admin-mxs'.
>>>> ClientConnectionId:5dea83e5-3407-4d05-b307-84e826b4436f
>>>>
>>>> I've tried entering the username with and without the DOMAIN NAME\admin-mxs but still get the same error.
>>>>
>>>> Any help/direction would be appreciated.
>>>
>>> I can confirm that Squirrel does work with MSSQL2008R2 from W7 x64 using SQL Server logins. I am not sure
that Windows Domain logins work.
>>>
>>> Are you able to configure your server to accept SQL Server logins (Mixed mode)?
5~
--

-- 
  John Hardin KA7OHZ                    http://www.impsec.org/~jhardin/
  jhardin <at> impsec.org    FALaholic #11174     pgpk -a jhardin <at> impsec.org
  key: 0xB8732E79 -- 2D8C 34F4 6411 F507 136C  AF76 D822 E6E6 B873 2E79
-----------------------------------------------------------------------
   It is not the place of government to make right every tragedy and
   woe that befalls every resident of the nation.
-----------------------------------------------------------------------
  13 days until the rover Curiosity lands on Mars

------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/