SQL Server Performance

Default SQL Server Intance Name

Discussion in 'General DBA Questions' started by boxtxod, Mar 20, 2011.

  1. boxtxod New Member

    Hello,what is the default instance name in sqlserver 2000?and are these details below correct? SQL Server 2005 Express - " SQLEXPRESS"SQL Server 2005 Enterprise - "MSSQLSERVER"SQL Server 2008 Express - "SQLEXPRESS"SQL Server 2008 Enterprise - "MSSQLSERVER"thanks.Regards,
  2. Luis Martin Moderator

    The default instance name is the server name in any sql version.
    MSSQLSERVER is the service name.
  3. satya Moderator

    As Luis suggested the default instance name means the machine name where the SQL services are installed. Also by default you can have only 1 default instance installed at any time on a machine.

Share This Page