sql server 服務

  • 186
  • 0

sql server 服務

1.sql server 服務

netstat 
netstat -na 
netstat -na | find "1433"


SSMS

SQL SERVER > 1433
SQL AGENT > JOB

SQL INTEGRATION SERVICE X <-

SQL REPORT SERVICE < X
SQL ANALYSIS < X

指令

netstat help

可顯示目前的網路狀態
netstat 

netstat -na 

 1.-a :顯示所有連線狀況 3.-n :顯示位址與port號碼

netstat -na | find "1433"
 將 netstat -na 全部搜尋到的,篩選出 PORT 是 1433 的
 

回覆狀態


CLOSED ---- Closed. The socket is not being used.
LISTEN ---- Listening for incoming connections.
SYN_SENT ---- Actively trying to establish connection.
SYN_RECEIVED ---- Initial synchronization of the connection under way.
ESTABLISHED ---- Connection has been established.
CLOSE_WAIT ---- Remote shut down; waiting for the socket to close.
FIN_WAIT_1 ---- Socket closed; shutting down connection.
CLOSING ---- Closed, then remote shutdown; awaiting acknowledgement.
LAST_ACK ---- Remote shut down, then closed ;awaiting acknowledgement.
FIN_WAIT_2 ---- Socket closed; waiting for shutdown from remote.
TIME_WAIT ---- Wait after close for remote shutdown retransmission.

Windows服務是指Windows NT作業系統中的一種執行在後台的電腦程式。

小小進階版~ ^口^

用這個去查出,誰偷偷躲在電腦裡面  =>

https://blog.xuite.net/sunnysoap/r/15847930-%E7%94%A8+netstat+%E6%AA%A2%E6%9F%A5+port%E6%9C%89%E7%84%A1%E7%95%B0%E5%B8%B8+%28%E6%98%AF%E8%AA%B0%E8%BA%B2%E5%9C%A8%E6%88%91%E7%9A%84%E9%9B%BB%E8%85%A6%E8%A3%A1%EF%BC%9F%29