sql-server – 什么是命名和默认实例?

前端之家收集整理的这篇文章主要介绍了sql-server – 什么是命名和默认实例?前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。
什么是命名和默认实例?
他们之间有什么区别?
他们为什么被使用?

解决方法

According to Microsoft regarding named vs default

Client applications connect to an instance of Microsoft sql Server 2005
to work with a sql Server database.
Each sql Server instance is made up of
a distinct set of services that can
have unique settings. The directory
structure,registry structure,and
service name all reflect the specific
instance name you identify during
setup.

An instance is either the default,unnamed instance,or it is a named
instance. When sql Server 2005 is in
installed in the default instance,it
does not require a client to specify
the name of the instance to make a
connection. The client only has to
know the server name.

A named instance is identified by the network name of the computer plus
the instance name that you specify
during installation. The client must
specify both the server name and the
instance name when connecting.

By default,sql Server installs in the default instance unless you specify an instance name. sql Server Express,however,always installs in a named instance unless you force a default installation during setup.

猜你在找的MsSQL相关文章