-
1. Re: can not cooect to sqlserver on windows xp or 2003
darranl Sep 11, 2005 7:19 AM (in response to saeedy)It is a little while since I last used SQL server, are you sure the personal edition allows network access to it?
Does their documentation tell you how to connect to it using JDBC? -
2. Re: can not cooect to sqlserver on windows xp or 2003
saeedy Sep 11, 2005 10:08 AM (in response to saeedy)how can i find personal edition allows network access to it?
i am begginer can u help me
thanks -
3. Re: can not cooect to sqlserver on windows xp or 2003
darranl Sep 11, 2005 10:38 AM (in response to saeedy)You could start by looking at: -
http://support.microsoft.com/default.aspx?scid=kb;en-us;827422 -
4. Re: can not cooect to sqlserver on windows xp or 2003
saeedy Sep 11, 2005 12:47 PM (in response to saeedy)sql server is ok
and client can client can connect to this.
i am beginner with jboss and jdbc configuration
my application running on linux and uses datasource for coonnect to sql server
that running on windows os
all thing was ok
but when i change my os (change it to xp or 2003) i could'nt connect to that sql that runs on this os
now can you tell me where is the problem
if need to change my structure or my configuration
can you introduce documentation about this or tell me a way to solve this problem -
5. Re: can not cooect to sqlserver on windows xp or 2003
darranl Sep 11, 2005 1:54 PM (in response to saeedy)Are you installing the same version of SQL server on the XP or 2003 machines as you installed in 2000. What version of Windows 2000 is it professional / server?
Have you checked if any firewall is enable on XP that might be blocking comms?
Have you verified that tcpip is enable for SQL server?
What happened when you executed 'netstat -an' on the XP machine, check the output on the 2000 machine as if that one is working that should show the expected output. -
6. Re: can not cooect to sqlserver on windows xp or 2003
saeedy Sep 11, 2005 2:49 PM (in response to saeedy)i use sql server professional on all os
and i use windows xp service pack 2 firewall is off
and tcp/ip enabled -
7. Re: can not cooect to sqlserver on windows xp or 2003
darranl Sep 11, 2005 3:14 PM (in response to saeedy)"saeedy" wrote:
i take exception i use jtds driver and jboss with j2sdk1.4.1_05 , pesonal sqlserver"saeedy" wrote:
i use sql server professional on all os
Can you please double check the SQL server version, in the space of 11 hours you have reported two very different version.
Did the netstat command show you that SQL server was listening on the port you expected?
Also can you try the command 'telnet 192.168.1.1 1433' from the machine running JBoss to see if you can establish a connection to the port you are specifying.
The error you have posted suggests that there is nothing listening on the port you have specified: -java.sql.SQLException: Connection refused: connect
-
8. Re: can not cooect to sqlserver on windows xp or 2003
saeedy Sep 12, 2005 12:38 AM (in response to saeedy)i think i have sql problem
when i use netstat -an on windows 2000 i see
tcp 127.0.0.1:1433 0.0.0.0 listening
tcp 192.168.1.6:1433 0.0.0.0 listening
and i can telnet to this windows with port 1433
but i dont see this protocol and local address on windows xp or 2003
and i cant telnet to these windows with port 1433 -
9. Re: can not cooect to sqlserver on windows xp or 2003
tandonsaurabh Sep 14, 2005 1:03 AM (in response to saeedy)You need to install latest service pack for SQL Server 2000 i.e. service Pack 3.
Unless you have "SQL server listening on TCP, Shared....." in the ErrorLog of the SQL Server (<<SQL Sever install directory>>\MSSQL\LOG\ERROR.LOG) the listener is not started to which the JDBC driver connect. -
10. Re: can not cooect to sqlserver on windows xp or 2003
saeedy Sep 18, 2005 7:36 AM (in response to saeedy)i have local network
and firewall is off
there is no listiner for sql server
when i use netstat -an on windows 2000 i see
tcp 127.0.0.1:1433 0.0.0.0 listening
tcp 192.168.1.6:1433 0.0.0.0 listening
and i can telnet to this windows with port 1433
but i dont see this listiner for windows xp or 2003
and i cant telnet to these windows with port 1433 -
11. Re: can not cooect to sqlserver on windows xp or 2003
darranl Sep 18, 2005 8:00 AM (in response to saeedy)Have you followed the steps in the trouble shooting guide to get TCP working?
Have you made sure you have installed the reccomended service pack? -
12. Re: can not cooect to sqlserver on windows xp or 2003
saeedy Sep 19, 2005 7:17 AM (in response to saeedy)yes
i install sp2 for sqlserver and not answerd
and when i want install sp4 this message ocured
invalid instance names