Tuesday 14 July 2015

Executed as user: NT SERVICE\SQLSERVERAGENT. Server '' is not configured for RPC. [SQLSTATE 42000] (Error 7411). The step failed.

Dear all, 

While running SQLSERVERAGENT we get this error. 

For my case I used below query and my problem was solved.

Please run below query:

EXEC master.dbo.sp_serveroption @server=N'<Server Name>', @optname=N'rpc', @optvalue=N'true' 
exec sp_serveroption @server='<Server Name>', @optname='rpc out', @optvalue='true'


Thank you.

Thursday 9 July 2015

Prerequisite Skills and Knowledge for developer of BizTalk solutions

Prerequisites for Developers

A developer of BizTalk solutions must be at least moderately experienced with the use of
  • Microsoft Visual Studio 2013 and the development of .NET solutions
  • Programming with the .NET Framework
  • Extensible Markup Language (XML)
  • Extensible Stylesheet Language Transformations (XSLT)
  • XML Schema Definition Language (XSD)
  • Web Service use and development

Prerequisites for IT Professionals

The following table shows the areas of proficiency expected for a system administrator or IT professional.



An IT Pro responsible for the deployment of BizTalk solutions must be at least moderately experienced with the use of the following:
  • Microsoft Windows Installer (MSI)
  • Windows Server 2008 SP2 or Windows Server 2008 R2
  • SQL Server
  • Windows SharePoint Services
  • Performance monitoring and optimization techniques
  • Back and restore concepts and techniques
  • Internet Information Services (IIS) if exposing orchestration as Web or WCF services.

Source Taken From: https://msdn.microsoft.com/en-us/library/aa577674.aspx