Easy Way To Debug SSL Issues With Web Services (Including SQL Server 2005 SOAP Endpoints)

Here is a nice easy way to debug SSL issue with Windows 2003 that I discovered while working on SOAP projects.  I think this works on XP SP2 as well have not tested this. 1. Create batch file c:\ssltrace.cmd with following contents: logman start http_ssl_trace -pf c:\guids.txt -o out.etl -etspauselogman stop http_ssl_trace -etstracerpt /y out.etlnotepad dumpfile.csv…

1

Debugging SQL Connectivity 101

Note to self:  Things to remember to check next time I can’t connect to SQL… 1. Is SQL started?  Yes.  Is the instance I’m trying to connect to started?  Yes. 2. Run netstat -aon on sql box, do I see something bound to 1433 or say my instance port 5555?  For example do I see…

0