O'Reilly logo

Microsoft® SQL Server™ 2000 Programming by Example by Carlos Eduardo Rojas, Fernando G. Guerrero

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Installing SQL Server Instances

A SQL Server instance is a completely independent installation of the SQL Server engine and its related services, such as SQL Agent. There are two types of SQL Server instances: default and named. A default instance is identified by the name of the server where it runs, whereas named instances are identified by the server name and the instance name (servername\instancename). There can be just one default instance running in a server, and it works exactly as previous versions of SQL Server. Regarding named instances, you can install as many named instances as you want in a specific server, even if there isn't a default instance installed. However, Microsoft supports only a maximum of 16 named instances per machine. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required