HowTo: Custom SharePoint 2010 Deployment Configuration

A default SharePoint 2010 deployment has seven steps: it runs the pre-deployment command line, packages the WSP file, recycles the application pool, retracts the previous version of the solution, adds the solution, activates all features, and runs the post-deployment command line. This proces is fully customizable.

Creating a custom deployment configuration is not that difficult:

  1. Right click on your SharePoint Project. Click “Properties”. Click “SharePoint”

    SharePoint Deployment Configuration Settings

    SharePoint Deployment Configuration Settings

  2. Click “New” to create a new configuration.

    New Deployment Configuration

    New Deployment Configuration

By default your SharePoint Visual Studio 2010 Project Template comes with two predefined configurations: “Default” and “No Activation”. The two pre-configured configurations cannot be modified. The difference between these two is that “No Activation” does not contain the step “Activate Features”.

Different deployment configurations can be used for deployment to different environments e.g. deployment to a development  server or to a production server. Be sure to select the right configuration for the right environment!

That’s all, maybe until next time, happy Sharepointing!

HowTo: Create a teamsite in SharePoint 2010

Creating a teamsite in SharePoint 2010

Very important when working with site templates is knowing what SharePoint out-of-the-box can do for you and very often too much time and effort is spend building that which SharePoint already has. So before you start creating custom templates, check out the existing templates you’ll discover that they often have exactly what you require. That’s why in short I’ll explain what a team site can do for you and how you can create one.

A huge part of SharePoint is about collaboration. Collaboration can be achieved in many ways when using SharePoint. A very popular method to achieve synergy is to use one of the most well known templates that SharePoint 2010 contains: the Team site template. By default the team site contains a shared calendar which you e.g. can use to track important team events. It also contains tasks in which you can keep track of team tasks. You can assign tasks to team members, keep track of status and due date. Finally there is Team Discussion in which you can discuss team items in a very simple manner, it has reply options and also quoted messages.

How to create the teamsite

  1. Navigate to the site which you chose to hold your new teamsite.
  2. In the left upper corner, click “Site Actions”, next click “More Options”. Under “Filter By:” click “Site”.

    Creating a team site

    Creating a team site

  3. Click on the “Team Site” template and fill in an appropriate title. You also get to choose the site url from which you can directly access the new team site.   If you want to save some time, click “More options” it allows you to set permissions and navigation options right away.

    Creating a team site

    Creating a team site

  4. When done, click create and SharePoint will create the site for you.
To get a better understanding of the different SharePoint templates visit this site, it hosts a bunch of movies for all built-in templates and shows you the different possibilities. If you want even more, this site is also a good resource for the different site templates that SharePoint boasts. 
That’s all there is to it, happy SharePointing!
 

SharePoint versions 

  • SharePoint 2010 Foundation
  • SharePoint 2010 Standard Edition
  • SharePoint 2010 Enterprise Edition
  • SharePoint 2010 Online (Office 365 Edition)

Permission level

  • Full Control

HowTo: Create a Content Type in SharePoint 2010

Audience

This post is for SharePoint beginners. In a previous post I explained how to create a site column. Site columns can be re-used in lists and they are also used when creating content types. A content type is used to define a SharePoint entity. It can, in a way, be seen as a meta data template which defines which data is stored and how it is stored. A custom content type always inherits from another content type, this can be a built-in type or a previously created custom content type. When creating a content type, you select a content type group and from this group you select the parent content type. The newly created content type inherits all properties from the parent. After this you add site columns and you’re ready to go.

Before you go and start creating content types, assure yourself that there is no built-in content type that fits your needs.

Creating the Content Type:

  1. Navigate to the root of the site collection in which you want to create your content type.
  2. In the upper left corner click “Site Actions” and then click “Site Settings”.
  3. Under “Galleries” click “Site content types”.

    Creating a content type

    Creating a content type

  4. This opens an overview of existing “Built-in” content types as-well as previously created content types. To create a new content type, click “Create” in the upper left corner.

    Creating a content type

    Creating a content type

  5. After clicking “Create”, a window opens in which you can create a new content type. After picking an appropriate name and describing your new content type, you have to pick a parent content type. First pick the appropriate category and then pick the actual parent. Your new content type will inherit all columns from this type. Finally you get to pick the category in which the new content type is placed.

    Creating the new content type

    Creating the new content type

  6. When done, click “OK” to create the new content type. When done you will be taken to the content type details window in which you can see how you content type is built up. This of course is also the place where you add columns to your new content type. How to add these columns can be seen in my article about site columns. You can only add site columns to a content type.
