Mombu the Microsoft Forum sponsored links

Go Back   Mombu the Microsoft Forum > Microsoft > SQL SERVER (TECHNET) > name instance versus default instance
User Name
Password
REGISTER NOW! Mark Forums Read

sponsored links


Reply
 
1 2nd August 13:22
phil
External User
 
Posts: 1
Default name instance versus default instance


Hi,

I'm starting with sql server 2005 express and i want to know what is an
instance, what's the use of it and what's the difference between a name
instance and a default instance.

I installed it and can see as name: myserver\sqlexpress. Is this the default
one or a named.
Thanks
Phil
  Reply With Quote


  sponsored links


2 2nd August 13:23
jens
External User
 
Posts: 1
Default name instance versus default instance


This is the "default" named instance of SQLExpress :-). SQLEXPRESS is
the reserved instance name for SQLEXPRESS. Default instance dront have
the instanceName part after the \ sign.

HTH, Jens Suessmeyer.

---
http://www.sqlserver2005.de
---
  Reply With Quote
3 2nd August 13:28
roger woltermsft
External User
 
Posts: 1
Default name instance versus default instance


An instance is basically a copy of SQL Server executing on your machine.
There are many reasons why you would want to have more then one copy of SQL
Server. For example you might want to run SQL Server 2005 and SQL Server
2000 on the same machine for development or testing. Before SQL Server
supported instances, there could be only one copy of SQL Server running on a
machine and that copy didn't have a name. To remain compatible with those
older versions, you can have one instance without a name. This is what is
called the default instance. You can refer to the default instance by just
giving the name of the server. All the other instances must be named and
for a named instance you refer to it with servername\instancename. SQL
Express installs with a name of SQLEXPRESS so you refer to it as
servername\SQLEXPRESS or .\SQLEXPRESS if you are running on the same machine
as SQL Express.

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
  Reply With Quote
4 2nd August 13:28
phil
External User
 
Posts: 1
Default name instance versus default instance


Thanks
  Reply With Quote
5 23rd March 04:58
phil
External User
 
Posts: 1
Default name instance versus default instance


Hi,

I'm starting with sql server 2005 express and i want to know what is an
instance, what's the use of it and what's the difference between a name
instance and a default instance.

I installed it and can see as name: myserver\sqlexpress. Is this the default
one or a named.
Thanks
Phil
  Reply With Quote
6 23rd March 04:58
jens
External User
 
Posts: 1
Default name instance versus default instance


This is the "default" named instance of SQLExpress :-). SQLEXPRESS is
the reserved instance name for SQLEXPRESS. Default instance dront have
the instanceName part after the \ sign.

HTH, Jens Suessmeyer.

---
http://www.sqlserver2005.de
---
  Reply With Quote
7 24th March 15:20
roger wolter[msft]
External User
 
Posts: 1
Default name instance versus default instance


An instance is basically a copy of SQL Server executing on your machine.
There are many reasons why you would want to have more then one copy of SQL
Server. For example you might want to run SQL Server 2005 and SQL Server
2000 on the same machine for development or testing. Before SQL Server
supported instances, there could be only one copy of SQL Server running on a
machine and that copy didn't have a name. To remain compatible with those
older versions, you can have one instance without a name. This is what is
called the default instance. You can refer to the default instance by just
giving the name of the server. All the other instances must be named and
for a named instance you refer to it with servername\instancename. SQL
Express installs with a name of SQLEXPRESS so you refer to it as
servername\SQLEXPRESS or .\SQLEXPRESS if you are running on the same machine
as SQL Express.

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
  Reply With Quote
8 24th March 15:20
phil
External User
 
Posts: 1
Default name instance versus default instance


Thanks
  Reply With Quote


  sponsored links


Reply


Thread Tools
Display Modes




Copyright 2006 SmartyDevil.com - Dies Mies Jeschet Boenedoesef Douvema Enitemaus -
666