Hi I have a very strange problem with SQLServer and Java Before I upgrade to Windows XP media Center edition , everything works correctly. Now i installed SQL server and other utils which i need . but none of them connect to sql server I changed the authentication to MIXED mode and add user to sql Server but when i try to connect to sql server from my java application it says :
SQL SERVER does not exist or access denied or Connection refused
can some one pleas help me to solve it ?what is wrong ? i connect to sql server with Enterprise Manager , and also from a .net application with no peoblem (in both of them I used sql server authentication) but none of my java applications connect to sql server any more.
By what you said it seems that TCP is enabled (you connect from .net) and problem is Windows SP2 security stuff . what you should do is very simple
1-get latest SP for sql server , it should be SP4 2-add MSSQL\Binn\sqlservr.exe to exceptions in firewall controlled in C panel. add 1433 as A TCP port AND 4-Add 1434 as UDP port in exceptions section too
now restart the PC and you will have SQL server listening on the port.
any way : Allways check for open ports by using telnet . if telnet connect then some program is listening otherwise do not bother yourself with testing several programs over a port.