Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Alias OK, IP not

질문 Alias OK, IP not

  • Monday, December 11, 2006 4:44 PM
     
     
    Sign In to Vote
    0

    Hi all,

     

    I was able to get my mirroring setup to work only when I use Alias instead of IP address.  Any idea why it is so?

     

    Thanks,

    Avi

     

All Replies

  • Tuesday, December 12, 2006 7:15 PM
     
     
    Sign In to Vote
    0

    I am trying to set up using IPS, someone told me you can as long as u do not use a witness server.

    I am having trouble setting it up. What did you do to get it working? when you say Alias, what do you mean ( can u walk me using your steps ).

     

    Thanks

     
  • Wednesday, December 13, 2006 11:12 AM
     
     
    Sign In to Vote
    0

     

    Alias is basically associating a name to an IP address for that you use

    MS SQL 2005-> Configuration tools ->SQL Server Configuration Manager

    Once you set up an alias you can use it instead of the IP.  However, my problem was that with an alias my scripts works well but with IP it does not.

     

    Any ideas?

    Avi

     
  • Monday, December 18, 2006 2:34 PM
     
     
    Sign In to Vote
    0

    Might be a problem with WINS  in this case, have you checked with your Network admin in this case.

    Ensure both the servers has similar version of tools in this case.