That’s all there is to it. Until we meet again. Happy SharePointing!
 

SharePoint versions 

  • SharePoint 2010 Foundation
  • SharePoint 2010 Standard Edition
  • SharePoint 2010 Enterprise Edition
  • SharePoint 2010 Online (Office 365 Edition)

Permission level

  • Design
  • Full Control

HowTo: Set permissions on a list in Sharepoint 2010

If you want to be in control of which user can access certain data you need to set permissions. Individual permissions are kept together in permission levels. So permission levels are in a sense containers which hold sets of permissions which can be assigned to users. By default security permissions are inherited from the container or parent object. you can set unique permissions by breaking this inheritance and assign the permission which you require.

Setting permissions  for a list

  1. Navigate to the list for which you want to set certain permissions.

    Editing list permissions

    Editing list permissions

  2. Click on the list permissions icon, you’ll get an overview of the current permission settings.
  3. To set permissions you first have to break the inheritance. Breaking the inheritance does not remove the current inherited permissions, this setting ensures that new permissions on the parent object will no longer be inherited. Any permissions you don’t want, must be manually deleted, which can be done from the current view. To break inheritance click “Stop Inheriting Permissions”

    Breaking permission inheritance

    Breaking permission inheritance

  4. Next click yes in the confirmation pop-up.

    Confirm breaking permission inheritance

    Confirm breaking permission inheritance

  5. The inheritance is now gone, so new permissions set on the parent will no longer apply to this list.

    Inheritance broken

    Inheritance broken

  6. So again any permissions set until now, will still be apply, you can remove any that no longer apply. The next step is to add the new permissions. Click “Grant Permissions”. This will open a pop-up in which we can assign new permissions.

    Setting a new permission

    Setting a new permission

More specific details on the permission levels can be found here.

That’s all there is to it. Good luck and till next time, until then, happy SharePointing.

SharePoint versions 

  • SharePoint 2010 Foundation
  • SharePoint 2010 Standard Edition
  • SharePoint 2010 Enterprise Edition
  • SharePoint 2010 Online (Office 365 Edition)

Permission level

  • Design
  • Full Control

HowTo: Create a Site Column in SharePoint 2010

This post is for SharePoint beginners. When creating custom lists or customizing lists based on the default templates, you often add columns. If you want to re-use these columns you can choose to create site columns, these are re-usable.

Why and when to use site columns

Some columns you add to your lists might be unique, unique in your organisation, or unique in your project. As some columns may be unique, others can have multiple occurrences within you organisation. When columns have more settings and options to it and in that way can become relatively complex, when this occurs it might be handy to re-use these columns. This has several advantages. It saves you time, time in creating them and perhaps time in testing them. It also ensures that every different list, has the same way of displaying and functioning of the site column.

How to create a site column

  1. Navigate to the top level site of the site collection in which you want to use the site column. The site column will only be shared in the site collection and its children.
  2.  In the upper left corner click “Site Actions” and then choose “Site Settings”. Next, under “ Galleries” , click “Site columns”.

    Creating a site column: Menu

    Creating a site column: Menu

  3. On the page that is displayed, a list with all existing site columns is displayed. Click “Create” to create a new site column.

    Creating a site column: Column list

    Creating a site column: Column list 

  4. This opens a page which looks familiar if you have create a list column before, or maybe you’ve seen it reading my post about creating a custom list. When all the properties of the site column are set to fit your needs, click “Ok” to create the site column.

    Creating a site column: Existing site columns

    Creating a site column: Existing site columns 

  5. After creating the site column we of course also want to use it. The first time I tried to, it took me some time to find where I could do that. In the site collection where you created your site column, either create a new list, or use an existing one. Click on the list. In the Ribbon, make sure that under “List Tools”, List is selected (click it). Then, in the Ribbon, click “List Settings”.
  6. Scroll down to “Columns” and click “Add from existing site columns”.

    Adding a site column to a list: Menu

    Adding a site column to a list: Menu 

  7. Add the column to the list and presto, we’re done.

    Adding a site column to a list: Adding the columns

    Adding a site column to a list: Adding the columns 

