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

[Andreas O. <cpt...@gm...>]

Hi Melinda,

which JDBC driver do you use? Using the jtds driver 
/http://jtds.sourceforge.net//worked quite well for me for connecting to 
a  SQL 2005 database. I'll give it a try on a Linux Box at work tomorrow.

Take care

Anreas

Am 23.07.2012 19:46, schrieb Savoy, Melinda:
> 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.
>
> 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)?
>