Configure Folder or Web Site to Use SSL/HTTPS

Configure Folder or Web Site to Use SSL/HTTPS

This procedure assumes that your site has already has a certificate assigned to it.

1. Log on to the Web server computer as an administrator.
2. Click Start, point to Settings, and then click Control Panel.
3. Double-click Administrative Tools, and then double click Internet Services Manager.
4. Select the Web site from the list of different served sites in the left pane.
5. Right-click the Web site, folder, or file for which you want to configure SSL communication, and then click Properties.
6. Click the Directory Security tab.
7. Click Edit.
8. Click Require secure-channel (SSL) if you want the Web site, folder, or file to require SSL communications.
9. Click Require 128-bit encryption to configure 128-bit (instead of 40-bit) encryption support.
10. To allow users to connect without supplying their own certificate, click Ignore client certificates.
    
    Alternatively, to allow a user to supply their own certificate, use Accept client certificates.
11. To configure client mapping, click Enable client certificate mapping, and then click Edit to map client certificates to users.
    
    If you configure this functionality, you can map client certificates to individual users in Active Directory. You can use this functionality to automatically identify a user according to the certificate they supplied when they access the Web site. You can map users to certificates on a one-to-one basis (one certificate identifies one user) or you can map many certificates to one user (a list of certificates is matched against a specific user according to specific rules. The first valid match becomes the mapping).
12. Click OK.

Speed up your queries

http://www.dotnetfunda.com/articles/article1949-tricks-to-speed-up-your-sql-query.aspx

Date format error while migrating to sql 2008

Reason for error
1.    Application pool configured for your application in iis was ‘Default Application Pool’ and default framework for  ‘Default Application Pool’ was 2.0.
2.   your application supports only framework 1.1.
3.    Calendar control used in your application was not functioning properly because of the above frame work issue.
4.    Server date time was in different format.

(This reasons were not predictable as we used iis 6 with framework 1.1)

Actions taken for resolution
1.    Changed server date format to ‘M/d/yyyy’.
2.    Restarted the server.
3.    Uninstalled and installed framework 1.1 using ‘aspnet_regiis.exe –u/-i’ (When multiple version of framework in same server)
4.    Created separate application pool for your application with 1.1 framework.
5.    Changed ‘Managed Pipeline Mode’ to ‘Classic’ from ‘Integrated’ as 1.1 will not support ‘Integrated’ (Application pool >> Advanced settings >>MANAGED Pipeline Mode)
6.    Added below line in Machine.config file.to avoid “unrecognized configuration section 'system.webserver' “(Microsoft.NET\Framework\v1.1.4322\CONFIG) . added before  </configSections>
          <section name="system.webServer" type="System.Configuration.IgnoreSectionHandler, System, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />

Solution provided for Mail triggering:

Reason: In Windows 2003 app pool will be serving with default Identity as “Network Service” but in Windows 2008 R2 app poll will be serving with Default Identity as ApplicationPoolIdentity.

http://www.macronimous.com/resources/stored_procedures_tips.asp

" M4Mahi " crossing 5000 hits ............. Thanks for all visitors and bloggers