DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2005

    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
    New Jersey
    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
Latest Articles
Questions? Contact us.
Web Development
Latest Tips
Open Source

   Development Centers

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.