Vamsi Krishna

BizTalk,BAM, .NET and other stuff

  Home  |   Contact  |   Syndication    |   Login
  13 Posts | 4 Stories | 1 Comments | 1 Trackbacks




Post Categories

Vamsi Krishna

Monday, September 10, 2012 #

The future of BizTalk- 
The last TechEd Conference was a very important one from BizTalk perspective. Microsoft will continue innovating BizTalk and releasing BizTalk versions for “for next few years to come”. So, all the investments that clients have made so far will continue giving returns. 

Three flavors of BizTalk: 
  1. BizTalk On-Premise, 
  2. BizTalk as IaaS and 
  3. BizTalk as PaaS (Azure Service Bus).
Windows Azure IaaS and How It Works
Date: June 12, 2012
Speakers: Corey Sanders
This session covers the significant investments that Microsoft is making in our Windows Azure Infrastructure-as-a-Service (IaaS) solution and how it 

TechEd provided two sessions around BizTalk futures:

AZR 207: Application Integration Futures - The Road Map and What's Next on Windows Azure
AZR211: Building Integration Solutions Using Microsoft BizTalk On-Premises and on Windows Azure

Here is are some highlights from the two sessions at TechEd. Bala Sriram, Director of Development for BizTalk provided the introduction at the road map session and covered some key points around BizTalk:
More then 12,000 Customers 
79% of BizTalk users have already adopted BizTalk Server 2010 
BizTalk Server will be released for “years to come” after this release. I.e. There will be more releases of BizTalk after BizTalk 2010 R2. 
BizTalk 2010 R2 will be releasing 6 months after Windows 8 
New Azure (Cloud-based) BizTalk scenarios will be available in IaaS and PaaS 
BizTalk Server on-premises, IaaS, and PaaS are complimentary and designed to work together 
BizTalk Investments will be taken forward 

The second session was mainly around drilling in and demonstrating the up and coming capabilities in BizTalk Server on-premise, IaaS, and PaaS:

BizTalk IaaS: 
Users will be able to bring their own or choose from a Azure IaaS template to quickly provision BizTalk Server virtual machines (VHDs) 

BizTalk Server 2010 R2: 
Native adapter to connect to Azure Service Bus Queues, Topics and Relay. 
Native send port adapter for REST. Demonstrated this in connecting to Salesforce to get and update Salesforce information. 
ESB Toolkit will be incorporate are part of product and setup 
BizTalk PaaS: 
HTTP, FTP, Service Bus, LOB Application connectivity 
XML and Flat File processing 
Message properties 
Transformation, Archiving, Tracking 
Content based routing

Thursday, December 2, 2010 #

Issues Installating BizTalk on Windoes 2007

 If you get the following error: Installing BizTalk on the Windows 7 platform,

[5:02:36 PM Info SSOServerCfg] (ssoconfigobj2.cpp:5125) Returning error description: <Exception Message="Failed to connect to the SQL database 'SSODB' on SQL Server ''." Source="SSO" HelpID=""><Exception Message="(0x80131700)" Source="Win32" HelpID=""/></Exception>

1.     You can use the cmd prompt or the visual studio command prompt
2.     For command prompt use the following
3.    Using Command prompt
a.       C:\Program Files\Common Files\Enterprise Single Sign-On>C:\WINDOWS\Microsoft.NET \Framework\v2.0.50727\RegAsm.exe ssosql.dll
Microsoft (R) .NET Framework Assembly Registration Utility 2.0.50727.4927
Types registered successfully
4.      Using VS.NET
a.       C:\Program Files\Common Files\Enterprise Single Sign-On> regasm ssosql.dll

If the above approach still does not resolve the issue then follow either of these steps

1.       Enable TCP/IP and Named Pipes?
2.    Check the  account has proper rights with in the SQL Server

Tuesday, May 5, 2009 #

BizTalk Server 2006 Unable to determine whether or not specified user is an administrator.

You are attempting to install Windows SharePoint services adapter web service on a virtual server that has not been configured with Windows SharePoint Services

TITLE: Microsoft BizTalk Server 2006 Configuration Wizard
You are attempting to install Windows SharePoint Services Adapter Web Service on a virtual server that has not been configured with Windows SharePoint Services. Refer to the documentation for instructions on extending a virtual server. (CWssAdaCfg)