SharePoint versions 

  • SharePoint 2010 Foundation
  • SharePoint 2010 Standard Edition
  • SharePoint 2010 Enterprise Edition
  • SharePoint 2010 Online (Office 365 Edition)

Permission level

  • Design
  • Full Control

More to read

I can imagine that you might want to know even a bit more on site columns, as this article is only about creating a site column. I recommend you read this article, it elaborates about the basics and theory surrounding site columns and content types. If you want to know hot to create a content type, read my article about creating content types.

Thats all folks, for now Happy SharePointing and untill next time.

HowTo: Create your own SharePoint list in SharePoint 2010

Audience

This post is for SharePoint beginners. If you need to store data in Sharepoint and the default list templates don’t offer the options you need, then you’ll probably want to create a custom list. This post shows you step by step, how to create a your own list, I’ll also show you some of the different column types and the options they offer.

The SharePoint list

As I said in one of my other posts, the list is one of the core components of SharePoint. SharePoint has a number of list templates ready to use:

  • Announcements
  • Calendar
  • Contacts
  • Discussion Board
  • Issue Tracking
  • Links
  • Project Tasks
  • Status List
  • Survey
  • Tasks

But what to do if there is nothing there that fits your needs?  Then you create a custom list.

How to create a custom list:

  1. Navigate to the site on which you want to create the custom list.
  2. In the upper left corner click “Site Actions” and then “More Options”.
  3. Under “Filter By” choose list, for category choose “Blank & Custom”.

    Creating a custom list

    Creating a custom list

  4. On the right hand side of the popup “Create”, click “more options”. By default you can only choose a name, now you can also give your custom webpart a description and choose whether or not to have it displayed in the “Quick Launch” menu (by default on the left on your site). Fill in an appropriate name, a description and click “Create”.

    Creating a custom list: More Options

    Creating a custom list: More Options 

  5. Once the list has been created SharePoint will take you to the list view. The new list has one default column named “Title”. So now we want to add some columns. Choose “Create Column” from the ribbon. 
  6. In the “Create Column” screen, we can set a “Name and Type”, set “Additional Column Settings” and, if we want to provide column validation, to guide a user to input valid data.
  7. In the first column I chose “Applicant” as the column name. For the type I chose “Single line of text”. For “Description” I entered “The budget applicant”. With “Require that this column contains information” I chose yes, it enforces that the end-user enters a value for this field. I left maximum number of characters at 255. We can supply a “Default Value” this is the initial value of the field. We can choose to add the field to the “default view”. a list can have different views, a view is the way that the list is displayed. If you do not add a field to the default view then by default it is not displayed. This is only in the list mode, so you do see the value when adding or editing an item. I did not add any column validation. Now we can click “Ok” to add the column to the list.

    Creating a column: Single line of text

    Creating a column: Single line of text

  8. After the first column, I created a second columns with the “Currency” type. This column type has a built-in validation for min. and max. value.

    Creating a column: Currency

    Creating a column: Currency

  9. For the third column I chose a “Person or Group” type. it lets you choose whether to pick only “People” or “People and Groups” and it also enables you to pick a certain group or “All Users”.
    Creating a column: People or Group

    Creating a column: People or Group

    Creating a column: Options for Group

    Creating a column: Options for Group

  10. Another type I used in this example is the “Choice” type. It creates a  ”Drop-down menu”, “Radiobuttons” or a “Checkboxlist” in your SharePoint list from which the user can choose a value. You have the option to set a default choice and whether or not to enforce the given choices or allow typed values.
    Creating a column: Choice

    Creating a column: Choice

    Creating a column: Choice options

    Creating a column: Choice options

  11. A few other options I do want to show (I did not actually add them) are the “Lookup” field, it lets you use another list to pick an Item from. For that item you can decide which fields of the referenced list to display in your own list.
    Creating a column: Lookup field

    Creating a column: Lookup field

    When adding a “Lookup” field the Relationship part is very important, it defines how to work with deletion. What happens when the item referenced by this list is deleted in the referenced list. When choosing to “Enforce relationship behavior” you have 2 choices, either go for “Restrict delete” which as it says restricts the delete on the referenced list, or go for “Cascade delete” which deletes the item from the referencing list (the list you just created).

    Creating a column: Lookup field relationship

    Creating a column: Lookup field relationship

  12. To connect to external data you can use the “External Datatype”, this only works if you have Business Data Connectivity enabled and created an External Content Type for the data you want to use. I plan to write more on this in future articles.

    Creating a column: External Data

    Creating a column: External Data

  13. When we’re done creating the list, the “New item” form, will look something like this:

    Form: New Item

    Form: New Item

