Enterprise Single Sign-On Service not getting started on BizTalk 2006 R2

PROBLEM DESCRIPTION After installing the .NET framework 4.0, I wasn’t able to start the Enterprise Single SignOn service for BizTalk 2006 R2. The ENTSSO services were failing with the following error message: Event Type:    ErrorEvent Source:    Service Control ManagerEvent Category:    NoneEvent ID:    7023Description:The Enterprise Single Sign-On Service service terminated with the following error: %%2148734720 SOLUTIONThis…


Getting error "The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine"

PROBLEM DESCRIPTION:   While I was trying to connect to an Access Database from Visual Studio 2010 on my Windows 7 x64 server, I got the following error message,   Server Error in ‘/myCalendar’ Application. The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine. Description: An unhandled exception occurred during the execution of the…


Did you know? How to connect to Microsoft Access database from a .NET 4.0 application

Goal: To write a SQL command that will connect to the Microsoft Access 2010 database in Visual Studio 2010.   Solution: This can be achieved using the connection string as follows,   OleDbConnection connection = new OleDbConnection(“Provider=Microsoft.ACE.OLEDB.12.0; Data source=D:\\Database\\myDatabase.accdb; Persist Security Info = False”);   I hope this helps.


Did you know? To use the SQL select command based on a value selected from a dropdown list

Background: I was looking for a requirement where I needed to use the SQL SELECT command based on a user’s input. In my case, it was a selection made from a DropDownList. This select command will be further used to populate a GridView. The HTML code is as follows, <asp:DropDownList ID=” DropDownList1“ runat=”server”> <asp:ListItem Selected=”True”>Select…


Breaking Changes in Visual Studio 2010

Visual Studio 2010 was released by Microsoft yesterday (12th April 2010). VS 2010 promises a lot of new features. More details of the new features are present in the following articles, What’s New in the .NET Framework 4 http://msdn.microsoft.com/en-us/library/ms171868(VS.100).aspx What’s New in Visual Studio 2010 http://msdn.microsoft.com/en-us/library/bb386063(VS.100).aspx What’s New in Visual C# 2010 http://msdn.microsoft.com/en-us/library/bb383815(v=VS.100).aspx  Security Changes…


Visual Studio IDE hung while switching from Source View to Design View

PROBLEM DESCRIPTION: While switching between the design view and the source view in Visual Studio, it was observed that the switching takes around 2-3 minutes to complete. During this while, the IDE was in a hung state. RESEARCH: 1.    We suggested the customer to use DebugDiag and collect a hang dump. 2.    I used the…


Getting error "IIS is not installed or is disabled" during SQL Reporting Services installation

PROBLEM DESCRIPTION: One of my customers was trying to install SQL Reporting Services and noticed that he was not able to complete the installation. The IIS feature was disabled during the installation, and it was giving the following error message, Unable to complete installation as IIS is not installed or is disabled.   FINDINGS: –         …


Unable to connect to Remote Desktop Web Connection (TSWeb)

PROBLEM DESCRIPTION: My customer was facing issue while installing the Remote Desktop Web Connection ActiveX control on Windows XP SP2. TROUBLESHOOTING DONE: –      He was using Windows XP SP2 and had installed the Remote Desktop Web Connection : XPSP2 [5,1,2600,2180] fromhttp://www.microsoft.com/downloads/details.aspx?FamilyID=469eee3a-45b4-4b40-b695-b678646a728b&displaylang=en –      But we somehow weren’t able to run the TSWeb even after we followed…


IE prompting for authentication on Windows 2008 machine due to the DEP feature

PROBLEM DESCRIPTION: One of my customers observed that IE 8 is prompting for authentication every time he accesses his aspx page. He is using Single Sign On which takes the credentials of the currently logged in user and logs the application under this context. The issue is observed only on the Windows 2008 machine which…


ASP.NET 2.0 web application crashes with Fatal Execution Engine Error (80131506)

My customer is repeatedly seeing the following crash events in the event viewer while running the ASP.NET 2.0 web application on x64 bit machines. This application worked just fine on x32 bit machines.   Event Type:   Warning Event Source: W3SVC Event Category:       None Event ID:       1011 Description: A process serving application pool ‘ABC’ suffered a…