Personal Notes of Edwin Eu

Archive for June, 2011|Monthly archive page

The Web applications used to isolate content, processes, features, and users

In SharePoint 2010 on 06/08/2011 at 2:10 PM

The Web applications used to isolate content, processes, features, and users

  • The Web applications can separate content that is accessible by anonymous users from content that is accessed by authenticated users, or content that is accessible by employees, by hosting the content in separate Web applications.
  • Each Web application has a unique domain name, which helps to prevent cross-site scripting attacks.
  • Can assign a unique application pool to a Web application, which isolates its processes.
  • When you create a new Web application, you also create a new content database that defines the authentication method used by the application pool to connect to the database.
  • When you create a new Web application, you specify the authentication method used to connect to the IIS Web site.
  • Policy can be specified uniquely for each Web application.

Enabling CLR Integration

In Microsoft SQL Server on 06/08/2011 at 8:36 AM

The common language runtime (CLR) integration feature is off by default. The CRL must be enabled in orde to use objects that are implemented using CLR integration.

To enable CLR integration

Sp_configure ‘show advanced options’, 1;
GO

RECONFIGURE;
GO

Sp_configure ‘clr enabled’, 1;
GO

RECONFIGURE
GO