Re: [Squirrel-sql-users] Problem trying to connect to SQL Server 2008 R2 box
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
From: John H. <jh...@im...> - 2012-07-23 19:49:02
|
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: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)? 5~ -- 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 ----------------------------------------------------------------------- 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 |