Post reply

SQL name different from server name

  • 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

  • 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'.

  • November 3, 2003 at 8:21 am

    #480661

    Thanks, it was a server alias.

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

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