How I Found a SQL Injection Hacker

This is how I found a SQL Injection Hacker who was changing all the product titles in my custom shopping cart using a diabolical injection technique. First, I knew the problem was happening, because I saw HTML inserted into my product titles and product descriptions of my database and website. My application was written in […]

Two BTDF Mistakes SSOSettingsFileImport.exe and Cannot Enlist Orchestration

Error: SSOSettingsFileImport.exe /userGroupName:"BizTalk Application Users" /adminGroupName:"BizTalk Server Administrators" exited with code 1 Solution: In this case, you probably didn’t change the values of the SsoAppUserGroup and SsoAppAdminGroup in the default SettingsFileGenerator.xml, and your site has different user groups for SSO. Error: Could not enlist orchestration… Solution: This can happen when you forget to change the […]

Configuring Windows 2012 SMTP for CDONTS (Classic ASP)

I spent about three hours chasing down these errors Three Different Errors in my IIS Log When using Port: 80040213 The_transport_failed_to_connect_to_the_server. 8004020f [no text, just this code] When using Pickup Directory” 80040222 The_pickup_directory_path_is_required_and_was_not_specified So when reading other blogs, they often tell you to change from Pickup Directory to Port or vise versa. Context This code […]

Passing Custom WCF Soap Headers from BizTalk

How to Pass Custom WCF Soap Headers from BizTalk using WCF.OutboundCustomHeaders I needed to call a WCF webservice from BizTalk that required three SOAP fields. In addition to Username and Password (standard), they had one custom field called ApplicationID. Code in Message Assignment Shape xmlDocSoapHeader.LoadXml( "<headers>" + " <Username>" + strSOAPUserFromSSO + "</Username>" + " […]

BizTalk: Errors exist for one or more children

The error “Errors exist for one or more children” can often be tricky to uncover. Usually, when I get this error, I double click on it, and an orchestration shape will be slightly highlighted or bolder than normal, and it will have a red exclamation point on it. You then open it, look for a […]

Setting up GoDaddy to work with Amazon AWS EC2

Here are the steps I used to setup GoDaddy to use my Amazon EC2 Instance (running Windows 2012 with IIS). I first tested with an old domain that I was no longer using called Discount-Protein.com. First I created a new “Elastic IP Address” and assigned it to my EC2 Instance.  After setting it up, it […]

BizTalk AllowUnrecognizedMessage – Cannot Locate Document Specification

Error to Solve “Cannot locate document specification because multiple schemas matched the message type” as shown in context here: There was a failure executing the response(receive) pipeline: “Microsoft.BizTalk.DefaultPipelines.XMLReceive, Microsoft.BizTalk.DefaultPipelines, Version=3.0.1.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35” Source: “XML disassembler” Send Port: “sp_someWebServiceSendPortName” URI: “http://MyServer/MyDir/MyService.svc.svc?wsdl” Reason: Cannot locate document specification because multiple schemas matched the message type “http://tempuri.org/#SendMessageResponse”. One Possible […]

Error: IDENTITY_INSERT is already ON for table. Cannot perform SET operation for table

T-SQL Error IDENTITY_INSERT is already ON for table schema.SomeTableName. Cannot perform SET operation for table Table Name. Solution At any time, only one table in a session can have the IDENTITY_INSERT property set to ON.  So when you try to set it ON for another table, without turning if off for the first table, this […]

How do SSL and Basic Auth on an Orchestration Published as a WCF WebService

In the BizTalk world, the person who publishes the orchestration usually creates a small client program to call the webservice and to test it. This is a good practice before going to another developer (either in your company or to a customer) and telling them the service is “working” when you haven’t even tested it […]

IIS8 – The binding “*:80′ is assigned to another site

One of the errors I had to overcome with IIS version 8 was: “IIS8 – The binding “*:80′ is assigned to another site “. I’m upgrading from a Windows 2003 server that I’ve had since about 2007 to Windows 2012/R2 hosted on Amazon EC2 (Elastic Cloud). I only run three sites on it at this […]