From stonehenge-dev-return-1723-apmail-incubator-stonehenge-dev-archive=incubator.apache.org@incubator.apache.org Tue Aug 25 10:02:07 2009 Return-Path: Delivered-To: apmail-incubator-stonehenge-dev-archive@minotaur.apache.org Received: (qmail 35029 invoked from network); 25 Aug 2009 10:02:06 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 25 Aug 2009 10:02:06 -0000 Received: (qmail 32056 invoked by uid 500); 25 Aug 2009 10:02:32 -0000 Delivered-To: apmail-incubator-stonehenge-dev-archive@incubator.apache.org Received: (qmail 31990 invoked by uid 500); 25 Aug 2009 10:02:31 -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 31980 invoked by uid 99); 25 Aug 2009 10:02:31 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 25 Aug 2009 10:02:31 +0000 X-ASF-Spam-Status: No, hits=-1.8 required=10.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_MED,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: local policy) Received: from [192.18.19.6] (HELO sineb-mail-1.sun.com) (192.18.19.6) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 25 Aug 2009 10:02:19 +0000 Received: from fe-apac-05.sun.com (fe-apac-05.sun.com [192.18.19.176] (may be forged)) by sineb-mail-1.sun.com (8.13.6+Sun/8.12.9) with ESMTP id n7PA1fel003234 for ; Tue, 25 Aug 2009 10:01:56 GMT MIME-version: 1.0 Content-type: multipart/alternative; boundary="Boundary_(ID_Ib/nvlpi3ocyqXQkhEyz3g)" Received: from conversion-daemon.mail-apac.sun.com by mail-apac.sun.com (Sun Java(tm) System Messaging Server 7u2-7.04 64bit (built Jul 2 2009)) id <0KOX00K00FLRDV00@mail-apac.sun.com> for stonehenge-dev@incubator.apache.org; Tue, 25 Aug 2009 18:01:41 +0800 (SGT) Received: from [192.168.11.3] ([unknown] [59.92.190.220]) by mail-apac.sun.com (Sun Java(tm) System Messaging Server 7u2-7.04 64bit (built Jul 2 2009)) with ESMTPSA id <0KOX000P7FUQZKG0@mail-apac.sun.com> for stonehenge-dev@incubator.apache.org; Tue, 25 Aug 2009 18:01:41 +0800 (SGT) Date: Tue, 25 Aug 2009 15:31:38 +0530 From: Prajwal Muralidhara Subject: Re: Network Connecton Error In-reply-to: Sender: Prajwal.Muralidhara@Sun.COM To: stonehenge-dev@incubator.apache.org Message-id: <4A93B682.2060108@sun.com> References: <4A8FDA78.2050107@sun.com> <918d33e0908220611v5976dbb6te011ae048cde51fc@mail.gmail.com> <4A9047A2.3000507@sun.com> <4A92D8AC.6010005@sun.com> User-Agent: Thunderbird 2.0.0.22 (Windows/20090605) X-Virus-Checked: Checked by ClamAV on apache.org --Boundary_(ID_Ib/nvlpi3ocyqXQkhEyz3g) Content-type: text/plain; CHARSET=US-ASCII; format=flowed Content-transfer-encoding: 7BIT 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 >> >> >> >> > > > --Boundary_(ID_Ib/nvlpi3ocyqXQkhEyz3g)--