Ping Kwan

IIS 6.0 : Web Farm Share Resources via UNC share

2011-11-21T09:51:00.000-08:00

1) Create a User Account (eg. "WebFarmUser") in UNC Share server and IIS Servers

2) Share the folder and set the permission (R and W) to the "WebFarmUser" account.

3) Assign "WebFarmUser" user account as the account running the App Pool in IIS Server.

4) Assign the web application to the App Pool

5) Create a virtual directory to the UNC shared folder.

6) if you still get the access denied issue, explicitly set the "Connect AS" of the virtual directory to use "WebFarmUser" account.

7)

ASP.NET 2.0 is configured to run with a user account.
The SerializeAs attribute of the Profile property in ASP.NET 2.0 is set to Xml

In this scenario, ASP.NET 2.0 may not save the user profile, and you may receive an error message that is similar to the following:

[InvalidOperationException: Unable to generate a temporary class (result=1).
error CS2001: Source file 'D:\WINDOWS\TEMP\d0lurtzx.0.cs' could not be found
error CS2008: No inputs specified

To resolve this issue, grant the user account the List Folder Contents and Read permissions on the %windir%\Temp folder.

IIS 6.0 Compression

2011-10-06T14:10:00.000-07:00

1) Backup the metabase. This is done by right-clicking on the server in the IIS snap-in and selecting All Tasks -> Backup/Restore Configuration.

2) Create Compression Folder (optional)

The first thing I do is create a folder on the D drive where the static file compression will be cached. You can call it anything you want or leave the default of “%windir%\IIS Temporary Compressed Files” if that works for you. The IUSR_{machinename} will need write permission to the folder. If you use custom anonymous users, make sure to assign the proper user. IIS will still work even if the permissions are wrong but the compression won't work properly. Once running, it's worth double checking Event Viewer to see if any errors are occurring that keep IIS Compression from working.

3) Enable Compression in IIS

- From the IIS snap-in, right-click on the Web Sites node and click on Properties
- Select the Service tab - Enable Compress application files
- Enable Compress static files
- Change Temporary Directory to the folder that you created above, or leave it at it's default
- Set the max size of the temp folder to something that the hard drive can handle. i.e. 1000.
- Save and close the Web Site Properties dialog

Note: The temporary compress directory is only used for static pages. Dynamic pages aren't saved to disk and are recreated every time so there is some CPU overhead used on every page request for dynamic content.

4) Metabase changes

To enable metabase edit-while-running using IIS Manager

In IIS Manager, right-click the local computer, and then click Properties.
Select the Enable Direct Metabase Edit check box.

- Open the metabase located at C:\Windows\system32\inetsrv\metabase.xml in Notepad
- Search for deflate and one for gzip. Basically they are two means of compression that IIS supports.
- First thing to do is add aspx, asmx, php and any other extension that you need to the list extensions in HcScriptFileExtensions.

HcDynamicCompressionLevel has a default value of 0. Basically this means at if you did everything else right, the compression for dynamic contact is at the lowest level. The valid range for this is from 0 to 10.

The compression level -vs- CPU usage which showed that the CPU needed for levels 0 - 9 is fairly low but for level 10 it hits the roof. Yet the compression for level 9 is nearly as good as level 10.

5) Restart IIS

Origianl Post : http://weblogs.asp.net/owscott/archive/2004/01/12/57916.aspx

Precompile an ASP.NET Web site in place

2011-10-04T10:13:00.000-07:00

To precompile an ASP.NET Web site in place

Open a command window and navigate to the folder containing the .NET Framework.
The .NET Framework is installed in the following location.
other
Copy
%windir%\Microsoft.NET\Framework\version
Run the aspnet_compiler command by typing the following at a command prompt.
other
Copy
aspnet_compiler -v /virtualPath
The virtualPath parameter indicates the Internet Information Services (IIS) virtual path of your Web site.
If your Web site is not an IIS application, and therefore has no entry in the IIS metabase, type the following command at a command prompt.
other
Copy
aspnet_compiler -p physicalOrRelativePath -v /
In this case, the physicalOrRelativePath parameter refers to the fully qualified directory path in which the Web site files are located, or a path relative to the current directory. The period (.) operator is allowed in the physicalOrRelativePath parameter. The -v switch specifies a root that the compiler will use to resolve application-root references (for example, with the tilde (~) operator). When you specify the value / for the -v switch, the compiler will resolve the paths by using the physical path as the root.

Setting Default parameter when opening PDF

2011-05-12T10:26:00.000-07:00

For example, a scale value of 100 indicates a zoom value of 100%. e.g. zoom=100

The file of more details is located on :

http://partners.adobe.com/public/developer/en/acrobat/PDFOpenParameters.pdf#page=5&zoom=50&scrollbar=0

How to Disable the ASP.NET v4.0 Extensionless URL feature on IIS 6.0

2011-05-11T08:49:00.000-07:00

You can disable the v4.0 ASP.NET extensionless URL feature on IIS6 by setting a DWORD at HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\ASP.NET\4.0.30319.0\EnableExtensionlessUrls = 0. After changing the value, you will need to restart IIS in order for us to pick up the change, because it is only read once when IIS starts.

Note that for Wow64 (i.e., 32-bit worker process running on 64-bit OS), this registry key must be set at HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\ASP.NET\4.0.30319.0\EnableExtensionlessUrls.

Please refere to this URL for details: https://blogs.msdn.com/b/tmarq/archive/2010/06/18/how-to-disable-the-asp-net-v4-0-extensionless-url-feature-on-iis-6-0.aspx

The way to get control ID from custom Text source of RadSpell

2011-04-29T08:21:00.000-07:00

Here is the way to get the TextBox ID from the custom text source of RadSpell.

this.sources[i].get_element().id

Save the scroll position when doing Ajax

2011-03-14T13:29:00.000-07:00

var scrollTop;
Sys.WebForms.PageRequestManager.getInstance().add_beginRequest(BeginRequestHandler);
Sys.WebForms.PageRequestManager.getInstance().add_endRequest(EndRequestHandler);

function BeginRequestHandler(sender, args)
{
var elem = document.getElementById('<%= scrollBar.ClientID %>');
scrollTop=elem.scrollTop;
}

function EndRequestHandler(sender, args)
{
var elem = document.getElementById('<%= scrollBar.ClientID %>');
elem.scrollTop = scrollTop;
}

ASP.NET with SQL 2005 Cache Dependence

2010-11-17T12:44:00.000-08:00

1) Check to see Service Broker is enabled

SELECT name, is_broker_enabled FROM sys.databases

2) To enable the Service Broker on your database

ALTER DATABASE Pubs SET ENABLE_BROKER
GO

3) Inform SQL Server that the user running IIS has permission to subscribe to query notificatoins.

GRANT SUBSCRIBE QUERY NOTIFICATIONS TO "IIS_SERVER\ASPNET"

4) Create a connectionStrings in the web.config

<connectionstrings>
<add name="myDbConnectionString" connectionstring="Data Source=localhost;Initial Catalog=MyDB;Integrated Security=True" providername="System.Data.SqlClient">
</connectionstrings>

5) Enable the website to be able to receive notifications.

protected void Application_Start(object sender, EventArgs e)
{
SqlDependency.Start(ConfigurationManager.ConnectionStrings["myDbConnectionString"].ConnectionString);
}

The following code also stops the listener:

protected void Application_End(object sender, EventArgs e)
{
SqlDependency.Stop(ConfigurationManager.ConnectionStrings["myDbConnectionString"].ConnectionString);
}

6) Sets up the cach dependency. Example code.

string tableName = query.Context.Mapping.GetTable(typeof(T)).TableName;
List result = HttpContext.Current.Cache[tableName] as List;

if (result == null)
{
using (SqlConnection cn = new SqlConnection(query.Context.Connection.ConnectionString))
{
cn.Open();
SqlCommand cmd = new SqlCommand(query.Context.GetCommand(query).CommandText, cn);
cmd.Notification = null;
cmd.NotificationAutoEnlist = true;
SqlCacheDependencyAdmin.EnableNotifications(query.Context.Connection.ConnectionString);
if (!SqlCacheDependencyAdmin.GetTablesEnabledForNotifications(query.Context.Connection.ConnectionString).Contains(tableName))
{
SqlCacheDependencyAdmin.EnableTableForNotifications(query.Context.Connection.ConnectionString, tableName);
}

SqlCacheDependency dependency = new SqlCacheDependency(cmd);
cmd.ExecuteNonQuery();

result = query.ToList();
HttpContext.Current.Cache.Insert(tableName, result, dependency);
}
}

Re-Associate the dbo to sa login after db restored

2010-11-05T08:59:00.000-07:00

You could use the following SQL script to relink the dbo user of a db to login.

ALTER AUTHORIZATION ON DATABASE::[db name] TO [login name]

Error : System.Security.Cryptography.CryptographicException: The system cannot find the file specified

2010-10-27T13:42:00.000-07:00

Change the Identity of the application pool to "NetworkService".

Required components of IIS7.0 for installing SQL Server 2005 on Windows 7

2010-10-26T09:09:00.000-07:00

When you try to install SQL Server 2005 on Window 7, you may receive the following warning message for the IIS Feature Requirement item on the System Configuration Check page in the SQL Server 2005 Setup program:

Microsoft Internet Information Services (IIS) is either not installed or is disabled. IIS is required by some SQL Server features. Without IIS, some SQL Server features will not be available for installation. To install all SQL Server features, install IIS from Add or Remove Programs in Control Panel or enable the IIS service through the Control Panel if it is already installed, and then run SQL Server Setup again. For a list of features that depend on IIS, see Features Supported by Editions of SQL Server in Books Online.

This problem occurs because not all the IIS 7.0 components that SQL Server depends on are installed on the computer. The following table lists the affected components.

Component	Folder
Static Content	Common HTTP Features
Default Document	Common HTTP Features
HTTP Redirection	Common HTTP Features
Directory Browsing	Common HTTP Features
ASP.Net	Application Development
ISAPI Extension	Application Development
ISAPI Filters	Application Development
Windows Authentication	Security
IIS Metabase	Management Tools
IIS 6 WMI	Management Tools

Add Date Time stamp to the Windows Backup File Name

2010-03-29T09:49:00.001-07:00

1. Use the Windows Backup GUI interface to create a backup job. Make sure to
specify that it should not run now but later.

2. Open the Task Scheduler, then open the backup job that you just created.

3. Mark & copy the whole command line.

4. Create the new batch file "MyBackup.bat"

5. Paste the backup command line into it.

6. Create some blank lines at the top of the file, then paste the following
code into the empty space.

@echo off
set MyDate=%date:/=_%_%time::=_%
ntbackup /.. /.. /.. /F d:\Backups\%MyDate%_File_Backup.bkf

7. Adjust the last line of the above code so that it matches your own
switches, then remove the original Windows Backup command line.

8. Use the Task Scheduler to create a task that will invoke
"MyBackup.bat" instead of your previous Windows Backup command

SQL 2005 : Database Mail Setup

2010-02-23T18:16:00.000-08:00

Enable Database Mail feature via Surface Area Configuration for Features.
In SSMS, Use Database Mail Configuratin Wizard to create account and profile.
Select a default profile.
Create Operator.
If you would use Alert to notifiy operator, enable Mail Profile in Alert system option of SQL Server Agent.
Restart the SQL Server Agent.
You are ready to use Database Mail to notify the operator now.

ASP.NET Page Events Lifecycle

2010-02-23T10:51:00.000-08:00

This is for my own reference purpose. The The original info comes from : http://weblogs.asp.net/ricardoperes/archive/2009/03/08/asp-net-page-events-lifecycle.aspx

When using master pages, the normal page event lifecycle is a little different. Here is the actual order:

Page.OnPreInit
MasterPageControl.OnInit (for each control on the master page)
Control.OnInit (for each contol on the page)
MasterPage.OnInit
Page.OnInit
Page.OnInitComplete
Page.LoadPageStateFromPersistenceMedium
Page.LoadViewState
MasterPage.LoadViewState
Page.OnPreLoad
Page.OnLoad
MasterPage.OnLoad
MasterPageControl.OnLoad (for each control on the master page)
Control.OnLoad (for each control on the page)
OnXXX (control event)
MasterPage.OnBubbleEvent
Page.OnBubbleEvent
Page.OnLoadComplete
Page.OnPreRender
MasterPage.OnPreRender
MasterPageControl.OnPreRender (for each control on the master page)
Control.OnPreRender (for each control on the page)
Page.OnPreRenderComplete
MasterPageControl.SaveControlState (for each control on the master page)
Control.SaveControlState (for each control on the page)
Page.SaveViewState
MasterPage.SaveViewState
Page.SavePageStateToPersistenceMedium
Page.OnSaveStateComplete
MasterPageControl.OnUnload (for each control on the master page)
Control.OnUnload (for each control on the page)
MasterPage.OnUnload
Page.OnUnload

Steps to install dotProject

2010-02-19T10:52:00.000-08:00

Add "dp_user" user to the MySQL.
1) Install Apache web server.

2) Install PHP to your web server.

PHP should support GD and MySQL

3) Install MySQL.

4) Add "dp_user" user to the MySQL.

5) Create a schema (Database) "dotproject" and assign user "dp_user" has full permission of this DB.

6) Copy all dotProject files to the htdocs folder.

- Open browser to access http://Your Domain/dotProject/install/index.php

- follow the step to complete the installation.

