Posted by Mark Delaney on 12/29/06 00:33

When using the MS SQL 2005 JDBC driver, I now need to have the DNS name
resolution to the client correctly set up. If not I get the following
error:

SQLState: 08S01
SQLError: 0
Message: hostname : hostname

Where "hostname" is the client host name. It doesn't seem to matter if
I
use an IP address or hostname in my connection URL. When searching the
net,
I have seen a similar error, but not exactly the same, where the
message is
"Hostname: hostname not found" (once again, here "hostname" is the
client
machine) where they suggested the issue was the DNS name conflict.

I found the error goes away if the client machine's hostname match the
DNS
name used for the same IP addess that the DB server is using. One
work-around is to set hostname on the client to the IP address being
used.

I know the right thing to do is set the hostname and the DNS name
lookup the
same, but I have a customer who doesn't want to do this. They didn't
have to
for 2003, and they don't want to for 2005. Sigh. Is there a way to
disable
this feature?

[Back to original message]