Windows Sharepoint Service - 3

In continuation with previous post. Now we will see how to create a individual WSS farm and a child site

Create a new IIS Web Site
a. Open IIS Manager
b. Right-Click on Webs Sites, New -> Web Site to open the Web Site Wizard
c. Enter a description of WSS and click Next
d. Leave IP Address and Port unchanged, but enter WSS in the Host Headers field and click Next
** This assumes you have a DNS record for WSS and the server IP
e. Click Browse then create a new folder under c:\inetpub called WSS and select it, then click Next
f. On the screen title Web Site Access Permissions click Next
g. Click Finish to complete the Web Site creation
Extend the new IIS Web Site
By extending a virtual server we are effectively installing WSS onto the Web Site.
a. Open SharePoint Central Administration - Start -> Administrative Tools -> SharePoint Central Administration
b. Ensure Windows SharePoint Services administration is displayed, link in left column
c. Click on Configure Virtual Server Settings
d. Click on the WSS link
e. On the Extend Virtual Server page, click on Extend and create a content database
f. On the Extend and create content database page, select Use an existing application pool, and choose MSSharePointAppPool from the dropdown.
** Additional Application Pools can be configured to separate instances of WSS running on a single server and thereby ensuring a fault in one application does not affect another.
g. Enter and email address, for example administrator@localhost and click OK
** Extending the virtual server may take some time
h. When completed click on http://wss/
i. When asked to select a template, chose whichever one suits, for example Team Site

Your new dedicated WSS Team Site farm as now been created, all that is needed it to connect it to the Portal

Configure the Portal to use the new Team Site Farm
Once the new WSS environment has been created, Self Service Site Creation must be enabled and the Portal used to create and manage the team sites needs to be informed of the location of the new environment.

a. Open SharePoint Central Administration - Start -> Administrative Tools -> SharePoint Central Administration
b. Click on the Configure Virtual Server Settings link
c. Click on the WSS link
d. Click on Configure Self-Service Site Creation
e. Ensure the option is set to On and then click OK
f. Open the Portal by browsing to http://portal/
g. Click on the Site Settings link
h. Click on the Change portal site properties and SharePoint site creation settings link
i. In the Location for Creating SharePoint Sites field enter:
http://WSS/_layouts/1033/scsignup.aspx
And click OK

Create a new Team Site
With the portal now configured to use the new dedicated Team Site environment, we can create a new Team Site.

a. Click on the Sites link
b. Click on the Create Site link
c. Enter a Title (eg. Demo Site), URL and Owner for the site and click OK
d. On the Add Link to Site screen, which adds the new site to the Site Registry, leave as default and click on OK
e. Select a Template and click OK
f. Verify that your new Team Site has been successfully created on the WSS virtual server

This is how you create a website and a child site.
There are five site groups in WSS

Guest - By default nothing
Reader - Use Self-Service Site Creation, View Pages, View Items,
Contributor - All rights included in the Reader site group, plus:Add Items, Add/Remove Private Web Parts, Browse Directories. Create Cross-Site Groups, Delete Items, Edit Items, Manage Personal Views, Update Personal Web Parts
Web Designer - All rights included in the Contributor site group, plus: Add and Customize Pages, Apply Themes and Borders, Apply Style Sheets, Cancel Check-out, Manage Lists
Administrator - All rights included in the Web Designer site group, plus: Create Subsites, Manage List Permissions, Manage Site Groups, View Usage DataData

For more information download administrator's userguidehttp://www.microsoft.com/downloads/details.aspx?FamilyID=a637eff6-8224-4b19-a6a4-3e33fa13d230&DisplayLang=en

Windows Sharepoint Service - 2

In continuation with previous post. Now we will see how to install Windows Sharepoint Service (WSS). This is a free version of Sharepoint portal server.
First we need the installer file. Here you downlaad the installer http://www.microsoft.com/windowsserver2003/technologies/sharepoint/default.mspx
It is just 34 MB

Check whether your machine meet the requirements
Windows 2003
.Net 1.1
IIS 6.0
Sql server 2000/MSDE

Double click on the downloded file STSV2.EXE.
This will cause Windows to decompress the file’s contents and to launch the installation program.
1. The Setup wizard appears, accept the license agreement and click Next to continue.
2. The next screen will ask you if you would like to perform a typical installation or if you would rather set up a server farm.
select the Typical Installation option and click Next.
3. The Setup program will now confirm that it is about to install the SharePoint Services and that the target drive has enough free space. Click the Install button to begin installing the necessary files.
4. As the installation progresses, you might notice a message indicating that Setup is configuring the Microsoft SQL Desktop Engine. The Windows SharePoint Services are dependant on SQL Server. As we all know though, SQL Server can be expensive. If you don’t have SQL Server installed on your server prior to installing the Windows SharePoint Services, Setup will automatically configure the SharePoint Services to use MSDE.

Once you the installtion is complete. Go to control panel>> administrative tools you will see the link to sharepoint adminstration. On double clicking you will see a page where you can create websites in sharepoint portal server and configuring them.

How are bit columns stored by the SQL Server?

How are bit columns stored by the SQL Server storage engine?

1. Each field is stored as an 8-bit integer.
2. All bit columns are stored together in 8-bit(byte) groups.
3. Bit columns are stored the same as varbinary columns.
4. All bit columns are stored together in two contiguous bytes since SQL Server only allows 16 bit columns in a row. 5. Each bit column is stored in its respective place in the row as a single bit.

Answer:
2. Microsoft® SQL Server™ optimizes the storage used for bit columns. If there are 8 or fewer bit columns in a table, the columns are stored as 1 byte. If there are from 9 through 16 bit columns, they are stored as 2 bytes, and so on.