Question about Microsoft SQL Server 2000 Standard Edition for PC

2 Answers

Java.sql.SQLException: Network error IOException: Connection refused: connect

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

Posted by on

  • vicmanac Jan 02, 2009

    Anybody resolved this?

×

2 Answers

  • Level 1:

    An expert who has achieved level 1.

    Corporal:

    An expert that has over 10 points.

    Mayor:

    An expert whose answer got voted for 2 times.

  • Contributor
  • 1 Answer

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

Posted on Dec 02, 2008

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Governor:

    An expert whose answer got voted for 20 times.

    Teacher:

    An expert who has written 2 tips or uploaded 1 video tip.

  • Expert
  • 66 Answers

If you have access to the SQL Server configuration, verify the port.

Posted on Nov 06, 2008

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

The software does not eve open and I get a message that Says " A network-related or instance-specific error occurred while establishing a connection to SQL Server. The Server was not found or was not...


This is a tougher one! Sometimes when you open the software too fast before thedatabase starts up, you get this. Make sure the SQL Server services are running in Windows before opening RPE

Jun 06, 2011 | Pc America Restaurant Pro Express

2 Answers

Network error IOException: Connection refused: connect


Please check that you are on the same sub net and that your network setting correspond to those required by the server including matching access passwords etc.

Aug 19, 2009 | Microsoft SQL Server 2000 Standard Edition...

1 Answer

After installing DB2 query is not executing


could you check whether you are connected to the database, where you are trying to create table,

check the database list, then connect to the database you want then execute the table creation ddl,
if no db found then create a database then proceed.

Dec 05, 2008 | IBM DB2 Connect Enterprise Edition for PC,...

1 Answer

I installed DB2 in my laptop . then i go to all programs->DBCOPY1(default)-> command line tools -> command editor then write down query to create a table but i cant build it it is showing CREATE TABLE...


Hi,

Before you create a table you need to:-

1. create a database
2. create a username and password or use the admin generated userid
3. connect to the database

you can then create a table and use the database

Please post if you do not know how to do this and i'll give you some links

Dec 05, 2008 | IBM DB2 Connect Enterprise Edition for PC,...

1 Answer

SQL Server 2005 set up ... ERROR Replprov .dll


are you installing from DVD ?

Maybe try copying installation to local drive.
Do not copy to desktop or other sub folder of "Documents and Setting" as this causes other problems in some cases.

Oct 17, 2008 | Microsoft SQL Server 2000 Standard Edition...

1 Answer

Hibernate configuration with windows authentication


When you login to your database (download the management tool) right click on server name->properties->security.

There you can choose mixed authentication.

Sep 05, 2008 | Business & Productivity Software

1 Answer

Oracle SQL Error


Does it connect after the error ?. First try to connect from your client to Oracle server using SQL plus client.

Second - Do a tnsping <server name>

This will give you the correct Host name, SID and Port number.

Make sure that your JDBC connection parameters match with the actual connection from TNS output

Sep 04, 2008 | Oracle 10g Database Standard (ODBSEONUPP0)

1 Answer

MyEclipse6.0.1 connection with sqlserver 2000


hi


Try with MS SqlServer 2005 JDBC Driver,
i had a similar problem with 2000 jdbc driver

Dec 03, 2007 | Microsoft SQL Server Standard Edition for...

Not finding what you are looking for?
Microsoft SQL Server 2000 Standard Edition for PC Logo

8,384 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18299 Answers

Tony

Level 3 Expert

2598 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...