Hi,
I've searched for an answer for hours so this newsgruoup is my last chance.

A Java Application uses a JDBC driver without port specification.
Something like

jdbc:sqlserver://localhost;instanceName=instance1 [..]

instance1 is a named instance in a two-nodes cluster active-active with
a different port than default, for example 3234.
In this case the last connection string dosn't work, BUT if I try
something like

jdbc:sqlserver://localhost;instanceName=instance1:3234 it works.

Now, I don't understand. Sql Server Browser is up and running, and
I know that it have to provide these informations like port number and
istance name. So, what about this behaviour ? Do I really need port
number anyway ?

Thanks in advance for your help

Bye

ES

ES (emacpi (AT) NOSPAMyahoo (DOT) it) writes:
Have you verified that UDP port 1434 is open in the firewall?


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

Il 14/02/2011 14.06, Erland Sommarskog ha scritto:

Quite strange : SSBrowser service is up 'n running but
there's no port 1434 listening. Further more , there's no port listening
associated to sqlbrowser.exe's PID, also after a bounce.

I've no idea.
Anyway, thanks for the advice.

ES

ES (emacpi (AT) NOSPAMyahoo (DOT) it) writes:
Note that the Browser Services uses UDP, not TCP, and you don't "listen"
to a UDP port in the same way as a TCP port.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx

Il 14/02/2011 23.17, Erland Sommarskog ha scritto:

True,
I made a mistake
in fact here's SSBrowser port and PID on netstat -a

UDP 0.0.0.0:1434 *:*
11028

but it doesn't work as I wish..
I've no firewall on this server.