What is a default instance?
What is a default instance?
Rating:
When a user installs SQL Server 2005 on a computer for the first time, Setup displays a page to install SQL Server 2005 as the default instance. The user cannot specify a name for the default instance during installation. The default instance does not require the user to specify the name of the instance to establish a connection. If any of the previous versions of SQL Server is installed on the computer, the user can install SQL Server 2005 as a named instance without installing the default instance first. In this case, the default instance will be the previous version of SQL Server, and the named instance will be SQL Server 2005. Only one instance of SQL Server 2005 or any version of SQL Server can be the default instance at any one time.
Rating:
Other articles
- What is a partition function?
- What are articles?
- What is CSV?
- What are user-defined functions?
- What is a parameterized T-SQL query?