1。Windows无法启动SQL server 代理服务(位于本地计算机上)错误1067:进程意外终止
解决方案:
将关联的sql server(实例) 服务停止。
然后启动sql server代理 服务。
2.JDBC连接SQL服务器
The TCP/IP connection to the host localhost, port 1433 has failed
解决方案:
通过Sql Server配置管理器(SSCM)
启动后,重新启动SQL SERVER 服务
通过sp_readerrorlog来查看sql server监听的协议以及端口
在SSMS中输入sp_readerrorlog命令来查看sql server信息,回到到如下类似的监听信息:
--tcp协议
Server is listening on [ 'any' <ipv6> 1500].
Server is listening on [ 'any' <ipv4> 1500].
Server is listening on [ 'any' <ipv6> 1433].
Server is listening on [ 'any' <ipv4> 1433].
Server is listening on [ ::1 <ipv6> 1434].
Server is listening on [ 127.0.0.1 <ipv4> 1434].
--named pipe协议无法关闭,即使关闭以后也会有local connection provider
Server local connection provider is ready to accept connection on [ \\.\pipe\sql\query ].
--share memory
Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ].
Server is listening on [ 'any' <ipv6> 1500].
Server is listening on [ 'any' <ipv4> 1500].
Server is listening on [ 'any' <ipv6> 1433].
Server is listening on [ 'any' <ipv4> 1433].
Server is listening on [ ::1 <ipv6> 1434].
Server is listening on [ 127.0.0.1 <ipv4> 1434].
--named pipe协议无法关闭,即使关闭以后也会有local connection provider
Server local connection provider is ready to accept connection on [ \\.\pipe\sql\query ].
--share memory
Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ].
这是在关闭named pipe的情况下,如果开启named pipe的话,那么会是如下类型:
--开启named pipe Server named pipe provider is ready to accept connection on [ \\.\pipe\sql\query ].
注:在sql server是无法关闭本地named pipe协议的。