SharePoint versions 

  • SharePoint 2010 Foundation
  • SharePoint 2010 Standard Edition
  • SharePoint 2010 Enterprise Edition
  • SharePoint 2010 Online (Office 365 Edition)

Permission level

  • Design
  • Full Control

Ok so that’s it for now, Happy SharePointing.

Setting up a Virtualized SharePoint 2010 learning environment

Why?

As I was setting up this blog I might have been a bit too enthusiastic. I started posting without thinking. That doesn’t mean that I’m not behind that which I posted, it’s more that I should have put some more thought into it, especially the structure. If I want to take people along on a learning and/or discovering tour of SharePoint 2010 I should have thought of the fact that most people don’t necessarily have a SharePoint 2010 environment ready to test and/or try out with. That’s what this post is all about. Setting up an environment in which we can test an try out. As I realize that people also might not have funds for setting up a state of the art environment I’ll try to keep the tools we use “as free as possible”. Of course you can also download the 2010 Information Worker Demonstration and Evaluation Virtual Machine, this setup will not run on a desktop or notebook. Another reason to follow this blog post is that although it is far from a complete multitier installatio, it will still give you some insight into the installation of SharePoint. 

Purpose of this setup:

This will not the ideal best practices setup with different server roles, an active directory and a database setup in raid etc etc. This setup will be as easy as possible, with least amount of effort while still giving you an environment to test with. I do plan to go more in depth with articles about best setup, different server roles, scalability and also development examples. This setup is not suited for that.

Hardware:

As far as the hardware goes, I am running this setup on an Asus N53J

Processor:                             Intel Core i5-460M

Processor clock speed:      2.53GHz

Memory:                                  8.00GB (upgraded from 4.00 GB)

Further specs here: http://www.expertreviews.co.uk/laptops/1281541/asus-n53j/specifications

The upgrade to 8 GB was what did it for me, the system is as fast as any fast live environment I’ve seen.

Software:

So lets get installing already!

So being the organized person everyone knows me to be (cough, cough), I advise you to first download everything you need and neatly place it all together in a single, easy to find folder. Well ok, here we go then:

Step 1 Install VirtualBox:

I already installed VirtualBox and don’t have a system ready to do it again and make screenshots, it’s no biggy, basically just a plain old  next, next finish. But details can be found here: https://www.virtualbox.org/manual/ch02.html#installation_windows

Step 2 Setting up VirtualBox for Windows

  1. Start up VirtualBox and click “New”, the wizard will start.
  2. Skip the intro screen by pressing next.
  3. VM Name and OS Type, in this window, type an appropriate name, for OS type, with OS choose “Microsoft Windows” for version choose “Windows 2008 64 bit” and press next.

    VirtualBox New Image installing windows 2008 R2 SP1

    Choose an OS for the new image

  4. Memory, choose the base memory size, if you have 6Gb or more on your host, choose 4Gb for the virtual environment, if you only have 4Gb on your host go for 2Gb for you virtual environment. Press next.
    VirtualBox Setting Memory

    VirtualBox Setting Memory

     

  5.  Virtual Hard Disk, I recommend 40Gb, 20Gb is the default, but better save than sorry. I haven’t found a way to increase the size, of course you can always add a second virtual hard disk, but once the first one is full you’ll be sorry, because updates and patches will need to be installed on the primary hard disk and when it’s full it is really full, so no more room for patches and/or updates. Choose a new harddisk. Click next.
    Startup Harddisk New Harddisk

    Choose a new Startup Harddisk

    Choose the type/format of the new disk, I chose VDI, you could e.g. consider VMDK if you also use VMWare. Click next.

    Choose the type of Virtual hard disk

    Choose the type of Virtual hard disk

    Fixed or Dynamical, I chose fixed, this will perform a bit better as the system will not need to increase size when you need it because it is already available. It will on the other hand take a bit longer to create. Click next.

    Virtual Hard disk Fixed or Dynamical

    Virtual Hard disk Fixed or Dynamical

    Location and size, I chose the default location and a size of 40Gb (like I said above). Click next.

    Virtual Hard Disk Location and Size

    Virtual Hard Disk Location and Size

    Finally check the summary. Click Create.

    Virtual hard disk settings summary

    Virtual hard disk settings summary

    And now we wait.

    Creating the virtual hard disk

    Creating the virtual hard disk

