Introduction Today I was working on moving my ADFS environment to a separate VM so I could test out a deployment guide I had been working on. On my VM1 I had installed ADFS with Windows Internal Database (WID) in a standalone mode. In my target VM2 I had installed ADFS on SQL 2008 R1 […]
Blog Post by: clineer
Your WCF-SQL adapter is not comming up after you have installed it in BizTalk?
You installed the WCF LOB Adapter SDK? From the ASDK folder on the installation cd.
You Installed the adapter Pack? From the AdapterPack folder on the installation cd.
You did this: http://soa-thoughts.blogspot.com/2010/08/wcf-sql-adapter-table-operations.html
Which version did you install?x86, x64, were they both x86, or x64 ?
Still not comming up… What version of BizTalk did you install? x86 or x64?
If you installed x86, then you need to install x86 version of both of these, and then…. Go to the BizTalk Administration Console, Platform Settings, Under Adapters, right click and say new adapter…
See this again: http://soa-thoughts.blogspot.com/2010/08/wcf-sql-adapter-table-operations.html
Do you NOW see WCF-SQL adapter there ??
If in doubt install x86…. Handy Hint….
Your WCF-SQL adapter is not comming up after you have installed it in BizTalk?
You installed the WCF LOB Adapter SDK? From the ASDK folder on the installation cd.
You Installed the adapter Pack? From the AdapterPack folder on the installation cd.
You did this: http://soa-thoughts.blogspot.com/2010/08/wcf-sql-adapter-table-operations.html
Which version did you install?x86, x64, were they both x86, or x64 ?
Still not comming up… What version of BizTalk did you install? x86 or x64?
If you installed x86, then you need to install x86 version of both of these, and then…. Go to the BizTalk Administration Console, Platform Settings, Under Adapters, right click and say new adapter…
See this again: http://soa-thoughts.blogspot.com/2010/08/wcf-sql-adapter-table-operations.html
Do you NOW see WCF-SQL adapter there ??
If in doubt install x86…. Handy Hint….
This week I have the honor of speaking at VSLive in Las Vegas . This morning I presented a session about building RESTful services in the Microsoft platform. The session covered the existing options such as WCF, WCF Data Services, ASP.NET MVC and the…(read more)
Blog Post by: gsusx
This week I have the honor of speaking at VSLive in Las Vegas . This morning I presented a session about building RESTful services in the Microsoft platform. The session covered the existing options such as WCF, WCF Data Services, ASP.NET MVC and the…(read more)
Blog Post by: gsusx
In Part 1 I began my investigation of an example infection of the infamous Stuxnet worm with the Sysinternals tools. I used Process Explorer , Autoruns and VMMap for a post-infection survey of the system. Autoruns quickly revealed the heart of Stuxnet…(read more)
Blog Post by: Mark Russinovich
In the past I wrote an article about BizTalk Server, all logos over time, now while searching on the web, I came across with a funny curiosity: BizTalk codenames! Microsoft codenames are the names given by Microsoft to products it was in development, before given the names by which they appeared on store shelves. Unfortunately […]
Blog Post by: Sandro Pereira
Last week I sat down to prepare a demo for an ’application infrastructure’ workshop I’m running next week in which I wanted to demonstrate exposing a BizTalk WCF receive location accessed through the Windows Azure AppFabric Service Bus. Granted – with the BizTalk Server 2010 Feature Pack released last October – this is merely a case of running the Publish WCF Service Wizard, but I thought it
In our previous posts we’ve set up our Domain controller. This post will focus on prepping our other Servers which will be used and include: BizTalk Failover Servers SQL Server Failover Servers File Server This posts will assume that you’ve… Read more ›
Blog Post by: Ren%u00e9 Brauwers
In our previous posts we’ve set up our Domain controller. This post will focus on prepping our other Servers which will be used and include:
This posts will assume that you’ve already pre-installed 5 servers with Windows Server 2008R2, named your servers, assigned Fixed IP’s and hooked them up to your Domain.
Please be aware; this is a long blog-post; read it carefully and I recommend to follow the steps in the order as mentioned.
Your File Server will fulfill a crucial part when setting up both your SQL and BizTalk Failover clusters as both of them require available storage which is to be used as:
Once you’ve booted up your File Server and logged on to your domain, open up your Server Manager and ‘Right Click’ on Features and select ‘Add Features’.
A wizard will start and once you’re on the ‘Select Features’ screen, select the ‘Storage Manager for SAN’s feature and press next
On the ‘Confirmation Screen’ select ‘Install’.
Verify the installation results and click ‘Close’
Boot up one of your Servers (which will be used for SQL) and login with the domain admin account, open up your Server Manager and ‘Right Click’ on Features and select ‘Add Features’.
A wizard will start and once you’re on the ‘Select Features’ screen, select the ‘Failover Clustering’ feature and press ‘next’
On the ‘Confirmation Screen’ select ‘Install’.
Verify the installation results and click ‘Close’
Repeat the above mentioned steps for your second server which will be used for sql.
Boot up one of your Servers (which will be used for BizTalk) and login with the domain admin account.
open up your Server Manager and ‘Right Click’ on Roles and select ‘Add Roles’.
A wizard will start and once you’re on the ‘Select Server Roles’ screen, select the following Role ‘Application Server’. A message will appear informing you that some additional features are required. Select ‘Add Required Features’
Press ‘Next’ until you reach the ‘Select Role Services’ screen in order to add the ‘Application Server’ Role and the required Features
On the ‘Select Role Services’ Screen, select the ‘Web Server (IIS) Support’. A message will appear informing you that some additional features and/or role services are required. Select ‘Add Required Role Service’
Once done, ensure to select the the following Role Services as well:
While selecting the Role Service ‘Message Queuing Activation’ a message will appear informing you that some additional features are required. Select ‘Add Required Features’
Continue with selecting the following Role Services:
You should now have all Role Services selected, press ‘next’
You will asked to Choose a Server Authentication Certificate for SSL Encryption. Select the option “Choose a certificate for SSL encryption later’ and press ‘next
Now proceed until you reach the ‘Role Services’ Screen and check that all Role Services are checked with exception off the following:
Press next, and conform the Installation Selections and then press Install
Check the results and click on Close
Please note the following instructions (copied from : http://technet.microsoft.com/en-us/library/cc730960.aspx)
Setting Permissions in Active Directory Domain Services Before Installing the Routing Service or the Directory Service Integration Features of Message Queuing
The successful installation of the Routing Service feature on a Windows Server 2008 R2 computer that is not a domain controller, or the Directory Service Integration feature of Message Queuing on a Windows Server 2008 R2 computer that is a domain controller requires that specific permissions are set in Active Directory Domain Services. Follow these steps to grant the appropriate permissions in Active Directory Domain Services before installing these features.
To grant permissions for a computer object to the Servers object in Active Directory Domain Services before installing the Routing Service feature on a computer that is not a domain controller
- Click Start, point to Programs, point to Administrative Tools, and then click Active Directory Sites and Services to open Active Directory Sites and Services.
- Click to expand Active Directory Sites and Services, click to expand Sites, and then click to expand the site which this computer will be a member of.
- Right-click Servers and select Properties to display the Servers Properties dialog box.
- Click the Security tab of the Servers Properties dialog box.
- Click the Add button to display the Select Users, Computer, or Groups dialog box.
- Click the Object Types button to display the Object Types dialog box, click to enable Computers, and then click OK.
- Enter the name of the computer for which the Routing Service or Directory Service Integration feature will be installed, click Check Names, and then click OK.
- Enable the following permissions for this computer object:
- Allow Read
- Allow Write
- Allow Create all child objects
- After enabling these permissions, click Advanced to display the Advanced Security Settings for Servers dialog box.
- Select the computer object from the list of permission entries, and then click the Edit button.
- Select Thisobject and all descendant objects from the Apply to drop-down list, and then click OK.
- Click OK to close the Advanced Security Settings for Servers dialog box.
- Click OK to close the Server Properties dialog box.
open up your Server Manager and ‘Right Click’ on Features and select ‘Add Features’.
A wizard will start and once you’re on the ‘Select Features screen, expand the ‘Message Queuing’ Feature and ensure to select the all options with exception of:
Select ‘Next’ and confirm the Installation Selections. Once done press ‘Install’
Verify the Installation Results and then press ‘Close’
open up your Server Manager and ‘Right Click’ on Features and select ‘Add Features’.
A wizard will start and once you’re on the ‘Select Features’ screen, select the ‘Failover Clustering’ feature and select ‘Next’
Confirm the option and select ‘Install’
Verify the Installation Results and then press ‘Close’
Repeat the above mentioned steps for your second server which will be used for BizTalk.
At this point we will have prepped our File Server and all of of our BizTalk and SQL Servers, but we are not quite there yet.
As we are running our servers in a Virtual Environment and we don’t have dedicated storage servers we will need to ‘emulate’ this. In order to do this I’ve decided to use the iSCSI Target software which is part of the Windows Server 2008 Storage Server.
Please note that this is not part of the Windows Server 2008 .iso, you will actually need to download it from MSDN (http://msdn.microsoft.com/en-us/subscriptions/downloads/default.aspx)
Once you’ve downloaded the required iso, mount it using your favorite tool. Once you’ve mounted it you will see a self-extracting file named WSS2008R2+ISCSITarget33.exe
Click on it and within the destination folder you will find 2 iso files, one of them called iSCSI_Software_Target_33.iso .
Hook this iSCSI_Software_Target_33 iso file up to your Virtual Machines. There are several ways to do this. Below a description on how I did this for my File Server.
Open up your Hyper-V manager, right click on your File Server and select ‘Settings’
Go to your DVD-Drive and within the media Group box select ‘image file’ and browse to the above mentioned iSCSI_Software_Target_33.iso
At this point you’ve mounted the iSCSI_Software_Target_33.iso to your server and now we can go back to our server and access the contents.
From your File Server, browse to your DVD-Drive and open up the Index.htm file
This step only needs to be done on your File Server, and thus can be skipped for the 2 SQL Server Machines and 2 BizTalk Server Machines
On the welcome screen; press ‘Next’
Accept the End-User License Agreement
Choose a destination folder, and select ‘next’
Choose if you would like to join the Customer Experience Improvement Program
Choose if you want to use Microsoft Update
Install the iSCSI Software target
Finish the installation
Below mentioned steps, need to be executed on all servers with exception of your Domain Server.
Open the index.htm file once again and now select the VSS,VDS and HPC Hardware Providers (x64) link
On the welcome screen; press ‘Next’
Accept the End-User License Agreement
Choose ‘Typical installation’
Provide a domain user account and enter the according password
Choose if you want to use Microsoft Update
Install the Software Client Software
Finish the installation
Now log on to one of your SQL Machines, and go to start and type ‘iscsi initiator’ in the search box and hit enter.
You will be presented with a message stating that the iSCSI service is not running and you will be presented with the option to automatically start this service. Select ‘Yes’
At this point you will be presented with the iSCSI Initiator Properties screen.
Now go to the Configuration Tab, and make a note of the ‘Initiator Name’ (Write it down or even better Copy and Paste it into notepad, as we will use it later on)
Repeat the above mentioned steps for the other SQL Machine and both BizTalk Machines, eventually you should have made written down 4 Initiator names which should be something similar to the entries mentioned below
At this point we will have the required software installed on all of our servers and now it’s time to define some storage which will be made available to our BizTalk and SQL Server Machines.
In order to do this we will have to go back to our File Server; so go ahead and do this.
Once logged on. Go to the Server Manager, select Storage , expand Microsoft iSCSI Software Target and select devices and under actions select Create Virtual Disk
The Create Virtual Disk Wizard will now appear. Select ‘Next’
Now enter the path and Filename of the Virtual Disk you want to create. We will start of with creating a disk which will be used as our main database storage disk
Add the desired size
Add a description
Skip the “Access” part for now and select ‘Next’
Now complete the Wizard and once done select the ‘Finish’ button
Repeat the above mentioned steps for the following virtual disks
Eventually you should have a total of 8 virtual disks
Now that we have created all of our virtual disks, it is time to create a dedicated BizTalk and SQL iSCSI Target and assign the designated disks to them.
In order to do this go to the Server Manager, select Storage , expand Microsoft iSCSI Software Target, select iSCSI Targets and right click and select ‘Create iSCSI Target’
The ‘Create iSCSI Target Wizard’ will pop up, select ‘Next’
Now we will have to enter the iSCSI Target Identification information. We will start with creating an Target for the BizTalk Failover Cluster. For the iSCSI Target Name enter ‘BIZTALK’ and for the description we’ll enter ‘BIZTALK TARGET’. Once done press ‘Next’
At this point in time you will be presented with the iSCSI Initiators Identifiers screen; in this screen we will be entering our previously written down initiator names; in my case the were:
Click on Advanced and then select ‘Add’
For Machine bts001 use the below mentioned information. Once done press ‘OK’
For Machine bts002 use the below mentioned information. Once done press ‘OK’ . Please note you will get a warning, but this warning can be ignored as we want to allow multiple initiators as we are setting up a cluster
Eventually you should end up with the following 2 entries:
Select ‘OK’ and then select ‘NEXT’ and then ‘FINISH’
Repeat the above mentioned steps however this time you will be creating a Target for your SQL Machines. Below the information as I have used
TARGET NAME: SQL2008
TARGET DESCRIPTION: SQL SERVER 2008 TARGET
IQN IDENTIFIERS USED:
At this point we have defined our two targets, namely BIZTALK and SQL2008 and we’ve created our Virtual Storage Disks. The next step is to actually assign the Virtual Storage to the correct iSCSI target.
Open up Server Manager on your File Server. Select Storage , expand Microsoft iSCSI Software Target, select iSCSI Targets, Select the BizTalk target and right click it and select ‘Add Existing Virtual Disk to iSCSI Target’
Select all Virtual Disks which indicate that they are to be used by BizTalk and select OK. ( In my case I’ve named the Virtual disks in such a way that I can easily recognize which disks are to be used within the BizTalk Cluster as I used the term BTS)
Open up Server Manager on your File Server. Select Storage , expand Microsoft iSCSI Software Target, select iSCSI Targets, Select the SQL2008 target and right click it and select ‘Add Existing Virtual Disk to iSCSI Target’
Select all Virtual Disks which indicate that they are to be used by SQL Server and select OK. ( In my case I’ve named the Virtual disks in such a way that I can easily recognize which disks are to be used within the SQL Cluster as I used the term SQL)
Now that we’ve created our designated Targets and assigned the designated Virtual disks to the target we need to configure the SQL and BizTalk machines such that they have access to these virtual disks.
In order to do this, log on to one of your SQL Machines open up the iSCSI Client. This is done by clicking on ‘Start’ and typing ‘iscsi initiator’ in the search box. Now hit ‘enter’.
You are now presented with the iSCSI Initiator properties screen. Go to the ‘Discovery’ tab and select the “Discover Portal… button”
Now enter the IP Address or the DNS name of your File Server; in my case this would be the EUROPOORT, and select ‘OK’
You should now see your portal in the Target Portals Group Box.
Now select the “Targets” Tab, and you should see a Discovered Target IQN which is inactive.
Select the discovered Target and click on the Connect button
A popup box will appear, just click on “OK”
At this point your first SQL Machine is connected to its dedicated SQL2008 Target
Press OK, and repeat the above mentioned steps for the other SQL Machine and the other BizTalk machines.
Well it has been a long read (and not to forget quite a long write ) but this sums up part 4. So far we’ve accomplished the fundamental preparations required in order for us to proceed with the actual installment and configuration of the BizTalk and SQL Cluster.
So what to expect in the near future; well part 5 will cover setting up the SQL Cluster which includes
part 6 will cover setting up the BizTalk cluster which includes
I actually hope to finish up these series this month, but I can’t make a promise as I have a few exams to prepare including 70-595 (BTS 2010) and 70-432 (SQL Server 2008)
Well I hope you enjoyed the posts so far, check back soon and feel free to leave any comments, remarks and/or suggestions with regards to Blog posts you would like to see in the future.
Cheers
René