Very Computer

i have a problem ;-)

when i try to connect to my sql7 server i newly get this error-message:

    java.sql.SQLException: Network error- Connection refused

Now, that looks like the server is not responding on port 1433, and i even
cant connect via telnet on localhos to that port. So it is NOT responding
on that port, but WHY? The Settings in Network-Control is correct, and te
Server is running. SQL-Query Analyzer works just fine.

Could anyone please Help me?

The Server is a MS-SQL 7 with (newly) installed SP4; OS is NT4 Server with
SP6.

from the logs:

2002-06-25 15:39:55.13 spid1    Servername ist 'MUENTER'.
2002-06-25 15:39:55.13 kernel   Verwendet 'SQLEVN70.DLL', Version
'7.00.1063'.
2002-06-25 15:39:55.13 kernel   Verwendet 'OPENDS60.DLL', Version
'7.00.00.1063'.
2002-06-25 15:39:55.13 ods      Verwendet 'SSNMPN70.DLL', Version '7.0.694',
zur berwachung von '\\.\pipe\sql\query'.
2002-06-25 15:39:55.13 ods      Verwendet 'SSMSRP70.DLL', Version '7.0.961',
zur berwachung von 'MUENTER'.
2002-06-25 15:39:55.50 ods      Verwendet 'SSMSSO70.DLL', Version
'7.0.1063', zur berwachung von '1433'.
2002-06-25 15:39:55.50 ods      Fehler: 17826, Schweregrad: 18, Status: 1
2002-06-25 15:39:55.50 ods      ListenOn-Verbindung '1433' konnte nicht
eingerichtet werden..
2002-06-25 15:39:55.50 ods      Betriebssystemfehler 10013, 2002-06-25
15:39:55.50 spid6    Startet Datenbank 'msdb'.
2002-06-25 15:39:55.50 spid6    Opening file
e:\mssql\data\DATA\msdbdata.mdf.
2002-06-25 15:39:55.55 spid7    Startet Datenbank 'pubs'.
2002-06-25 15:39:55.55 spid7    Opening file e:\mssql\data\DATA\pubs.mdf.
2002-06-25 15:39:55.60 spid8    Startet Datenbank 'Northwind'.

I guess it has something to do with the newly installed SQL-SP4, but i
didnt find anything in the docs from MS. Can i uninstall the SQL-SP?

Please help me!

Guido

See if this applies this ID: Q313178    PRB: Error Establishing Socket with JDBC Driver
ID: Q313100   HOW TO: Get Started with Microsoft JDBC

also for the  17826 error: try making an entry in your Hosts file for the SQL server and its correct IP address.

Thank you

Hina Masud
Microsoft

Disclaimer:
This posting is provided AS IS with no warranties, and  confers no rights.
Get Secure! -> http://www.microsoft.com/security

--------------------

-Newsgroups: microsoft.public.sqlserver.connect
-Subject: JDBC connection refused
-Date: Tue, 25 Jun 2002 16:11:16 +0200
-Lines: 52

-NNTP-Posting-Host: prometeus.fmi.uni-passau.de (132.231.64.185)
-X-Trace: fu-berlin.de 1025014260 13149280 132.231.64.185 (16 [2408])
-X-Priority: 3
-X-MSMail-Priority: Normal
-X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
-X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
-Path: cpmsftngxa08!cppssbbsa01.microsoft.com!news-out.cwix.com!newsfeed.cwix.com!isdnet!fu-berlin.de!uni-
berlin.de!prometeus.fmi.uni-passau.DE!not-for-mail
-Xref: cpmsftngxa08 microsoft.public.sqlserver.connect:29862
-X-Tomcat-NG: microsoft.public.sqlserver.connect
-
-hi NG,
-
-i have a problem ;-)
-
-when i try to connect to my sql7 server i newly get this error-message:
-
-    java.sql.SQLException: Network error- Connection refused
-
-Now, that looks like the server is not responding on port 1433, and i even
-cant connect via telnet on localhos to that port. So it is NOT responding
-on that port, but WHY? The Settings in Network-Control is correct, and te
-Server is running. SQL-Query Analyzer works just fine.
-
-Could anyone please Help me?
-
-The Server is a MS-SQL 7 with (newly) installed SP4; OS is NT4 Server with
-SP6.
-
-from the logs:
-
-2002-06-25 15:39:55.13 spid1    Servername ist 'MUENTER'.
-2002-06-25 15:39:55.13 kernel   Verwendet 'SQLEVN70.DLL', Version
-'7.00.1063'.
-2002-06-25 15:39:55.13 kernel   Verwendet 'OPENDS60.DLL', Version
-'7.00.00.1063'.
-2002-06-25 15:39:55.13 ods      Verwendet 'SSNMPN70.DLL', Version '7.0.694',
-zur berwachung von '\\.\pipe\sql\query'.
-2002-06-25 15:39:55.13 ods      Verwendet 'SSMSRP70.DLL', Version '7.0.961',
-zur berwachung von 'MUENTER'.
-2002-06-25 15:39:55.50 ods      Verwendet 'SSMSSO70.DLL', Version
-'7.0.1063', zur berwachung von '1433'.
-2002-06-25 15:39:55.50 ods      Fehler: 17826, Schweregrad: 18, Status: 1
-2002-06-25 15:39:55.50 ods      ListenOn-Verbindung '1433' konnte nicht
-eingerichtet werden..
-2002-06-25 15:39:55.50 ods      Betriebssystemfehler 10013, 2002-06-25
-15:39:55.50 spid6    Startet Datenbank 'msdb'.
-2002-06-25 15:39:55.50 spid6    Opening file
-e:\mssql\data\DATA\msdbdata.mdf.
-2002-06-25 15:39:55.55 spid7    Startet Datenbank 'pubs'.
-2002-06-25 15:39:55.55 spid7    Opening file e:\mssql\data\DATA\pubs.mdf.
-2002-06-25 15:39:55.60 spid8    Startet Datenbank 'Northwind'.
-
-
-I guess it has something to do with the newly installed SQL-SP4, but i
-didnt find anything in the docs from MS. Can i uninstall the SQL-SP?
-
-Please help me!
-
-Guido
-
-
-
-