Solution: Make sure you run the Windows SharePoint Services Central Administration and Extend or upgrade virtual server, once its installed re-run the BizTalk configuration wizard, this time it should run smooth.

Tuesday, April 7, 2009 #

If you ever receive the following error,

"Error: btsdeploy is not recognized as an internal or external command"

Reason: This usually happens if the BizTalk server is not able to recognize the BTSDeploy.exe command, this can happen if you had recently installed the BizTalk server and have not restarted the machine.

Solution: restart the machine after successful BizTalk installation

Note: BTSDeploy is deprecated and has been replaced by BTSTask with the new release, but is included to support scripts that administrators have developed for previous versions of BizTalk Server.

Friday, November 2, 2007 #

Microsoft ESB Guidance: If you all are interested on Microsoft Enterprise Service Bus (ESB), then have to check this site

they have an excellent architecture guidance on ESB package for enabling Service-Oriented Architecture (SOA).

Target Audience for the Microsoft ESB Guidance

This guide is intended for developers who create BizTalk or other solutions that leverage the Microsoft ESB Guidance components. To take full advantage of the Microsoft ESB Guidance, developers should possess knowledge and experience in working with:

·         Microsoft BizTalk Server 2006

·         Microsoft Visual Studio 2005

·         Microsoft .NET development techniques, including the development of ASP.NET Web Services and .NET Framework components

The ESB Guidance package CTP3 uses features of BizTalk Server 2006 R2.

Files:  ESB CTP3
ESB CTP3 Source
uploaded Aug 6,2007

Friday, August 4, 2006 #

While configuring BizTalk 2004 on one Virtual machine (on windows 2003), and SQL Server is located remotely on another VM, I came across this kind of exception, which doesn’t give you much of information, except that the transaction has already been implicitly or explicitly committed or aborted, search on google doesn’t either give you any information, hence I have listed it over here,

Error: c:\depot4000\jupiter\source\private\mozart\source\setup\btscfg\btswmi.cpp(266): FAILED hr = c0c025b3

[7:30:26 PM Error BtsCfg] Failed to deploy BizTalk system assembly "C:\Program Files\Microsoft BizTalk Server 2004\Microsoft.BizTalk.GlobalPropertySchemas.dll".

Unspecified exception: The transaction has already been implicitly or explicitly committed or aborted.

[7:33:09 PM Info ConfigFramework] Showing MessageBox with text: Failed to deploy BizTalk system assembly "C:\Program Files\Microsoft BizTalk Server 2004\Microsoft.BizTalk.GlobalPropertySchemas.dll". Unspecified exception: The transaction has already been implicitly or explicitly committed or aborted.

Solution: The Solution is to provide the appropriate domain user accounts for BizTalk configuration wizard, the installer should have access to the SQL Server BizTalk databases. Initially I thought it might be some issue with the MSDTC network clients which were already enabled, how ever it is purely based on the domain accounts which were not yet been created on SQL Server and BizTalk machines..

Error: Config error: Failed to deploy Biztalk system assembly... DefaultPipelines.dll When running the config wizard for BizTalk2004 (on windows 2003) the following error occurred: Failed to deploy Biztalk system assembly "C:\Program Files\Microsoft BizTalk Server 2004\Microsoft.BizTalk.DefaultPipelines.dll". Unspecified exception: Unable to generate a temporary class (result=1). error CS2001: Source file 'C:\WINDOWS\TEMP\dbqvusoe.0.cs' could not be found. error CS2008: No inputs specified. Solution: The solution is to give the 'NETWORK SERVICE' user read and write access to the c:\windows\temp directory.

Tuesday, June 27, 2006 #

The BizTalk Server 2006 Installation and Upgrade Guides have been updated yesterday, you can find them out here:

Monday, May 22, 2006 #

I finally got a chance to take the certification last friday, and I PASSED, It wasnt easy, needs to have lot of development experience on BizTalk, It’s been in my mind since last year but due to the hectic schedule couldn’t make it,