Step 3 Installing Windows

  1. Mount the Windows ISO that you’ve downloaded with the mounting software, with Virtual Clone drive you can right click the ISO and assign a driveletter to it (in my case drive letter F:).
  2. In VirtualBox double click your newly created image. The first run wizard will start. The wizard will ask you which drive letter holds the installation media, pick the drive letter used in step 1. Click next.

    Installation media drive letter

    Choose the installation media drive letter

  3.  The wizard will restart VirtualBox and if all has gone well the Windows Installer will take over, from here on some screenshots showing you the choices I’ve made.
    Installing Windows Step 1

    Installing Windows Step 1

    Installing Windows Step 2

    Installing Windows Step 2

    Installing Windows Step 3

    Installing Windows Step 3

    Installing Windows Step 4

    Installing Windows Step 4

    Installing Windows Step 5

    Installing Windows Step 5

Ok, now after the system restarted, we’re asked to create a new password, check and install critical updates after that  we’re done with Windows for now.

Step 4 Installing the Guest Additions to share the install files

Now we need the other software and it’s not in ISO format, no worries, if we install the VirtualBox guest additions we can add folders from our host operating system and share them as network shares.

To install the guest additions, click the devices menu in the top grey bar of your running virtual image.

VirtualBox guest additions

VirtualBox guest additions

Now the autoplay feature will start:

Guest Additions autoplay

Guest Additions autoplay

Choose “Install or run program from your media”, then choose next, next, install and then reboot.

When done, in the same “Devices” menu, choose “Shared Folders”.

Add Shared Folders

Add Shared Folders

Click the little folder with the plus, on the right side of the screen, it will open the “share folder” dialog.

Add Share

Add Share

If you want to make sure that shares are permanent and don’t disappear after a system shutdown, check “Make Permanent”.

For “folder path” choose the folder into which you put all the downloaded files (SharePoint, SQL /Server 2008 etc.) and click ok.

The install files can now be found by choosing Network in the Start menu. Click on the yellow bar in the top of the window to turn Network Sharing and Discovery on. When that’s done, have some patience, the share VBoxSvr will appear, it contains the downloaded software.

Step 5 Renaming the Server

Before we install anything it might be a good idea to rename our server. Go to start, right click computer, choose properties, somewhere in the center of the screen, choose “change settings”. In the popup choose “change”, in the popup that now appears you can change the computer name, I changed it to “SPTest”. To make these changes final, reboot the virtual image.

Step 6 Activating the domain controller role

  1. From Start -> Administrative Tools, open “Server Manager”, in the treeview on the left, right click Roles. In the center screen click “Add Roles”. Click next.

    Add A Role

    Add A Role

  2. Now we select the Active Directory Domain Services role. Check the box and click “Next”. Click “Next” again and click “Install”.

    Select Server Roles

    Select Server Roles

  3. Click “Close”, we’re almost done, now we run DCPromo. In Start, in the search box type “DCPromo and press return.
  4. Click next until you reach a screen that lets you choose a deployment configuration, we choose “a new domain in a new forest”. Click “Next”.

    AD Deployment Configuration

    AD Deployment Configuration

  5. In the next step we need to choose a fully qualified name, I chose “domain.local”. Click “Next”.

    Choosing a fully qualified name

    Choosing a fully qualified name

  6. Now we have to choose a functional level, I chose “Windows Server 2008 R2″, it has the most features but does not integrate with lower versioned domain controllers, I chose this because I don’t know what I want to do in the future while testing and trying out. As I am not planning to integrate with other domain controllers there are no downsides to this choice. Click “Next”.

    Domain Controller Functional Level

    Domain Controller Functional Level

  7. Now we have to choose additional domain controller options, DNS is default for a new forest and a new domain controller. So click “Next” ignore the warning by clicking ”Yes” for the popup.

    Additional Domain Controller Options

    Additional Domain Controller Options

  8. In the next screen, keep the default settings. Click “Next”.

    Domain Controller Files Locations

    Domain Controller Files Locations

  9. Now we have to choose an Restore Mode Administrator account password, the instructions say it has to be different than the standard administrator account, as this is a test setup I’m going for the same as I used for the server, just to keep it simple and not having to keep track of all kinds of different passwords. Fill in the password and click “Next”.

    Restore Mode Administrator Account

    Restore Mode Administrator Account

  10. Now we get a summary screen, check you settings and if satisfied, click “Next”.
  11. Now the Installation will start and when finished we have to restart.

