From stonehenge-dev-return-1726-apmail-incubator-stonehenge-dev-archive=incubator.apache.org@incubator.apache.org Tue Aug 25 16:19:40 2009 Return-Path: Delivered-To: apmail-incubator-stonehenge-dev-archive@minotaur.apache.org Received: (qmail 81698 invoked from network); 25 Aug 2009 16:19:40 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 25 Aug 2009 16:19:40 -0000 Received: (qmail 77288 invoked by uid 500); 25 Aug 2009 16:20:05 -0000 Delivered-To: apmail-incubator-stonehenge-dev-archive@incubator.apache.org Received: (qmail 77223 invoked by uid 500); 25 Aug 2009 16:20:05 -0000 Mailing-List: contact stonehenge-dev-help@incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: stonehenge-dev@incubator.apache.org Delivered-To: mailing list stonehenge-dev@incubator.apache.org Received: (qmail 77213 invoked by uid 99); 25 Aug 2009 16:20:05 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 25 Aug 2009 16:20:05 +0000 X-ASF-Spam-Status: No, hits=2.2 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of skyairmj@gmail.com designates 209.85.222.187 as permitted sender) Received: from [209.85.222.187] (HELO mail-pz0-f187.google.com) (209.85.222.187) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 25 Aug 2009 16:19:55 +0000 Received: by pzk17 with SMTP id 17so1511411pzk.32 for ; Tue, 25 Aug 2009 09:19:35 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:content-type; bh=K5rrd2ALOn1MuNNwZTfXekzXZtoOCepWTOGgd9YQ6iY=; b=UBDPUTDPdN3LQYyf2eTOE7w1lfx6RrxZaHPBumGMVhrYtoeieSsCNskdK8JnFoL2lG k9ucAl4IvPhgwezUkpCmvQa/WFv9XK388cU/k9NFfzU25c15AcNtoVX4YQKwbEpnAwdD /Mtw0Sf1RrUmIhi4d/2hSWPYCWMGYNTdeueN0= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; b=wsD0DXDB7XBX4qoJxigxQf1zuJBdoegkd7H1PBv+oyG8kY4V9b9OT57lYDhtS8/Wue pq3mRTjkA4Pf9jf4OrVeJSP3y6DuWBwoNOeq/UUWQrL2eXQtIV7thmtlKfxAyrwhfW7r PBkvvCieBugOsJNbeVSPuoMjoA71MZddl3li0= MIME-Version: 1.0 Received: by 10.142.3.3 with SMTP id 3mr358785wfc.141.1251217175378; Tue, 25 Aug 2009 09:19:35 -0700 (PDT) In-Reply-To: <4A93B682.2060108@sun.com> References: <4A8FDA78.2050107@sun.com> <918d33e0908220611v5976dbb6te011ae048cde51fc@mail.gmail.com> <4A9047A2.3000507@sun.com> <4A92D8AC.6010005@sun.com> <4A93B682.2060108@sun.com> Date: Wed, 26 Aug 2009 00:19:35 +0800 Message-ID: <2f7a32570908250919v442c68f6h29bfbe7bdffd98d@mail.gmail.com> Subject: Re: Network Connecton Error From: Ming Jin To: stonehenge-dev@incubator.apache.org Content-Type: multipart/alternative; boundary=0016368e2704467bc30471f9b3cc X-Virus-Checked: Checked by ClamAV on apache.org --0016368e2704467bc30471f9b3cc Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Hi Prajwal, Just want to confirm, have you tried Chintana's suggest? To Add a new exception for Port 1433 in Windows Firewall. Does "telnet 1433" work now? -- Jin Ming On Tue, Aug 25, 2009 at 6:01 PM, Prajwal Muralidhara < Prajwal.Muralidhara@sun.com> wrote: > hi Scott, > >> It sounds like you have the setup correct. Are you still getting the >> error? >> >> >> > Yes Scott, I'm still getting the error.. > >> If I followed the setup correctly you have SQL server installed on a >> virtual >> machine with the Stocktrader application on the host machine. >> > No, I have isolated all my applications from host. I have all my necessary > softwares installed in the guest: MSSQL, Server Management, Stocktrader > Application, Glassfish server all are in guest(XP) OS. If I need any files > from host, I open a shared folder from host and map a network drive in > guest. This is done as soon as my vmware starts. Should I undo this?is the > n/w connection , between guest and host, causing the problem? > > > regards, > Prajwal > > > > > If this is the >> case you can try connecting to the SQL server from the virtual machine to >> help narrow down the possible causes of the error. If you installed SQL >> Server Management studio you can open it and from the >> login dialog box choose a server type of "Database Engine", choose or >> enter >> your server in the server name field (I use "localhost\SQLExpress), choose >> "SQL Server Authentication" for the authentication type, enter sa for the >> login, and enter the password. Then click on the options button at the >> bottom right of the dialog. From the connection properties tab change the >> network protocol to TCP/IP. If you can click the connect button and >> connect >> to the server then you know that TCP/IP is configured correctly on the SQL >> server and the problem most likely is with the firewall/DNS/configuration >> settings. If you didn't install SQL Server Management studio you can use >> the command >> line tool SQLCMD. To do that open a command prompt. In my installation >> SQLCMD is in the path but if it is not on your machine you will need to >> change to the c:\program files\Microsoft SQL Server\100\Tools\Binn >> directory. You can type sqlcmd -? for the full syntax but the following >> command line should let you connect to test. >> Sqlcmd -U sa -P -S >> There is no way with sqlcmd to force a particular protocol for connecting >> but if you use something like 127.0.0.1\SQLExpress for the machine name it >> should use TCP/IP. >> >> Scott Golightly >> -----Original Message----- >> From: Prajwal.Muralidhara@Sun.COM [mailto:Prajwal.Muralidhara@Sun.COM] >> Sent: Monday, August 24, 2009 12:15 PM >> To: stonehenge-dev@incubator.apache.org >> Subject: Re: Network Connecton Error >> >> hi Scott, >> I have enabled TCP/IP connection in MSSQL. I also added 1433 port to my >> firewall. I have installed MSSQL in sa mode, with a password(I guess its >> called SQL Authentication mode??). Should i reinstall it with default >> options?? >> Prajwal >> >> >> >> Scott Golightly wrote: >> >> >>> Prajwal, >>> >>> >>> You may need to enable TCP/IP on the SQL Server. This is based on SQL >>> Server 2008 Express running on Windows Server 2008 but from what I remember >>> of XP the steps are the same. >>> >>> To enable TCP/IP from the start menu go to start -> All Programs -> >>> Microsoft SQL Server 2008 -> SQL Server Configuration Manger. >>> >>> In the left pane choose SQL Server Network Configuration -> Protocols for >>> . By default Shared Memory is the only protocol >>> enabled. Right click on TCP/IP in the right pane and choose enable. >>> >>> You will have to restart your SQL Server (You can do this by selecting >>> SQL Server Services in the left hand panel and right click on the SQL server >>> instance then choose restart from the menu). >>> >>> >>> Scott Golightly >>> >>> >>> >>> >> >> >> >> > > -- Ming Jin Consultant Thoughtworks, Inc Mobile: +86 135-2125-6300 Email: skyairmj@gmail.com MSN: skyairmj@hotmail.com Blog: http://blogjava.net/mingj Twitter: https://twitter.com/mingjin --0016368e2704467bc30471f9b3cc--