What is a sqlserver instance
This article will explain in detail what is an example of sqlserver, the content of the article is of high quality, so the editor will share it with you for reference. I hope you will have a certain understanding of the relevant knowledge after reading this article.
Sqlserver instance refers to the sql server engine. Each database engine instance has a system or user database that is not shared by other instances. Instances are divided into default instances and named instances, and there is at most one default instance on a computer.
SQL instance
The so-called SQL instance is actually the SQL server engine. Each SQL Server database engine instance has a set of system and user databases that are not shared by other instances.
Multiple SQL SERVER can be installed on a computer, and each SQL SERVER can be understood as an instance.
Instances are divided into "default instances" and "named instances". If the first SQLSERVER is installed on a computer and the naming settings remain default, then this instance is the default instance.
There can be at most one default instance on a computer, or there can be no default instance, and the default instance name is the same as the computer name. The computer name can be modified, but it has no effect on the default instance, that is, the default instance changes with the change of the computer name.
So, the name of the default instance is the same as the computer name, not "local", but in general, if you want to access the default SQL server instance on this machine, use the computer name, (local), localhost, 127.0.0.1,. , native IP address, can achieve the same purpose. However, if you want to access a non-native SQL server, you must use the computer / instance name method.
How to check the number of sql instances
(1) Select run from the start menu, enter services.msc, and enter enter
(2) in the list of services, there are several instances that start with MSSQLSERVER.
This is the end of the sharing of sqlserver examples. I hope the above content can be helpful to you and learn more. If you think the article is good, you can share it for more people to see.
