After we have created the database folder, we need to do the pre-action content to enable SQL Server named Pipes, TCP/IP, and configure TCP/IP information. By default, SQL Server Named Pipes, TCP/IP is not enabled after the SQL Express version is installed, including SQL Server Browser service is not enabled by default, this service involves subsequent Named Pipes errors, After the article will have the error introduction, start our configuration operation, after the configuration is completed remember to do verify that the configuration is valid, the most effective way is to check that the corresponding port is working (Telnet port authentication).
1. Open the SQL Server Configuration Manager console:
650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/72/BD/wKioL1XsZKrhr9_vAAEV1_wufDk173.jpg "/>
2. Navigate to protocols for ADK bar, the right window shows named Pipes, TCP/IP is disabled status:
650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/72/C1/wKiom1XsYoTxYpZLAAEZ7CIV9oE030.jpg "/>
3. Double-click named Pipes, TCP/IP, and enable:
650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/72/BD/wKioL1XsZK7RuLWcAAETvzCdaqE676.jpg "/>
650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/72/C1/wKiom1XsYomTatPtAAFXrHLQhxQ802.jpg "/>
650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/72/BD/wKioL1XsZLTx4TQXAAFxsqTTEPc390.jpg "/>
When enabled, it appears as follows:
650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/72/C1/wKiom1XsYo_g4W-lAAEDSSnmED4421.jpg "/>
4. Configure TCP/IP properties port to 1433:
650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/72/BD/wKioL1XsZLnyq3PmAAGDjdGGLS4643.jpg "/>
5, and set the Ipall option in TCP Port 1433:
650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/72/C1/wKiom1XsYpWA-CZ8AAGTQyL6M7A520.jpg "/>
6, Telnet native 1433 port authentication, can also be tested on the client:
650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/72/BD/wKioL1XsZL6RzwTMAAC7h5_WX08686.jpg "/>
About MDT SQL Configuration verification operation is basically completed, the production environment must remember to check the actual startup state, before many engineers in the environment that the state is false cause subsequent operations can not continue, only for everyone to learn the reference, if there is insufficient welcome to point out, thank you!
This article from "Heard" blog, declined reprint!
MDT 2013 from getting started to mastering SQL configuration and Validation