Related configurations for SQL Server2014

First, installation configuration

1. SQL Server version 2014 supports the following operating systems: Windows Server 2008, Windows Server R2, Windows Server 2012, Windows Server R2. The Standard Edition also supports Windows 7, Windows 8, and Windows 8.1 operating systems.

2. The. Net Framework 3.5 SP1 needs to be installed.

3. Installation Steps

Https://jingyan.baidu.com/article/3a2f7c2e653d5926afd61197.html

or Sina mailbox;

Second, remote connection configuration

1. Logon in Windows Authentication mode

2, right click on the server node, select "Properties", select "Security" page, Radio "SQL Server and Windows Authentication mode"

3, right click on "Security", "Login name", "sa", select "Properties", select "Status" page, on "login" Radio "Enable", in the "Allow connection to the database Engine" Radio "grant"

4. Select the General page and set the password

5. Open SQL Server Configuration Manager, select the "SQLExpress Protocol" node, right click on "TCP/IP", select "Enable"

6. Right click on "TCP/IP", select "Properties", press ENTER "TCP port" value in the dialog box

7. Restart the SQL Server service

8. Re-login to SQL Server with IP,

Attention:

If you do not have a TCP/IP port, you will be reported as an error at logon:

A network-related instance-specific error occurred while establishing a connection to SQL Server. The server was not found or could not be accessed. Verify that the instance name is correct, and that SQL Server is configured to allow remote connections.

(PROVIDER:TCP provider, error:0-Unable to connect because the target computer is actively rejecting.) ) (Microsoft SQL Server, error: 10061)

Related configurations for SQL Server2014