Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Instance Name

Author  Topic 

Danish kamran
Starting Member

4 Posts

Posted - 2008-12-23 : 04:41:20
Hello,

I'm new to SQL-server. After going through Installation tutorial, I found my concept and terminoligies unclear to me. One of them is Instant Name that comes in Installation process. I want to know what Instance Name is. As the Installation dialog give two option in Instance Name setting 1- Default Instance and 2- Named Instance I also want to know what they are and how Named Instance is to be set( i.e. what to write in text box next Named Instance Lable)

Looking for Kind reply.

Regards,

Danish Kamran

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2008-12-23 : 05:18:34
Default Instance is for first installation and it is the name of the machine where you install sql server.
Named Instance is the name for a further installation of sql server on the same machine.
Maybe machine is MyServer
Default Instance is: MyServer
Named Instance can be: MyServer\MyInstancename

So you can use more than one installation of sql server on the same machine.

Webfred


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page
   

- Advertisement -