5/11/2023 0 Comments Tcpview exe![]() Write-output "No services found using that port" $tcpConn = Get-NetTCPConnection | Where-Object | Select-Object Id, ProcessName To repro this scenario, I stopped SQL Server and ran a PowerShell script through PowerShell_ISE that listens on tcp/1433. You can quickly check which process is using the port by runningĮxamples of each method are listed below. In the case above, that would be tcp/1433. First, the most obvious situation, is another Service or Application running on the server that uses the same TCP port as the SQL Server. There are a two situations that will cause this error message. You know there were no services using your port before the maintenance, so what's going on here and how do you find out who is using SQL's port? 22:41:20.58 spidxxs Server TCP provider failed to listen on. ![]() We rebooted and now SQL won't start"! You dig into the error logs and see something like this: ![]() It's 3 AM on a Saturday morning and you receive that dreaded phone call – "The SQL Server just had maintenance. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |