Archive for April, 2010

Download Microsoft SQL Server 2008 R2

SQL Server 2008 R2 includes new and enhanced capabilities for application and multi-server management, complex event processing, master data services, and end user reporting. Download now and gain access to technical resources.


Read Full Post »

Server Error in ‘/’ Application.

Cannot open database “<Database Name>” requested by the login. The login failed.

Login failed for user ‘IIS APPPOOL\DefaultAppPool’.

Hi everyone I hope you are doing fine and as you can see I am in good mood too. Staring off the day with some cool greetings from IIS. The other I a discovered Microsoft SEO Toolkit and analyzed my client’s website at www.SquareCircuit.com. The results were really helpful and I started fixing them one by one and decided that I will execute it locally for instant results when I got yellow carpet reception by IIS 7 via IE 8.

However the fix proved to be an easy one (I glad to say that as they usually eat up one half or more). The new IIS uses the ‘Application Pool Identity’ as shown below:

IIS Application Pools

IIS Application Pools

Before discussing the solution I would like to explain the why part. IIS 7 uses a default account in this ‘IIS_APPPOOL\DefaultAppPool’ and this account is not added to SQL Server. This can be verified using SQL Server Management Studio in the Secutiry > Logins.

Now the solution is pretty obvious
a) You enter the IIS Default Pool account in the SQL Server Logins.
b) Change the identity of the default application pool (recommended).

Changing Application Pools Identity

Changing Application Pools Identity

Hope this helps.

Read Full Post »

I found these helpful posts on the subject.

Using ASP.Net with Facebook’s Graph API and OAuth 2.0 Authentication

New Facebook Connect in C#

Read Full Post »

Introducing Microsoft SQL Server 2008 R2 Language: English | ISBN: NA | PDF | 216 pages | 7.6Mb Introducing Microsoft SQL Server 2008 R2 Language: English | ISBN: NA | PDF | 216 pages | 7.6

Read Full Post »

This book will teach all about Windows Server AppFabric (code-named “Dublin”),a set of extensions to Windows Server that allow it to function as a lightweight, application server. The combination of Windows Server and AppFabric provides an easy-to-manage platform for developing, deploying, and reliably hosting middle-tier WCF/WF services.

Windows Server AppFabric fills an important vacuum left in the wake of COM and COM+’s demise as the .NET platform has risen to prominence. Provided as an extension to Internet Information Services (IIS), the built-in application server frees you from having to create your own Windows services to perform application hosting. Instead, you can take advantage of plumbing and infrastructure that Ms provides for you, freeing you to focus on just your business logic while still being able to deploy n-tier solutions on Windows Server. In this way, Windows Server AppFabric solves the problem of developing, deploying, and reliably hosting middle-tier WCF/WF services.

With thanks to Zia Khan

Read Full Post »

nopCommerce is the best open source eCommerce and shopping cart solution out there. There are some other popular choices but I have found this to be a very neatly managed offering. Recently the nopCommerce team have released v1.5 which contains a very cool set of features.    

If you choose to go for nopCommerce please make sure that you have enough room available in your database. I faced a terrible situation during the times when one of my clients had their site hosted on GoDaddy and one day they complained that they cannot add images anymore. The reason I found out that since nopCommerce (I was working with v1.3) was storing all the images in the database as ‘Binary’ and GoDaddy only allows database a maximum size of 200 MB (what a joke!). That was the time when I started looking for a new hosting as well how fix this issue. Luckily I got both. My client got rid of GoDaddy and switched to ThePlanet and I rewrote the PictureManager.    

In general I am happy with this product but there certain things I don’t admire:    

1. Images are stored in file system as well as the database which makes it unfeasible for small projects. I would suggest that they include a feature ‘Hosted Images’ so that the owner can choose between self or third-party hosting. 2. The product is tied to Microsoft SQL Server again minus point for small setup. You can find countless request on the internet and their forums requesting for a MySQL version but there is no official support. In my estimation this could be a single exploding feature for the ASP.NET community if they had supported multiple databases or the leading databases such as MySQL, SqlLite, Oracle etc. My suggestion to the team is to go for a ORM like Hibernate, Entity Framework, TopLink etc which will release the pressure of maintaining multiple layers of Data Access code.   

You can try out the latest version in their demo store here:    

Demo Store Front

Demo Store Administration

Demo Store Administration


While these were the unlikes the ones I admire are just too many. I highly the quality of code which is highly modularized and layered.   

 I have a thorough working of nopCommerce on multiple versions. Following are my contributions:   

  • Integration with eBay implementing two way inventory synchcronization.
  • PayPal Standard customer address issue.
  • Anonymus user automatic registration when doing transactions with PayPal.
  • Implemented a new version of PictureManager which does not store images inside the database.
  • Added professional looking Invoice for single and multiple orders.


I would ge glad to help anyone working on this great product. 

Read Full Post »

Visual Studio 2010 and .NET 4 Released

The final release of Visual Studio 2010 and .NET 4 is now available

Download and Install Today

You can download free 90-day trial editions of Visual Studio 2010 here. You can also download and use the free Visual Studio express editions of Visual Web Developer 2010, Visual Basic 2010, Visual C# 2010 and Visual C++.  These express editions are available completely for free (and never time out).

What’s new with VS 2010 and .NET 4

Following are some of new features part of this release:  

1. Visual Studio 2010 IDE 

  • Multiple monitors
  • New code intellisense support
  • Code navigation support
  • HTML and JavaScript snippet support
  • Javascript Intellisense
  • Enriched Debugger and Profiler
  • Enahced Multi-targeting support 

2. Language Features (VB and C#)

  • Automatic properties, collection initializers, and implicit line continuation support (VB)
  • Optional parameters and named arguments (C#)
  • New dynamic keyword (C#)
  • Co-variance and Contra-variance (C#) 
  • And many more

WPF 4 and Silverlight 4
SharePoint and Azure
Data Access
WCF and Workflow
CLR and Core .NET Library Improvements
.NET 4 Client Profile
Visual C++

I will be posting more on VS 2010 in my upcoming blogs. You can find a more details about the launch here (Thanks to ScottGu).

Read Full Post »