Skip to main content

Posts

Showing posts from February, 2018

SQL SERVER 2016 Enabling TCP 1433 and UDP 1434 on Windows Firewall

ENABLING  UDP 1434  : From the start menu, type wf.msc. Click Windows Firewall with Advanced Security. Inbound Rules > Right click > New Rule... Rule Type: What type of rule would you like to create? - Port Next > Protocol and Ports: Does this rule apply to TCP or UDP? - UDP Does this rule apply to all local ports or specific local ports? - Specific local ports: 1434 Next > Action: What action should be taken when a connection matches the specified conditons? - Allow the connection Next > Profile: Next > Name: SQL Server 2016 UDP 1434 Description (optional) : SQL Server 2016 UDP 1434 Finish!!! ENABLING    TCP 1433  : From the start menu, type wf.msc. Click Windows Firewall with Advanced Security. Inbound Rules > Right click > New Rule... Rule Type: What type of rule would you like to create? - Port Next > Protocol and Ports: Does this rule apply to TCP or UDP? - TCP Does this rule apply to all local ports or specific local ports? - Specific loc

BizTalk Creating Data and Envelope schema for Debatching

NEW NOTES: - Creating Debatching schemas: Env -- Create new schema with this naming convension "YourPreDefineName" + "Env.xsd" -- Select top most node "<Schema>" -- Properties > Advanced > Imports > click (Collection) -- Click Add... -- Select the equivalent DATA schema => "YourPreDefineName" + "Data.xsd" and click OK -- On Imports popup window click OK -- Properties > Reference > Envelop > Yes -- Select next node +Root -- Properties > Reference > Parse > Body  XPath > ... -- Body XPath popup window > Select SELF > click OK - Add child record -- Properties > General > Data Structure Type > Select DATA schema OLD NOTES: Debatching: - Create Data schema - Create Env schema > Name root as its filename > Select <Schema> * Advanced > Imports : select the Data Schema * Reference > Envelope : Yes - Select Root Record Env * Parse > Body XPath > select self - A

Biztalk is failing on LIVE server with different Regional Settings

Resolution: //Culture settings: using System.Globalization; using System.Threading; namespace Baliw.PetiksHours.Customs {     public class PetiksHourDatToXmlStructure : IPetiksHourDatToXml     {         public VirtualStream PetiksHourTextFileToXml(Stream textFile)         {             Thread.CurrentThread.CurrentCulture = new CultureInfo("en-US");