|
From: Savoy, M. <ms...@wc...> - 2012-07-23 17:46:20
|
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)? -- 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 ----------------------------------------------------------------------- If guns kill people, then... -- pencils miss spel words. -- cars make people drive drunk. -- spoons make people fat. ----------------------------------------------------------------------- 13 days until the rover Curiosity lands on Mars |
