Named instance and default instance

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 Administration

Named instance and default instance

Author

Topic

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2009-11-02 : 15:55:40

Hi All,
when we go for Default instance, and when we choose the named instance? what are the advantages and disadvantages?

Arnav
Even you learn 1%, Learn it with 100% confidence.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-11-02 : 15:58:45

There are no advantages or disadvantages. They operate the same. The only thing you gain with named instances is the ability to add additional instances to a server. You can't do that if you only use default instances.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2009-11-02 : 23:18:59

Just so you don't misunderstand, if you install a default instance, you can still add named instances later.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources