Gennadiy.Skuha Posted February 27, 2007 Share Posted February 27, 2007 Please, help to setup MSSQL datasource.I have the problem:"SQL Problems: [Microsoft][sqlServer 2000 Driver for JDBC] Error establishing socket. ....." size=399]http://www.jasperforge.org/components/com_joomlaboard/uploaded/images/sock_error-784f255e14a723915dbff21b73291ec2.gif But i have not any problem with MSSQL Query Analyzer connecting.Has anybody do that successfully? (connect to the MSSQL server).It seems impossible Link to comment Share on other sites More sharing options...
Gennadiy.Skuha Posted March 7, 2007 Author Share Posted March 7, 2007 I glad to tell you that I decided my problem. My MSSQL 2000 was required to install SP3(or higher)My OS is WINXP and it had problem with MSSQL TCP connection on the default port 1433. I meen that command "telnet 127.0.0.1 1433" must perform successfully.More info about this problem you could find here: http://support.microsoft.com/kb/313100Thanks to all. ;) Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now