Tuesday, December 14, 2010

How to change service accounts and service account passwords in SharePoint Server 2007

This section describes how to change the passwords for service accounts in Microsoft Office SharePoint Server 2007 and in Microsoft Windows SharePoint Services 3.0.To change the passwords for service accounts in SharePoint Server 2007 and in Windows SharePoint Services 3.0, follow these steps.Note If the SQL Server service uses a domain account, and the password for that domain account is either expired or invalid, make sure that you update the password for the domain account before you perform this procedure.
1.Update the password for the account that is used by the Central Administration application pool. To do this, follow these steps: a. On all servers in the server farm, open a command prompt, type the following line, and then press ENTER:
cd %commonprogramfiles%\Microsoft Shared\Web server extensions\12\Bin


b. On the server that hosts the Central Administration Web site, type the following line at the command prompt, and then press ENTER:
stsadm -o updatefarmcredentials -userlogin Domain Name\UserName -password NewPassword

c. On all other servers in the server farm, type the following line at the command prompt, and then press ENTER:
stsadm -o updatefarmcredentials -userlogin DomainName\UserName -password NewPassword -local
d. Restart Microsoft Internet Information Services (IIS) 6.0. To do this, type “iisreset /noforce” at the command prompt, and then press ENTER

2. Verify that the Administration Application Pool Credential Deployment job definition is no longer displayed on the Timer Job Definitions page of SharePoint 3.0 Central Administration. To do this, follow these steps: a. Open SharePoint 3.0 Central Administration, click Operations, and then click Timer job definitions under Global Configuration.
b. Verify that the Administration Application Pool Credential Deployment job definition is no longer displayed in the list. Note If the Administration Application Pool Credential Deployment job definition is displayed in the list, wait until it disappears from the list.
3. Update the password for the application pool account that is used by Web applications on the server farm. To do this, type the following line at a command prompt on every server on the server farm, and then press ENTER:
stsadm -o updateaccountpassword -userlogin DomainName\UserName -password NewPassword -noadmin
4. Update the password for the account that is used to run the Windows SharePoint Services Help Search service. To do this, type the following line at a command prompt on every server on the server farm, and then press ENTER:
stsadm.exe -o spsearch -farmserviceaccount DomainName\UserName -farmservicepassword NewPassword
5. Update the password for the default content access account that is used by the Windows SharePoint Services Help Search service. To do this, type the following line at a command prompt on every server on the server farm, and then press ENTER:
stsadm.exe -o spsearch -farmcontentaccessaccount DomainName\UserName -farmcontentaccesspassword NewPassword
6. If you are running SharePoint Server 2007, you must also follow these steps:
a. Update the password for the account that is used by every Shared Services Provider (SSP) on the server farm. To do this, type the following line at a command prompt on every server on the server farm, and then press ENTER:
stsadm.exe -o editssp -title SharedServicesProviderName -ssplogin DomainName\UserName -ssppassword NewPassword

b. Update the password for the account that is used to run the Office SharePoint Server Search service. To do this, type the following line at the command prompt, and then press ENTER:
stsadm.exe -o osearch -farmserviceaccount Domain Name\Usernames -farmservicepassword NewPassword

c. If the server farm is configured to use single sign-on, update the password for the account that is used by the Microsoft Single Sign-On Service. To do this, follow these steps:
1.
Click Operations in SharePoint 3.0 Central Administration, and then click Service accounts under Security Configuration.
2.Under Windows service, click Single Sign-On Service.

3. Under Configurable, specify the password, and then click OK.

d. Update the password for the default content access account that is used by the Office SharePoint Server Search service. To do this, follow these steps:

1. Open SharePoint 3.0 Central Administration, and then click the link to the SSP Web application under Shared Services Administration.

2.Under Search, click Search settings, and then click Default content access account.

3.Specify the password to use for the content access account, and then click OK.

CAML vs LINQ

LINQ
The LINQ to SharePoint project provides a custom query provider for LINQ that allows to query SharePoint lists using familiar LINQ syntax. LINQ stands for Language Integrated Query and is one of the core features of Microsoft's .NET Framework 3.5 release. Features :
Custom query provider that translates LINQ queries to CAML, the Collaborative Application Markup Language used by SharePoint for querying.
· Support for LINQ in C# 3.0 +
· Entity creation tool SpMetal to export SharePoint list definitions to entity classes used for querying.
· Visual Studio 2008 integration for entity creation (a.k.a. SPML).
· Can connect to a SharePoint site either using the SharePoint object model or via the SharePoint web services.
· Planned support for updating through entity types.
Advantage
· Fast data Retrieval
· Can write SQL like queries
· Return xml output, thus can be used to retrieve relational (parent-child)data.
Disadvantage:
· Cannot use LINQ in client object Modal. It runs on server only.
· It’s converts the LINQ query into CAML therefore, adding an extra step from data retrieval

CAML
Collaborative Application Markup Language (CAML) is the XML-based language that is used to build and customize Web sites based on SharePoint Team Services from Microsoft.
CAML can be used to do the following:
· Provide schema definition to the Web site provisioning system about how the site looks and acts.
· Define views and forms for data and page rendering or execution.
· Act as a rendering language that performs functions in the DLL like pulling a value from a particular field.
· Provide batch functionality for posting multiple commands to the server using protocol.

CAML can be used in various ways to customize a SharePoint site, including the following:
· In script or code that implements members of the SharePoint Foundation object model, where CAML strings are passed through method parameters, assigned to properties, or returned by methods and properties
· In SOAP messaging that passes CAML strings to a SharePoint Foundation Web service to interact remotely with a deployment
· In front-end site definitions used to instantiate SharePoint sites
· In SharePoint Foundation Features to add specific functionality within a particular scope
· Advantages
· Avoids hand-editing of literal XML strings in your code.
· Eliminates query failures caused by typos and improper casing of elements and attributes.
· Each query component is processed as a separate statement with strongly-typed parameters.
· Operator and method overloading greatly simplifies the raw CAML schema.
· Enables the use of variables instead of literal text to specify query components.
· Visual Studio intelligence support while writing queries.
· Simplifies the construction of reusable CAML component libraries.
· Supports automatic data-binding to any .Net class or data structure.
CAML vs. LINQ
1. The principal advantages of CAML queries are that there may be a performance advantage because there is no need to translate the query from LINQ syntax to CAML syntax.
2. The principal advantages of using LINQ queries include:
· You can use LINQ syntax and the LINQ keywords built into C# and Microsoft Visual Basic. By contrast, CAML XML is error prone and applicable only to SharePoint Foundation.
· With the LINQ to SharePoint provider, you are working with strongly typed list item objects.

For Information please refer the following links:
http://msdn.microsoft.com/en-us/library/ms426449.aspx
http://msdn.microsoft.com/en-us/library/ee536691.aspx