Client alias on 64bit server

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Adam Shepherd - 16 Aug 2005 17:55 GMT

We have just upgraded a 32bit server to 64bit Windows 2003, we had client
alias working correctly before when os was 32bit but now we have gone to
64bit i can't get any aliases to work.
I've tried configuring exactly the same alias on a 32bit machine and that
works but if the server is 64bit then no joy, even if try to create an alias
to the local 64but machine.
Any help would be gratefully appreciated.

Reply to this Message

Scott Wallace - 18 Aug 2005 23:49 GMT

Same problem here with XP 64. I've tried both 2000 and 2005 with the same
problem. It simply ignores the port and goes for 1433. Oddly enough, ODBC
worked (setting the port on the second screen).

> We have just upgraded a 32bit server to 64bit Windows 2003, we had client
> alias working correctly before when os was 32bit but now we have gone to
[quoted text clipped - 4 lines]
> to the local 64but machine.
> Any help would be gratefully appreciated.

Reply to this Message

Adam Shepherd - 19 Aug 2005 00:03 GMT

I've done a bit of playing around and i think what's happening is that the
alias is being written to the 32bit registry but sql server is trying to read
from the 64bit registry. If i create an entry in the 64bit registry then
alias works ok. The registry keys are:

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\MSSQLServer\Client\ConnectTo

and:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo

Looks like an issue with SQL Server, but if the key is in boht locations
then aliases work.

hope that helps,

Adam

> Same problem here with XP 64. I've tried both 2000 and 2005 with the same
> problem. It simply ignores the port and goes for 1433. Oddly enough, ODBC
[quoted text clipped - 8 lines]
> > to the local 64but machine.
> > Any help would be gratefully appreciated.

Reply to this Message