Issues that are encountered during SQL Server database installation

Before the SQL Server 2008R database was used because of the project requirements, after the installation is complete, you will encounter some problems when you log in

The problem is:

When you connect locally, localhost,. etc. cannot log in directly, you must add the instance name, such as Localhost\express,. \express

Remote connection when the IP address plus instance name, such as 192.168.1.90\express cannot log in, the direct IP address can be

Later, during the discovery of the database installation, a named instance was selected

The difference between choosing a default instance and a named instance is as follows:

(Source: Http://www.cnblogs.com/xwdreamer)

1. The difference of service name in service:

• Default instance: MSSQLSERVER;
• Named instance: the real column name is: Benet, the name in the service is: mssql$benet;

Note: If you have more than one instance, multiple service names will appear in the service, and one instance corresponds to a service.

2. The difference between connection strings connected to a query parser or profiler:

• The default instance can be used: "." (points), "(local)", "Computer name"
• Instance Name: Computer Name: Pcname, instance Name: Benet, the name used when connecting is: Pcname\benet

3. Port Difference

• Default instance: 1433
• Named instances: 1434

Issues that are encountered during SQL Server database installation