• river1 (7/11/2014)


    Hi,

    I have created an alias named Kal on my SQL server 2005 server. I have inserted the right port number on it.

    If I connect from 32 bits machines I have sucess but if I connect from 64 bits machines I can not do it.

    The server is SQL Server 2005 32 bits

    Thank you for the support

    When you are creating aliases using SQL Server Configuration Manager, you have the option to create aliases that are used by 32-bit clients separately from aliases used by 64 bit clients. You should see "SQL Native Client 10.0 (32bit)" and "SQL Native Client 10.0" (different version number for SQL 2005 should be shown).

    You will need to create an alias for both 32-bit and also for 64-bit clients if you are using both in your application