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.
| Author |
Topic |
|
scottd
Starting Member
11 Posts |
 Posted - 2008-03-25 : 09:59:34
|
| Can someone explain what "named instances" means with regard to SQL?Is this one Physical Server With multiple installs of SQL SERVER and / or databases ?We have a list at my small comapy with "raw sql 2000 database instances". Can someone help out, I'm getting conflicting info!Thanks,Scott M |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-03-25 : 14:55:11
|
| There are two types of instances: default and named. Default will be either the ServerName or VirtualServerName, whereas named will be ServerName\InstanceName or VirtualServerName\InstanceName. Yes it is one physical server but you don't have to have multiple instances installed to have a named instance.I don't know what "raw" means in your list.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-03-25 : 16:40:27
|
| If you were to connect to a named instance , you would connect such as "MYSERVERNAME\MYINSTANCENAME" , you can have multiple ones of these. Which all have there separate folders, executables etcJack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
|
|
|
|
SQl Server and Instances