I inherited a system that reads a SQL data base through a IIS web service.
I have no information about it but I have admin access.

  1. How can I find what port is being used? (It's not obvious on netstat)
  2. Where are the logs that tell me what when that port is being used?

I have verified the link from IIS to SQL Server. Now I need to be sure that my antivirus isn't blocking.

  • Do you have admin access to the IIS server, the SQL server, or both? If SQL, you can look at the logs. On a typical installation, they'll be in something like %ProgramFiles%\Microsoft SQL Server\MSSQL10.MSSQLServer\MSSQL\LOG\ERRORLOG. Look for a line like Server is listening on [ 'any' <ipv4> 57876]. In that example case, SQL is listening on port 57876. – Doug Deden Jan 24 at 23:30

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.