Clustering - named vs default

• potucekj

  Default port

  Points: 1414

  More actions

  December 2, 2004 at 12:52 pm

  #87110

  I recently inherited a system that has sql server 2000 running in a two node active/passive Cluster.

  How can I tell if the one Instance that is running in this cluster is a named instance or a default instance?

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  December 2, 2004 at 1:15 pm

  #532287

  select @@SERVERNAME

  or

  From control panel --> service, you will see named instance server like MSSQL$ABC and default instance like MSSQLSERVER.