笔记15-徐 SQL启动过程的网络连接

 1 --SQL启动过程的网络连接
 2 
 3 --A self-generated certificate was successfully loaded for encryption.
 4 --2012-09-09 10:37:18.45 服务器         Server is listening on [ 'any' <ipv6> 1433].
 5 --2012-09-09 10:37:18.45 服务器         Server is listening on [ 'any' <ipv4> 1433].
 6 --2012-09-09 10:37:18.45 服务器         Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ].
 7 --2012-09-09 10:37:18.45 服务器         Server named pipe provider is ready to accept connection on [ \\.\pipe\sql\query ].
 8 --2012-09-09 10:37:18.45 服务器         Server is listening on [ ::1 <ipv6> 1434].
 9 --2012-09-09 10:37:18.46 服务器         Server is listening on [ 127.0.0.1 <ipv4> 1434].
10 --2012-09-09 10:37:18.46 服务器         Dedicated admin connection support was established for listening locally on port 1434.
11 --2012-09-09 10:37:18.46 服务器         The SQL Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b, state: 3. Failure to register an SPN may cause integrated authentication to fall back to NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies.
12 --2012-09-09 10:37:18.46 服务器         SQL Server is now ready for client connections. This is an informational message; no user action is required.
13 
14 --侦听服务器上所有IP地址的1433端口
15 --2012-09-09 10:37:18.45 服务器         Server is listening on [ 'any' <ipv4> 1433].
16 
17 --共享内存是专供本地连接通过LPC技术向SQL做的连接。由于它不走网络层，所以是速度最快的连接方式
18 --共享内存的启动信息如下
19 -- Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ].
20 
21 
22 --命名管道如下
23 --Server named pipe provider is ready to accept connection on [ \\.\pipe\sql\query ].
24 
25 
26 --专用管理员连接功能DAC
27 --供SQL服务响应出问题，无法与服务器建立普通连接时使用。
28 --Server is listening on [ 127.0.0.1 <ipv4> 1434].
29 --Dedicated admin connection support was established for listening locally on port 1434.
30 
31 --如果端口被占用会报错，如下
32 --服务器     supersocket info :bind  failed on tcp port 1433
33 
34 
35 
36 
37 --SQL用启动帐户，向域控制器里注册一个SPN，以便让SQL使用Kerberos做Windows认证。如果注册失败，会在errorlog里看到以下这句话
38 --The SQL Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b, state: 3. Failure to register an SPN may cause integrated authentication to fall back to NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies.
39 
40 --SQL将所有要启动的协议都尝试加载过一遍以后，errorlog里会报告以下信息，标志网络协议这一步结束
41 -- SQL Server is now ready for client connections. This is an informational message; no user action is required.
42 
43 
44 --如果某个协议不能被成功加载，SQL会报出错误信息，但是一般情况下不会影响SQL的正常启动。受影响的只是
45 --出问题的那个协议功能。
46 
47 --SSL的配置除外