May 5, 2009 at 4:35 pm
Hi,
I am installing the SQL Server 2005 developer edition on my machine. Among the installation steps, I am being asked to select an instance name either default or a named instance. My sole aim to install developer edition is to practise both programming and administrative work.
Can naybody help me what shall I select and what is the difference between default and named instance
May 5, 2009 at 5:00 pm
For practicing programming and administration it's not going to make a great deal of difference whether you install a default or a named instance. Why not keep it simple and go with default?
SQL Server allows itself to be installed multiple times on the same server. Each one of these installations is comprised of a completely separate set of binaries.
Each one of these separate installations is called an instance. The instances have to be distinguishable from one another, hence they are named.
You can in fact have many instances on the same server, and these instances can be installed with different service pack levels or even versions of SQL Server - e.g. it's possible to have a SQL 2000 SP3, a SQL 2000 SP4, and a SQL 2005 SP2 instance all on the same box.
May 5, 2009 at 5:34 pm
Hi Andy,
Thanks for clarifying. So that means I can install a standard edition later as a named instance.
Thanks again for our reply.
May 6, 2009 at 2:20 am
Indeed, you could install a default instance of 2005 DEV now, then a named instance of 2005 Standard later, and then even a named instance of 2005 Enterprise after that if you were so inclined!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply