Blog/Login.aspx problem after upgrading IIS 6.0 to IIS 7.0~7.5

Topics: Controls
Feb 26, 2013 at 9:35 PM
Hi BEguys,

My company recently migrated to a new web server so as IIS 6.0 to IIS 7.5.
We are using SQL Database setting for the BLOG, and everything works fine but BLOG part.

Http://../blog/login.aspx is working strange.
After I login as a Admin, nothing happens. But, I am able to see BLOG "Control Panel" link.

when I click "Add Entry" link, I got the Error below:
"Profile", "Users" links have similar errors like this.

"Control","Categories" and "Settings" are working fine.


Server Error in '/' Application.

Data is Null. This method or property cannot be called on Null values.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlTypes.SqlNullValueException: Data is Null. This method or property cannot be called on Null values.

Source Error:

Line 347: private void BindUsers()
Line 348: {
Line 349: foreach (MembershipUser user in Membership.GetAllUsers())
Line 350: {
Line 351: ddlAuthor.Items.Add(user.UserName);

Source File: c:\inetpub\wwwroot\\blog\admin\Pages\Add_entry.aspx.cs Line: 349

Stack Trace:

[SqlNullValueException: Data is Null. This method or property cannot be called on Null values.]
System.Data.SqlClient.SqlBuffer.get_String() +5271122
System.Data.SqlClient.SqlDataReader.GetString(Int32 i) +75
BlogEngine.Core.Providers.DbMembershipProvider.GetAllUsers(Int32 pageIndex, Int32 pageSize, Int32& totalRecords) in C:\Users\usuglatwala\Documents\Visual Studio 2008\WebSites\SDTimes3.0\BlogEngine.Core\Providers\DbMembershipProvider.cs:591
System.Web.Security.Membership.GetAllUsers(Int32 pageIndex, Int32 pageSize, Int32& totalRecords) +45
System.Web.Security.Membership.GetAllUsers() +26
admin_entry.BindUsers() in c:\inetpub\wwwroot\\blog\admin\Pages\Add_entry.aspx.cs:349
admin_entry.Page_Load(Object sender, EventArgs e) in c:\inetpub\wwwroot\\blog\admin\Pages\Add_entry.aspx.cs:35
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +51
System.Web.UI.Control.OnLoad(EventArgs e) +92
System.Web.UI.Control.LoadRecursive() +54
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +772

Do you have any idea???