Post reply

Create an alias of sql server

  • November 6, 2012 at 2:51 pm

    #284385

    In SQL server 2008 R2 configuration manager, I would like to setup alias of the server.

    This is for use a transportation software interface, they first chose a server name then connect to the database. We want to use alias for the servername.

    My question is at configuration manager window there is a 32 bit native client configuration, the other is 64 bits. The SQL server box is a 64 bits.

    Which should we use to add the alias, 32 bits or 64 bits, what it refer to, the client or the sql server itself?

    Thanks

  • November 7, 2012 at 1:48 am

    #1556667

    The alias needs to be created on the clients.

  • November 7, 2012 at 8:55 am

    #1556828

    Thanks, but my question is where shall I configure alias, in 32 bits or 64 bits client?

  • November 7, 2012 at 8:59 am

    #1556833

    Depends on your application, if it runs in 32bit mode, then 32 bit, if it runs 64bit then 64bit.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply