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,

   boxtxod, Mar 20, 2011

   #2
2. Luis Martin Moderator

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

   Luis Martin, Mar 21, 2011

   #3
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.
   

   satya, Mar 22, 2011

   #4

Please click 'Forgot Your Password' to reset your password if this is your first time using the new forums.

Your name or email address:

Do you already have an account?

Forgot your password?

• No, create an account now.
• Yes, my password is:

Stay logged in