Archive for the ‘SharePoint 2010’ Category

Setup SharePoint Server in Windows Server 2008

December 15, 2012 Leave a comment

You need the following software to set up a SharePoint server

1. Windows Server 2008 64 bit Operating System

2. SQL Server 2008 R2 64 bit

3. SharePoint Server or SharePoint Foundation


Hope you are in Windows Server 2008 Operating System

Step 1: Verify that the setup administrator(probably current user) is in the local administrator group

start -> Administrative Tools -> Computer Management



Local Users and Groups -> Groups -> Administrators





Step 2 : Roles and role service configuration


Check these options : Application Server and Web Server ; click Next


Check these option -> Web Server, Windows Process Activation Service Support, TCP Port Sharing;  click Next


Click Next


Check these options : Server side includes, CGI, ASP, IIS 6 Management Compatability ; Click Next


Click Install


Click Close

Step 3

SQL Server 2008 or SQL Server Express 2008 Installation

Double click the setup file to start installation

Click Installation -> New Installation or add features to an existing installation

Click OK

Then Select the version option -> Express or Evaluation

Click Next

Click Install

Click Next

Select SQL Server Feature Installation -> Click Next

Select features -> Database Engine Services, Management Tools – Basic

Click Next -> Next

Click Default Instance -> Click Next  -> Next

Type SQL Server Agent Account Name and SQL Server Database Engine Account Name  and Password . (Put username as Administrator and its password in Password field)

Click Next

Click the button “Add Current User” to specify sql server administrator

Click Next -> Next -> Install

Step 4

4. SQL Server 2008 Configuration


Click -> Programs -> Microsoft SQL Server 2008 -> SQL Server Configuration Manager


Go Protocols for MSSQLSERVER -> Right Click TCP/IP -> Enable

Then Double click SQL ServerServices from the left pane and Restart SQL Server(MSSQLSERVER).

After that close the window.


Go to Programs -> Microsoft SQL Server 2008 -> SQL Server Management Studio


Click connect with default options


From the left pane , Click Security -> Logins -> Right Click the sharepoint user added before. -> Properties


From left pane, click  Server Roles and add the following roles.


security admin

Then click OK.

Close the window.


Step 5

SharePoint Pre-requisites


Run Pre-requisites from the SharePoint installation media. Or you can see the option when you run the SharePoint Foundation setup as “Install Pre-requisites”.

Step 6

SharePoint 2010 Installation

Install SharePoint Foundation by running the setup.


Choose Server Farm.


Choose complete installation


Click Close

Step 7

SharePoint 2010 Configuration Wizard


Next -> Yes

Choose Create a new server farm and Click Next


Provide your database server name and credentials


Provide Password for your Farm


Specify Port Number for your access.

Next -> Next.

Click Finish.


Then it automatically start Central Administration portal in a browser

Click Ok.

Choose “No I will configure everything myself”


It shows you the SharePoint Administration options




How to copy a List SharePoint 2010

October 1, 2012 Leave a comment

You can save  a List as Template to Copy its structure and content to a New List.

To do this, follow these steps

1.Select the List and Click List Settings in the List Tab.

2. Click “Save list as template” under the section “Permission and Management”

3. Enter the file name and template name. Click check box “Include Content” if you want to include both Structure and content.

4.  Click Ok.

5. To make the new list copy. Go Site Actions -> More Options, you can see the created list template under Custom List

6. Click it,  name the new list and click Create

You just created a new copy of a List using its Template. 🙂 framework 2.0 sp2 is required for SQL Server 2008 installation in Windows Server 2008 64 bit

August 12, 2012 1 comment

I  spent some time to get it done. When you download and install framework SP2 it will show framework SP1 is required. If you installed sp1  it won’t work i think (i didn’t get it) .

To solve the issue

download and install

need internet connection to get it installed.

Now you can install SQL Server 2008 without any problem


wow.. Client Object Model IntelliSense SharePoint in Visual Studio 2010

July 24, 2012 Leave a comment

I got it.
Put this code inside your visual web part

<script type=”text/javascript” src=”/_layouts/MicrosoftAjax.js” ></script>
<script type=”text/javascript” src=”/_layouts/SP.debug.js”></script>
<% #endif %>

<script type=”text/javascript” language=”javascript”>
ExecuteOrDelayUntilScriptLoaded(test, “sp.js”);

function test() {
this.ClientContext = SPClientContext.get_current();

if you have no MicrosoftAjax.js in your Layout folder (C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\TEMPLATE\LAYOUTS\)
download it from here

done; try..


happy coding 🙂

Categories: SharePoint 2010

Could not load type ‘System.Data.Services.Providers.IDataServiceUpdateProvider’ from assembly ‘System.Data.Services, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089′

July 23, 2012 Leave a comment

While accessing REST service of SharePoint from browser, you may get error as

Could not load type ‘System.Data.Services.Providers.IDataServiceUpdateProvider’ from assembly ‘System.Data.Services, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089′

To fix this issue,  install ADO.NET Data Services Update for .NET Framework 3.5 SP1 for Windows 7 and Windows Server 2008.

For Windows7 and Windows Server 2008 R2

go and install

For Windows 2000, Windows Server 2003, Windows XP, Windows Vista and Windows Server 2008

go and install

Categories: SharePoint 2010

How to set Title of Document Library as mandatory SharePoint 2010

July 20, 2012 Leave a comment

Do the following..
1. Go to Document Library Settings
2. Click Advanced Settings
3. Select ‘Yes’ for the option ‘Do you want to manage the content types ?’ and Save
4. Click on ‘Document’ link under Content Types section
5. You can see all columns
6. Click on ‘Title’ and now you can make it required field.
7. Save the changes

Categories: SharePoint 2010

The service is unavailable SharePoint 2010

July 19, 2012 Leave a comment

If you change the password (due to password expiration) of Windows Server 2008. And then try to access SharePoint administration site, you will get a message

The service is unavailable

To resolve this you have to set new password in SharePoint Application pools in IIS Configuration Manager

Right button SharePoint Administration -> Advanced settings

Browse Identity

Click Set and provide new credentials

Click OK.

Try to access SharePoint administration site. You may get another error

Cannot connect to Configuration Database

To resolve this issue you have to set new administrator credentials for MSSQL service too

Click Start -> All Programs -> Administrative Tools ->  Services

Goto SQL Server (MSSQLSERVER) -> Right Button -> Properties

Change the password to new password

Click OK.. and restart the service

Restart IIS.

Access SharePoint administration site, hope all works fine.

If you want to disable password expiration in Windows Server 2008 (not recommended) . do following steps.

If you are a local user

Go to Start -> All Programs -> Administrative Tools -> Local Security and Policy

Account Policies -> Password Policy -> Set Maximum Password Age to zero

Done 🙂

If you are a domain user.. above technique will not work. Do the following

Go Start -> Administrative tools -> Group Policy Management

Right Click on the default domain -> click Edit

Select Policies -> Window Settings -> Security Settings -> Password Policy

Set Maximum Password age to zero

Click OK

Done 🙂

Categories: SharePoint 2010