Issue Description
user's topology: clinet pc---switch---router---swtich---server
When the client accesses the server, http service is normal, but SQL server service is abnormal.
Handling Process
On the router deny 1433 ACL is configured. So SQL service cannot be used. Delete ACL and the service recovers.
Root Cause
Anable ACL on the router and the matching relation of ACL and windows is as follows:
135=Location Service
137=NETBIOS Name Service
138=NETBIOS Datagram Service
139=NETBIOS Session Service
445=Microsoft-DS
593=Unassigned IPC Server
1023=Reserved
1025=Reserved
1068=Installation Bootstrap Proto. Cli.
1433=Microsoft-SQL-Server
1434=Microsoft-SQL-Monitor
2784=world wide web-development
Suggestions
If one service is abnormal and other service is normal, configrm the problem according to matching relation of ACL and windows.