Question about Microsoft SQL Server 2000 Standard Edition for PC
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
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.
Posted on Dec 02, 2008
If you have access to the SQL Server configuration, verify the port.
Posted on Nov 06, 2008
Tips for a great answer:
Oct 08, 2011 | Lexmark X4580 InkJet Printer
May 07, 2011 | Sun Computers & Internet
Mar 12, 2011 | Office Equipment & Supplies
Oct 27, 2010 | Computers & Internet
Aug 19, 2009 | Microsoft SQL Server 2000 Standard Edition...
Mar 13, 2009 | Sybase SQL Anywhere Studio for Workgroups...
Sep 24, 2017 | Microsoft SQL Server 2000 Standard Edition...
Sep 05, 2008 | Computers & Internet
May 22, 2020 | Power Computers & Internet
8,607 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: