Re: [Squirrel-sql-users] Problem trying to connect to SQL Server 2008 R2 box

[Savoy, M. <ms...@wc...>]

Thanks John.  I appreciate ALL your help.

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:jh...@im...] 
Sent: Monday, July 23, 2012 1:10 PM
To: Savoy, Melinda
Cc: squ...@li...
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:jh...@im...]
> Sent: Monday, July 23, 2012 12:55 PM
> To: Savoy, Melinda
> Cc: squ...@li...
> 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:jh...@im...]
>> Sent: Monday, July 23, 2012 12:44 PM
>> To: Savoy, Melinda
>> Cc: squ...@li...
>> 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)?

-- 
  John Hardin KA7OHZ                    http://www.impsec.org/~jhardin/
  jh...@im...    FALaholic #11174     pgpk -a jh...@im...
  key: 0xB8732E79 -- 2D8C 34F4 6411 F507 136C  AF76 D822 E6E6 B873 2E79
-----------------------------------------------------------------------
   Efficiency can magnify good, but it magnifies evil just as well.
   So, we should not be surprised to find that modern electronic
   communication magnifies stupidity as *efficiently* as it magnifies
   intelligence.                                   -- Robert A. Matern
-----------------------------------------------------------------------
  13 days until the rover Curiosity lands on Mars