Step 7 Installing SQL Server 2008 R2

  1. From the VBoxSvr share, rightclick “SQLEXPRWT_x64_ENU.exe” and choose “run as administrator” it will extract some installation file. The .Net Core role needs to be enabled so click ok.
    DotNet Core Role

    .Net Core Role

    Be patient, the installation screen of SQL 2008 will pop up in a short while.

  2.  Choose “New installation or add features to an existing installation.”
    Installation Screen SQL 2008

    Installation Screen SQL 2008

    Accept the terms and click next.

  3. From here on some screens of the choices I made
    Installing SQL 2008 Step 1

    Installing SQL 2008 Step 1

    SQL2008 Step 2

    Installing SQL 2008 Step 2

    Installing SQL 2008 Step 3

    Installing SQL 2008 Step 3

    SQL 2008 Step 4

    Installing SQL 2008 Step 4

    SQL 2008 Installation finished

    SQL 2008 Installation finished

  4. When finished it might be a good idea to check for updates. Install any updates found.

Step 8 Installing SharePoint Foundation

  1. From the share we created earlier, start SharePointFoundation.exe, the Install screen will appear, choose “Install software prerequisites”It will install and configure these:
    • Application Server Role, Web Server (IIS) Role.
    • Microsoft SQL Server 2008 Native Client.
    • Windows Identity Foundation.
    • Microsoft Sync Framework Runtime v1.0 (x64).
    • Microsoft Chart Controls for Microsoft .NET Framework 3.5.
    • Microsoft Filter Pack 2.0.
    • Microsoft SQL Server 2008 Analysis Services ADOMD.NET.
    • Microsoft Server Speech Platform Runtime (x64).
    • Microsoft Server Speech Recognition Language – TELE(en-US).
    • SQL 2008 R2 Reporting Services SharePoint 2010 Add-in.
  2. Check for updates again. Little note on the updates, some may take a while and by a while I mean you might be wondering if things are still running. Again be patient, feel free to do something else while waiting, e.g. watch an episode of the Big Bang Theory while updating. Another note, be aware of any pop up windows that don’t pop up, they might need some attention for the updates to continue.
  3. After updating the final steps, start the SharePointFoundation.exe from the share again. Now we choose “Install SharePoint Foundation” Accept the license agreement.
  4. In the next screen we are going for a farm installation and not a stand alone installation, I am doing this for educationla purposes, the difference I found on the web:
    Standalone Installation :
    ·         SQL Server 2008 Express Edition is the database type automatically installed (instead of Windows Internal Database/SQL Server 2005 Embedded Edition used in Windows SharePoint Services 3.0).
    ·         This is almost a “one-click” installation, no questions are asked during setup or during Post Setup Configuration Wizard (PSConfig)
    ·         A Web application and team site collection are automatically created in the newly created farm. The search service is started automatically.
    ·         Cannot add servers to join a farm.
    ·         When the installation is complete, the browser opens taking you to a newly created site collection.
    ·         Installer is not prompted for farm passphrase, it is automatically generated.
    Server
    ·         SQL Server 2005 SP2/SQL Server 2008 is the database type, not installed by setup.
    ·         Administrator can pick whether or not to create a site and the site template to use.

    ·         Prompted for farm passphrase during PSConfig phase of installation.

    Click “Server Farm”

    Stand Alone Farm installation

    We choose a farm installation

  5. In the next step we choose “Complete” for educational purposes. I chose not to change the location. Click “Install Now”. Here we go!!

    Choosing a Server type

    Choosing a Server type

  6. Once we’re done installing we continue with the configuration, Keep the “Run the SharePoint Products configuration wizard now” box checked and click “Close”.

    Run Configuration Wizard

    Run Configuration Wizard

  7. For the next steps be sure to have the SQL Server name ready, you’ll also need the admin account, but that’s the account you’re currently logged into (if you followed the steps during the SQL installation. Click “Next” and then “Yes”.

    The Configuration Wizard

    The Configuration Wizard

  8. Connect to a server farm: choose “Create a new server farm” click “Next”.

    Connect To A Server Farm

    Connect To A Server Farm

  9. Now we have to specify the database configuration: Server name: SQLExpress, Login and password: same as you log on to the server with. Which is Domain\administrator since we installed the domain controller. (if you have any problems, make sure SQL server is up and running using the Click “Next”.

    Specify Database Configuration

    Specify Database Configuration

  10. Create a passphrase, I used the same as I did for the server, again, this is not best practice but in this situation very practical. Click “Next”.
  11. Configure the Central Admin web application, keep the default settings and click “Next”.

    Configure Central Admin web application

    Configure Central Admin web application

  12. Next step is completing the installation, take notion of this summary, it gives you important information like what the name is of the SharePoint site and the Central admin site. Click “Next”.

    Completing the wizard SharePoint Foundation

    Completing the wizard SharePoint Foundation

  13. And we’re done!! Take note of the information in the window, and click “Finish”.

    Finished SharePoint Foundation Installation

    Finished SharePoint Foundation Installation

Step 8 The final step, configuring the server

  1. Creating a managed account, I chose the same account as with earlier steps, just to keep it simple. Click “Next”.

    Create a managed account

    Create a managed account

  2. Creating a top level site, click “Next”.

    Creating a top level website

    Creating a top level website

  3. The wizard summary, click “Finish”.

    Wizard summary

    Wizard summary

And we’re finally done. Here is what we all did it for:

HowTo: Create and Delete a SharePoint list

Audience

This post is for SharePoint beginners. One of the core elements of SharePoint is the list. A list in SharePoint is like a table in a database or a sheet in Excel. So basically any data you want to store in SharePoint you store in lists. Lists can be created using a template which give you predefined columns and list settings or you can design a list by creating a custom list.

Steps to create a list:

  1. Navigate to the site on which you want to create the new list (you must be in the right role to do this e.g. “site owner”).
  2. Click “Site Actions” in the upper left corner.
  3. Choose “More options”
  4. The “Create” screen appears.

    Create Screen SharePoint 2010

    HowTo Create a List

  5. In the “Filter By” menu select “list”.
  6. Choose the template that fits your needs.
  7. On the right hand side of the screen, type a name that describes the list and click “create”.
Alternative route:
Replace step 2 in the above instructions by clicking “Lists” in the Quickstart menu on the left of your site. You’ll get an overview of all the existing lists. In the upper left corner of this screen there is a “create button” this will also open the Create menu.
 
Congrats, you’ve just created a list. The list can now be found in the Quickstart menu on the left of your site.
 
Ok, so we’ve created a list, the next step is to delete a list. Deleting a list might not be something you will be doing on a daily basis but when you are learning SharePoint it can be a handy little thing to know as you’ll probably be adding several lists for testing purposes.
 

Steps to delete a list:

  1. Navigate to the site on which hosts the list which you want to delete (you must be in the right role to do this e.g. “site owner”).
  2. In the Quickstart menu (on the left of your site) click on the listname of the list you want to delete.
  3. By clicking the list in step two the Ribbon contect menu called “List Tools” wille be displayed (make sure the “List” option is selected, in the dark blue bar in the top of your window)

    Ribbon List Tools context menu

    Ribbon

  4. In the Ribbon choose “List Settings” this opens the list settings menu.
  5. The list settings menu shows a lot of properties and options, choose “delete this list” in the “permissions and management” category (located somewhere in the center of your screen).

    List Settings Deleting a list

    List Settings Deleting a list

  6. Confirm that you want to “move the list to the recycle bin” which, of course, sends the list to the recycle bin.
The recycle bin is very much like the recycle bin in Windows, it holds all your deleted items, it is located in the Quickstart menu, clicking on it gives you the option so recover deleted items or permanently delete them.
 

SharePoint versions 

  • SharePoint 2010 Foundation
  • SharePoint 2010 Standard Edition
  • SharePoint 2010 Enterprise Edition
  • SharePoint 2010 Online (Office 365 Edition)

Permission level

  • Design
  • Full Control
 
This concludes this HowTo. for now Happy SharePointing, live long and prosper.