SQL2005 Learning (37), installing multiple instances

Tag: blank target style title

Install multiple instances, install an instance, run the next SQL installation again, and then install the second instance

The default instance can only have one, in fact the default instance name is: MSSQLSERVER

650) this.width=650; "title=" image "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; margin:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" image "src=" http://img1.51cto.com/attachment/201409/28/2754337_ 1411888843cjjp.png "" 624 "height=" 462 "/>

Connect the default instance to access the database using the computer name

650) this.width=650; "title=" image "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; margin:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" image "src=" http://img1.51cto.com/attachment/201409/28/2754337_ 1411888844vyje.png "" 624 "height=" 493 "/>

Named instances can have multiple, such as we can create an instance of SCCM, which is important when the SCCM installation needs to modify the collation.

650) this.width=650; "title=" image "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; margin:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" image "src=" http://img1.51cto.com/attachment/201409/28/2754337_ 1411888844qxpi.png "" 488 "height=" 444 "/>

Connect a named instance to use: computer name \ Instance name, such as I have another instance of Lync installed

650) this.width=650; "title=" image "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; margin:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" image "src=" http://img1.51cto.com/attachment/201409/28/2754337_ 141188884506fs.png "" 624 "height=" 480 "/>

For example, the SQL service for Lync

650) this.width=650; "title=" image "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0px; margin:0px; border-left:0px; padding-right:0px "border=" 0 "alt=" image "src=" http://img1.51cto.com/attachment/201409/28/2754337_ 14118888469f2v.png "" 624 "height=" 462 "/>

Summary: Sometimes we install a default instance of SQL, and then we want to install SCCM, because the default instance installs without modifying the collation, then we can install another SCCM instance and modify the collation for the SCCM instance. Sometimes we have a SQL for two companies to provide services, then we can install two instances, these two instances corresponding to the SA password is not the same, and two companies do not affect each other (that is, one instance service stops and does not affect the service of another instance), The password for the two SA does not guarantee the security of the respective company database.

SQL2005 Learning (37), installing multiple instances