Archive

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

Steps

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

Image

.

Local Users and Groups -> Groups -> Administrators

Image

Image

OK

.

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

share1

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

share2

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

share3

Click connect with default options

share4

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

share5

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

dbcreator

security admin

Then click OK.

Close the window.

 

Step 5

SharePoint Pre-requisites

share6

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.

share7

Choose Server Farm.

share8

Choose complete installation

share9

Click Close

Step 7

SharePoint 2010 Configuration Wizard

share10

Next -> Yes

Choose Create a new server farm and Click Next

share11

Provide your database server name and credentials

share12

Provide Password for your Farm

share13

Specify Port Number for your access.

Next -> Next.

Click Finish.

share14

Then it automatically start Central Administration portal in a browser

Click Ok.

Choose “No I will configure everything myself”

share15

It shows you the SharePoint Administration options

🙂

 

 

Advertisements

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. 🙂

microsoft.net 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 microsoft.net framework SP2 it will show microsoft.net 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

http://www.microsoft.com/en-us/download/confirmation.aspx?id=22

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

<% #if SOME_UNDEFINED_CONSTANT %>
<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();
}
</script>

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
http://www.4shared.com/document/OO-v3qsg/MicrosoftAjax.html

done; try..

Image

happy coding 🙂

Categories: SharePoint 2010

Could not load type ‘System.Data.Services.Providers.IDataServiceUpdateProvider’ from assembly ‘System.Data.Services, Version=3.5.0.0, 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=3.5.0.0, 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

http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=2343

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

go and install

http://www.microsoft.com/en-us/download/details.aspx?id=5121

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