Advantages of SQL Server 2005 named instance?

The installation of SQL Server 2005 (Express) has an option
for default instance or named instance (SQLExpress as default)
What are the advantages of setting up named instance and default instance?
Thanks for answering...
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200608/1"pedestrian via SQLMonster.com" <u16758@.uwe> wrote in
news:64c9478703e41@.uwe:
> The installation of SQL Server 2005 (Express) has an option
> for default instance or named instance (SQLExpress as default)
> What are the advantages of setting up named instance and default
> instance? Thanks for answering...
There can only be one default instance, but multipe named instances with
different names. Advantage of the default instance is that you (or the
user) do not have to remember an instance name.
One of the major reasons for using multiple instances will be complete
separation of database solutions. Each instance has it's own service, and
thus you can set memory constraints per instance. Furthermore, remember
that logins are defined in the master database, so logins are only
available within that instance, which can be a good security measure.
--
Ole Kristian Bangås
MCT, MCDBA, MCDST, MCSE:Security, MCSE:Messaging, MCTS, MCITP|||Thanks for replying... I'm currently using SQL Server 2005 Express...
I have set up with Named Instance = SQLExpress, that is, the default name.
So, does that mean I can still set up another copy of Express server
using Default Instance?
Ole Kristian Bangås wrote:
>> The installation of SQL Server 2005 (Express) has an option
>> for default instance or named instance (SQLExpress as default)
>> What are the advantages of setting up named instance and default
>> instance? Thanks for answering...
>There can only be one default instance, but multipe named instances with
>different names. Advantage of the default instance is that you (or the
>user) do not have to remember an instance name.
>One of the major reasons for using multiple instances will be complete
>separation of database solutions. Each instance has it's own service, and
>thus you can set memory constraints per instance. Furthermore, remember
>that logins are defined in the master database, so logins are only
>available within that instance, which can be a good security measure.
>
--
Pedestrian, Penang.
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200608/1|||> So, does that mean I can still set up another copy of Express server
> using Default Instance?
Yes. There can be one default instance on a machine and a number of named instances (each need a
unique name, of course). Installation order doesn't matter (excluding prior versions of SQL
Server/MSDE).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"pedestrian via SQLMonster.com" <u16758@.uwe> wrote in message news:64d4235358c63@.uwe...
> Thanks for replying... I'm currently using SQL Server 2005 Express...
> I have set up with Named Instance = SQLExpress, that is, the default name.
> So, does that mean I can still set up another copy of Express server
> using Default Instance?
> Ole Kristian Bangås wrote:
>> The installation of SQL Server 2005 (Express) has an option
>> for default instance or named instance (SQLExpress as default)
>> What are the advantages of setting up named instance and default
>> instance? Thanks for answering...
>>There can only be one default instance, but multipe named instances with
>>different names. Advantage of the default instance is that you (or the
>>user) do not have to remember an instance name.
>>One of the major reasons for using multiple instances will be complete
>>separation of database solutions. Each instance has it's own service, and
>>thus you can set memory constraints per instance. Furthermore, remember
>>that logins are defined in the master database, so logins are only
>>available within that instance, which can be a good security measure.
> --
> Pedestrian, Penang.
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200608/1
>|||I haven't tried to install two SQL Server 2005 Express instances on the
same computer, but since multiple applications may install their instance
of MSDE I cannot see any reason why this should not work.
"pedestrian via SQLMonster.com" <u16758@.uwe> wrote in
news:64d4235358c63@.uwe:
> Thanks for replying... I'm currently using SQL Server 2005 Express...
> I have set up with Named Instance = SQLExpress, that is, the default
> name.
> So, does that mean I can still set up another copy of Express server
> using Default Instance?
--
Ole Kristian Bangås
MCT, MCDBA, MCDST, MCSE:Security, MCSE:Messaging, MCTS, MCITP|||Thanks to Tibor and Ole... I shall try it out.
--
Pedestrian, Penang.
Message posted via http://www.sqlmonster.com