Hi...i am tryin to connect to sqlserver2000 ....i wanted a dsnless
connection...i have downloaded jtds driver...set the classpath..no
joy..i'm connecting to sqlserver's default port 1433..i also confirmed
that sqlserver tcp is enabled...still gettin the same err:
i even tried connecting to the port 1433 thru telnet...err:Could not
open connection to the host, on port 1433:connection failed...
i thought it cud b a firewall issue...disabled my windows firewall..no joy..
can ne body help me with this....need to solve this desparately
thanks in advance
jude
Hi,
I too was facing the same problem as mentioned by you and couldn't connect through telnet localhost 1433.
Solution : Just go to SQL server configuration manager----SQL Server Network configuration----Protocols for SQLEXPRESS and in that right click on TCP/IP and in properties field make all TCP/IP port to 1433 which is blank. Start and Restart the SQL server and you can telnet localhost 1433 and it works. Hope this will help.
Ghanshyam
gimatpune@hotmail.com
If you have access to the SQL Server configuration, verify the port.
8,797 views
Usually answered in minutes!
Anybody resolved this?
×