SQL name different from server name

• beath

  SSCrazy

  Points: 2939

  More actions

  November 3, 2003 at 7:52 am

  #58869

  We have a server with a SQL name registered in EM of SERVERA

  In the sysservers table it has a srvname and srvnetname of SERVERB

  In the error logs it comes up with:

  Using 'SSMSRP70.DLL' version '7.0.961' to listen on 'SERVERB'.

  Does this mean my physical server is called SERVERB and SQL server is called SERVERA? If so will this cause any major issues in the future? Also why am I able to ping SERVERA and get a reply?

  I have no physical access to the box to check the setup.

  cheers

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  November 3, 2003 at 8:02 am

  #480651

  It could be server alias added by using client network utility from the machine EM is running.

  Run sp_helpserver to verify server name. It should be 'SERVERB'.

• beath

  SSCrazy

  Points: 2939

  More actions

  November 3, 2003 at 8:21 am

  #480661

  Thanks, it was a server alias.