Posted by John Bell on 12/29/06 09:22

Hi Mark

It is not clear what exactly the problem is here. Is the problem that you
have renamed the server without changing the instance name? In which case
you need to drop the server and re-create it as described in
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_afterinstall_5r8f.asp

John

"Mark Delaney" <drsparc@gmail.com> wrote in message
news:1167352406.739648.91440@s34g2000cwa.googlegroups.com...
> 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]