FYI: This is now considered as a ‘Microsoft Certified Technology Specialist’ certification, note: this is not mentioned in the list of exams on the MCTS page (

Credential: ‘Microsoft Certified Technology Specialist’
Certification/Version: ‘BizTalk® Server 2004: Custom Applications’
Exam guide:

There is no skill assessment available for BizTalk 2004 certification, how ever if you are planning to go for the BizTalk 2006 then Microsoft has come up with Skills Assessment for Exam 70–235, you can take the assessment here, It contains around 30 –questions.

If you want some insight on the 74-135 certification,
Better have some strong development skill set on BizTalk 2004, there might be some lucky ones who might have passed, but in general I feel if you are strong in your development skills with BizTalk, then you would sail through easily, else spend time knowing the kind of errors BizTalk applications might throw and start debugging them,

Saturday, March 25, 2006 #

Since there is not enough information available on the sFTP adapters for BizTalk, thought would post this one, you can find the article here, sFTP adapters for BizTalk

This document is more focused on the BizTalk side rather than SSH, however I have provided some basic background information on SSH servers and clients using the RSA key based authentication in my previous post.


BizTalk 2004/2006 doesn’t have any built in support for sFTP adapters, they only support traditional FTP adapters, hence we are only left with two options, either we need to develop our own custom adapters for sFTP or purchase it from other clients, for more information read the article I had posted on the sFTP adapter.
RSA Public-Key based Authentication


Saturday, January 7, 2006 #

Find my previous postings on the following site


Thursday, March 23, 2006 #

Overview of SFTP, FTPS, SCP and FTP:

I am not going go in detail about sFTP or FTPS here, since my main motive is to integrate sFTP with BizTalk, hence if you need more information need to research by yourself


"sftp is an interactive file transfer program, similar to ftp, which performs all operations over an encrypted ssh transport".

SFTP is part of the OpenSSH standard. Along with SSH you have capabilities to use commands such as SCP, SFTP, etc. So....SFTP is very secure because each packet is encrypted and compressed while sending is taking place. It utilizes public key authentication and compression. The Abbreviation SFTP nowadays invariably means Secure File Transfer Protocol, however there is another protocol with the same abbreviation (Simple File Transfer Protocol). So lets not get confused.

Differences between FTP, SFTP and FTPS:

Why not just use FTP? Why should I use Secure FTP instead of FTP? Why is SFTP better than FTP? <!--[if !supportLineBreakNewLine]-->


FTP (File Transfer Protocol) does not take any precautions to protect information transmitted during a session. This includes your username, password, and any files transmitted.

SFTP (Secure File Transfer Protocol) is a secure replacement for FTP (File Transfer Protocol) based on the Secure Shell protocol. Unlike FTP, SFTP encrypts both commands and data providing effective protection against common network security risks. SSH Client and Server provide both command-line SFTP tools and a graphical user interface for Windows users. SFTP encrypts the session, preventing the casual detection of your username, password or anything you've transmitted.

The major reason for implementing SFTP versus FTP is security. FTP is not even remotely secure. During an FTP session, your username and password are transmitted in clear text. If someone is eavesdropping, it is not difficult for them to log your FTP username and password.

In FTP all data is passed back and forth between the client and server without the use of encryption. This makes it possible for an eavesdropper to listen in and retrieve your confidential information including login details. With SFTP all the data is encrypted before it is sent across the network.

SFTP is not the same as FTP/S; the latter implements the original FTP protocol through a separately-created secure tunnel.

FTPS (FTP-SSL) is a real ftp that uses TSL/SSL to encrypt the control session and if required the data session. With FTPS the control session is always encrypted, but the data session might not be. Why is this? Because with the control session encrypted the authentication is protected and you always want this (normal ftp uses clear text). If you are NOT pre-encrypting the file, you want the data session encrypted so that the file is encrypted while the data is in flight. However, if you are pre-encrypting the file then you do not need to have the data connection encrypted as you do not need to add the overhead of encrypting the data connection, since the file is already encrypted. Understand that SFTP is SSH file transfer and FTPS is FTP with SSL, FTPS is a file transport layer on top of SSL or TLS. The FTPS adds SSL-enabled FTP send and receive capabilities, uses the FTP protocol to transfer files to and from SSL-enabled FTP servers.

SCP (Secure Copy) is a non-interactive command-line tool for securely transmitting files from a machine to another. It is a secure replacement for RCP and provides a similar command-line syntax. SCP is strongly based on SFTP but is often a more suitable choice when setting up unattended file transfers using scripts.
SSH Servers

OpenSSH (

  1. OpenSSH is a free version of the SSH protocol suite. OpenSSH servers and clients are available for both Unix and Windows.
  2. OpenSSH has been ported to Windows with the popular CYGWIN utility. The project was created by Network Simplicity (
SSH2 (
  1. SSH2 is a commercial version of SSH, with required license fees for commercial use (noncommercial use is free). Commercial SSH clients/servers are available for both Windows and Unix systems.
List of SFTP Clients:

There are many client tools, you can use to connect to the SFTP servers, few of them I was interested were Core FTP LE, putty.exe, freeSSHd.exe, FileZilla_Server-0.9.12c.exe, Cygwin, WINSCP

Your choice of an SSH client is highly dependant on the type of functionality required for SSH. For example, if SSH is being deployed primarily for its file-transfer capabilities, We can go with Core FTP/WinSCP and SSH Communications' these SSH clients are probably good choices.

On the other hand, if SSH is being deployed for remote shell access via an HTTP proxy server, the SecureCRT and PuTTY clients are probably good choices.

Lastly, if SSH is being deployed for remote access from undefined and uncontrolled terminal locations, MindTerm is probably a good choice, since it offers SSH access with the need of only a Web browser.

Operating system support The operating systems the clients can run on.
















Protocol support:

Information about what internet protocols the clients support. External links lead to information about support in future versions of the clients or extensions that provide such functionality.










Saturday, January 7, 2006 #

You can also access this from my original blog,

I have created the list of problems or questions we might encounter with BAM, some of them are my own experiences and some I have gathered from different sources and bundled up in one forum,

This article explains some of the questions posted on the BAM, thought would be useful for everyone whose working on BAM, any comments are welcome:

Error 1:

While configuring the databases used by Windows SharePoint Services
, might receive the following error,
Line 1: Incorrect syntax near 'COLLATE'. (Error code: 170).

Solution: Provide the SQL Server Access rights to the BTSService, to do this go to security, logins and add the BTSService (User) which is member of administrator, and add to the all the server roles.

Error 2:

templatepick.aspx - page not found

When you create a new top level site under a parent site in sharepoint, it brings up the page saying it has been created successfully, when we click on the sites URL to specifiy the template it should display the default template selection wizard, but instead we might receive a page not found error.

Solution: If you want to delete the following sub site under sites, click on Documents and Lists, under Sites, delete the above site and recreate it, still problem occurs delete the root sites and recreate.

Error 3:

The "WSSLib" adapter is suspending an outbound message going to destination URL:"http://localhost/sites/SomeException/Exceptions". Details:"The request failed with HTTP status 404: Not Found.".

Solution: This means that you haven’t put the WSSWebServices.dll in to the C:\Program Files\Common Files\Microsoft Shared\web server extensions\60\ISAPI\BIN folder and WSSDocLibService.asmx in to the C:\Program Files\Common Files\Microsoft Shared\web server extensions\60\ISAPI folder, hence it was not able to find these files, so the following exception occurred.

Note: Kindly check your internal path using the IIS manager,WebSites/_vti_bin, right click and view the properties, capture the local path located under virtual directory tab you should be able to find the folder path location.

Error 4:



When ever we click on ‘Upgrade a server or virtual server’ in SharePoint site, we might get the annoying help file,



"To upgrade your server to Microsoft Windows SharePoint Services, run Setupsts.exe. Running Setupsts.exe upgrades your server and the default virtual server. If you have additional virtual servers to upgrade, you can upgrade each virtual server individually by using the upgrade operation with the Stsadm.exe command-line tool."



Solution: Prohibit the FrontPage from the IIS and remove it from add/remove program, then reset the IIS.
Try to open the site again and this time, You should see the following response, Virtual Server Successfully Extended, This would allow us to browse to the next level in the sites,
You can open the home page for your new Web site in your browser by using a link on the confirmation page. You can continue to extend other virtual servers or configure Self-Service Site Creation so users can create their own sites.



Error 5:



“1057 while trying to query service SPTimer."






Make sure you enter the user name as "domain\user name" or "machine name\user name;" otherwise, you get the following error: "System Error 1057 while trying to query service SPTimer,



Installing SharePoint:

To Install Install Windows SharePoint Services without installing MSDE,
basically need to do the following,
C:\Program Files\STS2Setup_1033>setupsts.exe remotesql=yes



for more info, Kindly go to the following sites