Review any messages, above the information message is ‘ To configure WS-Atomic Transactions, run the wsatconfig.exe utility in C:\Windows\Microsoft.Net\Framework64\v3.0\Windows Communication Foundation when a certificate is available.’ This adds a tab on the MS-DTC to allow you to configure NOTE: Since this is a production build, Visual Studio 2008 SP1 is not required, only .NET 3.5 SP1 and .NET 3.0 SQL Server 2008 64-bit Install SQL Server 2008 64-bit Click the ‘Installation’ link Click on ‘New SQL Server stand-alone installation or add features to an existing installation’ link Ignore, this will be fixed by SP1, click ‘Run program’ You want all check boxes, click ‘OK’ product key and click ‘Next’ Accept the terms and click ‘Next’ Click ‘Install’
Review the settings and click ‘Next’ You should see a message that the configuration was successful, click ‘Finish’ Next, we need to create a web application under the ‘SharePoint Central Administration’ tool. First add the SharePoint Central Administration web site to your ‘Trusted Sites’ in Internet Explorer, otherwise the pages will not function correctly on Windows 2008. the ‘Application Management’ link and then click ‘Create or extend Web application’ Click ‘Create a new Web application’ Select ‘Default Web Site’, ‘Restart IIS Manually’, ‘Network Service’, ‘Windows authentication’, rename the Database Name to something more recognizable if you want, then click ‘OK’ You should see a message ‘Application Created’, next click ‘Start’, click ‘Run’, type ‘cmd’, click ‘OK’, then type; iisreset /noforce Under the ‘Web Application List’ in SharePoint Central Administration you should see the ‘Default Web Site’ and ‘SharePoint Central Administration v3’ in the list Close the SharePoint Central Administration tool, configuration is complete
Click ‘Start’, ‘All Programs’, SQL Server 2008’, ‘Configuration Tools’, then click ‘SQL Server Configuration Manager’, under ‘SQL Server Network Configuration’, click ‘Protocols for MSSQLSERVER’, verify that both TCP/IP and Named Pipes are enabled. From memory, I think that ‘TCP/IP’ is not enabled by default. Next, click on ‘SQL Services’ in the left-hand pane, right-click ‘SQL Server (MSSQMSERVER)’, and click ‘Stop’, then ‘Start’, for the settings to take effect Close the ‘SQL Server Configuration Manager’ Enable DTC on the Local Host Server BizTalk requires the Microsoft Distributed Transaction Coordinator (MS DTC) to be enabled Configure MSDTC on BizTalk and SQL Servers: Click ‘Start’, ‘Run’, type ‘dcomcnfg’, and hit the ‘Enter’ key Under ‘Component Services’, ‘My Computer’, right-click ‘Local DTC’ and select ‘Properties’, click the ‘Security’ tab. Ensure that the ‘Network DTC Access’, ‘Allow Inbound’, ‘Allow Outbound’, and ‘No Authentication Required’ options are selected and all others are cleared. ‘OK’ Click ‘Yes’ Click ‘OK’ and close the ‘Component Services’ Next, ensure that Windows Firewall has the ‘Distributed Transaction Coordinator’ listed on the ‘Exceptions’ tab ‘OK’ Restart the Distributed Transaction Coordinator from ‘Administrative Tools’, ‘Services’, right-click ‘COM+ System Application’ and select ‘Restart’. Close the window, now you’re ready for the BizTalk installation.