Problems with MSSQLServer and Java


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Problems with MSSQLServer and Java

  1. #1
    Join Date
    Mar 2005
    Posts
    27

    Problems with MSSQLServer and Java

    I'm running SQLServer 2000 on XP on a new box. I've copied old code to the new box. Running the code to test the SQL connect I get the message.
    The box is on a home network, with a wireless router. I access the internet without problems.

    java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.

    I went back to the old machine Win2k and ran the same code against MSSQLServer 2000 with no errors.

    Other things I did:
    I runing Norton Security 2005 on both machines.
    pinged localhost on the XP no problem
    ping the ComputerName and got timed out
    Shut down Norton and repeated the ComputerName ping no problems
    ran the java code and got the same error message.

    Ran the SQL update SP4 and retested the above with the same results.
    I'm not too clear on how one should turn on/off ports.

    I tested the SQL connect using the ODBC Manager no problems there.

    Any one have any ideas?

  2. #2
    Join Date
    Oct 2005
    Location
    New Jersey
    Posts
    255
    I guess you are using Windows Integrated Authentication. Try setting the authentication to mixed mode "SQL server and Windows Authentication". The JDBC drivers have some problem with the Windows Integrated Authentication.
    Happiness is good health and a bad memory.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center