7) The default admin login is :

User Id : admin
Password : passwd

Prepare SQL 2005 to use CLR

2010-02-19T10:37:00.000-08:00

1) Turn on the 'clr enabled" feature of your server.

sp_configure 'clr enabled', 1
GO
RECONFIGURE
GO

2) Turn on the Trustworthy property of your database if your clr assembly require access external resources.

ALTER DATABASE [DB Name]
SET TRUSTWORTHY ON

Use Diskpart to Remove EISA Partition

2009-11-22T01:20:00.000-08:00

Open a command prompt as administrator.
Run Diskpart application by typing Diskpart in the command prompt.
In the “Diskpart” prompt, enter rescan command and press Enter key to re-scan all partitions, volumes and drives available.
Then type in list disk and press Enter key to show all hard disk drive available.
Select the disk that contains the partition you want to remove. So the command will be:
select disk y

Finish by Enter key.
Type list partition and press Enter key to show all available and created partition in the disk selected.
Select the partition that wanted to be deleted by using the following command, followed by Enter key:
select partition x

where x is the number of the EISA based recovery partition to be removed and unlocked its space. Be careful with the number of this partition, as wrong number may get data wipes off.
Finally, type in delete partition override and press Enter key.

Caution when upgrade WinService from .NET 1.1 To .NET 2.0

2009-09-23T11:40:00.000-07:00

When you try to upgrade a WinService from .NET 1.1 to .NET 2.0, Please pay attention at the thread mode. In .NET 1.1, the default value of the thread mode is background. However, the default value of the thread mode is changed in .NET 2.0.

In .NET 2.0, You need to explicitly set the thread mode to background.

Reduce LDAP connection creation

2009-06-09T13:41:00.001-07:00

I have a problem when my application runs to do a high-volumn LDAP operation.

This is the original codes. This code creation a lot of TCP port to AD with "TIME WAIT" status.

private void AddToGroup(UserPrincipal currentUser, GroupPrincipal group)
{
using (DirectoryEntry dirEntry = new DirectoryEntry(string.Format("LDAP://{0}/{1}", group.Context.ConnectedServer, group.DistinguishedName)))
{
dirEntry.Properties["member"].Add(currentUser.DistinguishedName);
dirEntry.CommitChanges();
dirEntry.Close();
dirEntry.Dispose();
}
}

In order to reduce the LDAP connection creation from using SDS.AM. We could use the GetUnderlyingObject() method to get the corresponding DirectoryEntry object of the UserPrincipal or GroupPrincipal. Using this way, my application could finish its task without error. Here is the new codes to do the same thing.

private void AddToGroup(UserPrincipal currentUser, GroupPrincipal group)
{
using (DirectoryEntry gEntry = (DirectoryEntry)group.GetUnderlyingObject())
{
gEntry.Properties["member"].Add(currentUser.DistinguishedName);
gEntry.CommitChanges();
}
}

Here is a reference from Microsoft. http://msdn.microsoft.com/en-us/library/bb924562.aspx

No wrap for Telerik RadGrid cell content

2009-06-06T13:53:00.000-07:00

Put the cell content between < nobr></nobr>

Get Mime Type from IIS

2009-06-06T12:13:00.000-07:00

Except the System.DirectoryServices, I also need to add a reference of com object "Active DS IIS Namespace Provider" in VS.

using System.DirectoryServices;

public static string GetMimeType(string extension)
{
string retMimeType = null;

using (DirectoryEntry mimeMap = new DirectoryEntry("IIS://Localhost/MimeMap"))
{
PropertyValueCollection pValues = mimeMap.Properties["MimeMap"];

foreach (object value in pValues)
{
IISOle.IISMimeType mimeType = (IISOle.IISMimeType)value;

if (extension == mimeType.Extension)
{
retMimeType = mimeType.MimeType;
}
}

}
return retMimeType;
}

LDAP administration limits in Active Directory

2009-05-29T20:06:00.000-07:00

LDAP Limits In Active Directory From MS.

How to view and set LDAP policy in Active Directory by using Ntdsutil.exe

Active Directory Performance Testing Tool

2009-05-29T16:48:00.000-07:00

Here are AD performance testing tool from MS.

Active Directory Performance Testing Tool

Active Directory Performance for 64-bit Versions of Windows Server 2003

Troubleshooting Active Directory performance problems

2009-05-29T16:42:00.000-07:00

Here is some good articles for troubleshooting Active Directory performance problems

SolutionBase: Troubleshooting Active Directory performance problems

SolutionBase: Discover Active Directory performance problems with Performance Monitor