Thursday, April 5, 2012

Cannot connect to the configuration database in SharePoint 2010

Yesterday I ran into one issue Cannot connect to the configuration database in SharePoint 2010.

Verified all the services in the App server.
Even unable to open the Central Admin Page also.

Issue:
Error from the Browser : Cannot connect to the configuration database.

Error from EventViewer:
 
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server).

Resolution:


I.  Verified that the SQL database service is running in the Sqlserver
  1. Click Start, point to Programs, point to Administrative Tools, and then click Services.
  2. In the list of services, locate the MSSQLSERVER service. This service may also be listed as MSSQL$SHAREPOINT.
  3. Note the value of the Status column. If the Status column lists Started, the database server is running. If the Status column is empty, the database server is not running.

    To start the database server, right-click the MSSQLSERVER service, and then click Start

II.  verify that the account that is used by the application pool is the account that has the required permissions to the SQL Server database.I.e. Please verify these two accounts Domain\AdminAccnt and Domain\AdminAccntApppool have     enough permission level to access the SharePoint content Databases. 


Root Cause :  A disk resource failure on the Sql Box and Clustered disk resource was in failed state.


Reference:http://support.microsoft.com/kb/823287/en-us



Tuesday, April 3, 2012

SharePoint Managed Paths


Came through some of the good articles on SharePoint Managed Paths:
Source: http://sharepoint.microsoft.com/Blogs/zach/Lists/Posts/Post.aspx?ID=30
http://technet.microsoft.com/en-us/library/cc288905.aspx

The advantage of multiple managed paths is it's a first piece of metadata you can have in your farm. It helps break sites out into logical trees even thought they all reside in the same farm. This becomes very beneficial if you organize your structure very flat (many site collection) •SPWeb: These are referred to in SharePoint UI as a "Site". SPWeb's are a collection of user data (lists, library, docs, pages, etc.) in a database. An SPWeb belongs to one, and only one, SPSite.

•SPSite: These are referred to in SharePoint UI as a "Site Collection". SPSites are a grouping of SPWebs that all share the same root URL. The SPWeb that lives at the root url of an SPSite is called the "Root Web". SPSites have settings, but do not contain user data.
SPSites have one very important feature—all SPWebs in an SPSite must be stored in the same Content Database. This is key to how we figure out what database user data is stored in.

Now, on to managed paths! When user types in a URL into their browser—the root domain is directed through DNS to a SharePoint Server (this is the easy part!). Once SharePoint gets a URL, how does it now what data to look up?! Let's take the following url: http://www.foo.com/sites/foo/bar/foobar. The first thing to note is that we know that the user's data (provided he typed a valid URL in) is in an SPWeb somewhere… But where? First we need to figure out the 'containing' SPSite so we know what database to look at—but which part of the URL gives us the address of the SPSite? /sites? /? /sites/foo/bar? This is where Managed Paths play their role.

SPSites are limited to being created only where a managed path is defined! For example, "(root)" is one of the default managed paths you see when creating a new web application in SharePoint (visit Central Administration -> Application Management -> Define Managed Paths). This means you can create one site collection at the root of the web app—in our example, this means you can have a site collection at http://foo.com. This is an explicit managed path as it means you can create only one site collection at the exact location specified.

Another default managed path you see is "sites"—which is a wildcard managed path. This allows for unlimited number of site collections to be created directly under the provided path (it is important to note that a site collection, and thus an SPWeb, cannot be created at this explicit url). This means I can create site collection (and only SPSites, not SPWebs) directly under this url (http://foo/sites/foo). This means that any additional path in the given URL is an spweb (created from the root web of this spsite). So in our example, we can split the incoming URL into four pieces to quickly look up the information:

"http://ww.foo.com" + "/Sites" + "/Foo" + "/bar/foobar"
(Web Application) + (managed path) + (SPSite) + (Web/SubWeb)

Whenever a URL is 'received' by SharePoint, the site collection is determined by looking at the list of managed paths for a given Web Application. This means SharePoint has to look at every managed path so try to limit the number of managed paths (<20 is highly recommended). SharePoint always matches the longest pattern possible—we'll look at a more complicated example to explain the reason. Using the following managed paths:

•10 (explicit)
•10/teams (wildcard)
•10/howto (explicit)
•10/howto/misc (wildcard)
How do we map out URLs? Site Collections (SPSites) urls are highlighted in Bold:
•http://foo.com/10/teams/sites/bar
•http://foo.com/10/myteam/sites/bar
•http://foo.com/10/howto/team1/foo
•http://foo.com/10/howto/misc/team1/foo/bar
•http://foo.com/10/howto/misc/team2/foo
The key item to note is in the last three example URLs—notice that the longest managed path (10/howto/misc) takes precedence over the shorter (10/howto). Hopefully this clears up Managed Paths! I'll end by summarizing:

•Managed Paths allow SharePoint to determine what portion of a given URL corresponds to the "site collection URL".
•Managed Paths can be defined per web application (and cannot be defined for host header site collections)
•Managed Paths can be "Explicit" or "Wildcard"
•Explicit Managed Paths allow a single spsite to be created at exactly the given url
•Wildcard Manage Paths allow unlimited spsites to be created under the given url – no spsite can be created at exactly that URL.
•Limit your managed paths to <20 per web application

 Define managed paths for a Web application by using Central Administration
 Define managed paths for a Web application by using Windows Powershell Define managed paths for a Web application by using Central Administration Use the procedures described here to add or delete managed paths for a Web application by using Central Administration. To add a managed path by using Central Administration
 1.Verify that the user account that is performing this task is a member of the Farm Administrators SharePoint group.
 2.On the SharePoint Central Administration Web site, click Application Management.
 3.On the Application Management page, click Manage Web Applications
.4.Click the Web application for which you want to manage paths. The ribbon becomes active.
 5.On the ribbon, click Managed Paths.
 6.On the Define Managed Paths page, in the Add a New Path section, type the path to include.
 7.Click Check URL to confirm the path name.
 8.Use the Type dropdown menu to identify the path as either Wildcard inclusion or Explicit inclusion. The Wildcard inclusion type includes all paths that are subordinate to the specified path. The Explicit inclusion type includes only the site that is indicated by the specified path. Sites subordinate to the specified path are not included.
9.Click Add Path.
10.When you have finished adding paths, click OK.

 To remove a managed path by using Central Administration:
1.Verify that the user account that is performing this task is a member of the Farm Administrators SharePoint group.
2.On the SharePoint Central Administration Web site, click Application Management.
3.On the Application Management page, click Manage Web Applications.
4.Click the Web application for which you want to manage paths. The ribbon becomes active.
5.On the ribbon, click Managed Paths.
6.On the Define Managed Paths page, in the Included Paths section, click the check box next to the path that you want to remove.
 7.Click Delete selected paths.
Warning: Be sure that you want to remove the selected path before performing this action. You will have no additional opportunity to confirm. Deletion is immediate.

 8.When you have finished removing paths, click OK.
Define managed paths for a Web application by using Windows Powershell You can use the New-SPManagedPath cmdlet to add managed paths for a Web application.
You can use the Remove-SPManagedPath cmdlet to remove managed paths from a Web application. The New-SPManagedPath cmdlet adds a new managed path to a given Web application or for use with all host header site collections
. If the HostHeader switch is provided, the managed path is shared among all host header site collections; otherwise, you must specify a Web application in which to create this managed path. The relative URL is a partial URL that represents the managed path. When the slash mark (/) is used, the root is defined. If the Explicit parameter is not provided, the new managed path is a wildcard path.
To add a managed path by using Windows PowerShell
1.Verify that you meet the following minimum requirements: See Add-SPShellAdmin.
 2.On the Start menu, click All Programs.
3.Click Microsoft SharePoint 2010 Products.
4.Click SharePoint 2010 Management Shell.
5.At the Windows PowerShell command prompt, type the following command: Copy New-SPManagedPath [-RelativeURL] "" -WebApplication  
Where: is the relative URL for the new managed path. The type must be a valid partial URL, such as site or sites/teams/. is the Web application group to add this path. For more information, see New-SPManagedPath. 

To remove a managed path by using Windows PowerShell 

1.Verify that you meet the following minimum requirements: See Add-SPShellAdmin. 
 2.On the Start menu, click All Programs. 
 3.Click Microsoft SharePoint 2010 Products.
 4.Click SharePoint 2010 Management Shell. 
5.At the Windows PowerShell command prompt, type the following command:. Copy
 Remove-SPManagedPath [-Identity] -WebApplication  
Where: is the name of the managed path to delete. is the identity of the Web application that hosts the managed path to delete.

 You are prompted to confirm the deletion. For more information, see Remove-SPManagedPath. We recommend that you use Windows PowerShell when performing command-line administrative tasks. The Stsadm command-line tool has been deprecated, but is included to support compatibility with previous product versions.

Monday, April 2, 2012

CONTRIBUTOR Access not behaving correctly in SharePoint 2010

Issue:

People who have only Full Control access can able to see the Site Actions Tab in the SharePoint web Application.
people who have Contribute access are unable to see the Site Action Tab with Edit Page options completely but where they should have to see and Modify/update the Pages with help of Edit Page option under Site Actions.

Resolution:

In SP WEB APP master page, Sharepoint Trimmed control has implemented to view the Site Actions Tab for only people who have access Full Control.

Changed the SharePoint Trimmed control permission to view the Site Action Tab  even  people who have permission as a Contributor.

Updated the  SharePoint Trimmed Control permission string with AddAndCustomizePages in the Master Pages.

And it started appearing with Edit Page option under Site Actions.

References:

SharePoint Administrator Job description

Who is a SharePoint Administrator and what do they do?
SharePoint administrations are those who control all the functions of the organization and deal with the hundreds of functions. For the security the SharePoint administration give security codes to the organization in order to keep the documents and activities confidential.  They also decide the policy for the SharePoint settings and management. Generally the SharePoint administration allows the members of the organization to search, view and manage the various documents.

Following are the roles and responsibilities of the SharePoint administration in the SharePoint administration job description.

  • SharePoint administrator play three important roles in any organization like SharePoint Administrator and SharePoint Architect and SharePoint developer,
  • These are the three main responsibilities that the SharePoint administrators have to deal with.
  • To develop a project for various activities.
  • Decide the hardware and software for various programs.
  • This is the responsibility of the SharePoint administration to run the project on time.
  • Decide the budget for the setup of the software.
  • Play a role of business and project analyst and guide the other members of the organization about the software and the processes.
  • Set up the SharePoint on various sites and make these sites publish readable content to others also.
  • Develop the SharePoint infrastructure and serve the service to the customers of the organization and to the staff.

Credentials and Abilities required

What are the essential requirements for a SharePoint Administrator?

Qualification:

  • The qualifications for a SharePoint administrator sometimes depend upon the organization and the roles and responsibility.
  • The location, i.e. that is the policy of the country for specialized profession also is a criterion.
Even the basic required in terms of qualification that the SharePoint administrator should have are:
  • Should have the certificate of various software programs like Linux, data base administrator.
  • Should have the certificate about the installation and configuration and maintains of the hardware and software of the systems.
  • Certificate of various computer language like SQL, PHP, trouble shoot CMS, UNIX.
  • Diploma in management along with the course in information technology

Or

  • Degree that is four years of bachelor degree in the equivalent field.

Experience: The candidate who wants to become SharePoint administrator should have the experience in the related field.
Skills required by this Share Point Administrator:

General Skills Required:

Along with the basic requirement of certificate courses and experience and any degree, the SharePoint administrator should have the following skills:

1.    Expert knowledge about computers, hardware and software.
2.    He or she should have strong analytical and problem solving skills.
3.    Ability to assist the clients and the staff of the organization.
4.    Ability to install, configure and design the systems.
5.    Should have knowledge about technology.
6.    In-depth knowledge about the Microsoft Office SharePoint latest version.
7.    Should have good command over written, verbal communication and presentation skills.
Professional Growth

What are the job prospects for these share point administrator?

The job prospects for SharePoint administrator is increasing day by day due to increase in the growth of the information technology industry. This is one of the booming sectors and in every IT company the need for a SharePoint administrator is felt. So the candidate has diverse options where he or she can apply for jobs. Most organizations run their business on a large scale and there are more than one office, so in order to maintain all the records of the various branches, the organization has to develop a software. This can maintain all the records at one place and which is accessible to everyone. Thus, the job prospects and the demand for the SharePoint administrators are great.

Reference: http://onlyjobdescriptions.com/jobdescription/sharepoint-administrator
SharePoint2010 Sample Tasks and useful links :

1>  Excel Services - BI
   -Publishing the Excel to Share Point Server
2> Share Point Designer WF
   -Activating the Workflow in the already existing Items
   -Change to Summary toolbar to FullToolbar
3> Performance Point Server 2010
4> Configuring SSRS
5> Integrating CRM with sp2010
6> Configuring (copying or modifyig) the spDesigner workflow - reusable wf
7> Configuring Chart Webpart
8> Retracting Soution and Deleting solution
9> Configuring CQWP with multiple filtered list Values
    1>http://community.bamboosolutions.com/blogs/bambooteamblog/archive/2010/08/23/bamboo-is-sharepoint-2010-ready-are-you-part-1.aspx
    2> Option 1:
    Can I filter based on a metadata field of the Page ?
    How do I get the value of the metadata field into my Content query webpart ?
    3>http://roxority.com/filterzen/
    4>http://www.endusersharepoint.com/2010/06/07/moss-enterprise-query-string-url-filter-web-parts-ramping-it-up-screencast/
    5>Multiple Columns:Data View webpart
    http://sharepointxperiments.wordpress.com/2009/08/03/multiple-filters-on-a-data-view-webpart/
10> Configuring Power Pivot in share point 2010:
    http://powerpivotgeek.com/server-installation/existing-farm-install/
11> Shading the Webpart BackgrounD colour:
    Add the CSS in  the MasterPage(I.e Link)
    Reference Url: http://www.heathersolomon.com/content/sp07cssreference.htm
12> Make an Item as HyperLink
13> Working with Execel Services in ca100asalemv02
14>Configuring Performance point services and unattendaccount
15>Changing the upload file size














For this issue,Opened a MS ticket and resolved  finally  :) .

Action:
++++++++++++++++++++++++++++++++++++++++++


Unable to add Domain2 users to the SharePoint application server.


Error Message:
+++++++++++++++++++++++++++++++++++++++++++

“User does not exist” or “No match found”


Root Cause:
+++++++++++++++++++++++++++++++++++++++++++


For the MOSS people picker to work we need the below listed ports opened as well as the dynamic RPC ports opened for all the DC’s in DOMAIN1  domain that the  server will talk to and in turn the DOMAIN1 DC’s should be able to communicate with the Domain2 DC’s and resolve SID’s.


The dynamic RPC ports are needed for the end point mapping.


A complete list of ports and protocols required to successfully instantiate and execute a People Picker request are as follows (WFE):


Defining and allocating a range of RPC ports.


How to configure a firewall for domains and trusts

http://support.microsoft.com/default.aspx?scid=kb;EN-US;179442


How to configure RPC dynamic port allocation to work with firewalls

http://support.microsoft.com/kb/154596/


TCP/UDP 135, 137, 138, 139 (RPC)
TCP/UDP 389 by default, customizable (LDAP)
TCP 636 by default, customizable (LDAP SSL)
TCP 3268 (LDAP GC)
TCP 3269 (LDAP GC SSL)
TCP/UDP 53 (DNS)
TCP/UDP 88 (Kerberos)
TCP/UDP 445 (Directory Services)
TCP/UDP 749 (Kerberos-Adm) [Opt.]
TCP port 750 (Kerberos-IV) [Opt.]


Resolution:
++++++++++++++++++++++++++++++++++++++++


The high end RPC dynamic service ports 1024 to 65535 between Domain1 and Domain2 domain controllers were enabled. Once this was done SharePoint automatically started to resolve APAC accounts.

Additional information


How to configure a firewall for domains and trusts

http://support.microsoft.com/default.aspx?scid=kb;EN-US;179442


How to configure RPC dynamic port allocation to work with firewalls

http://support.microsoft.com/kb/154596/

SharePoint 2010 Interview questions

Thought of sharing some of the companies SharePoint2010 Administrator Interview questions.

1>What is an Application Pool

2>Differences between Worker Processe in SP2007 and SP2010

3>How to Deploy 3rd party solutions in the SharePoint Farm

4>Creating/Moving a Site Collection in newContentDB

5>Configuring NTLM

6>Configuring Kerboes

7>Difference between NTLM AND Kerboes

8>Whatis a sand Box Solution

9>Caching techniques in SharePoint

10>what is SCOM(System Centre Operational Manager)?

11>what are the new featues in Backup and Restore in SP2010?

12>What is unattached DB recovery

13>what is Proxy service?

14>Explain the flow to access the SharePoint contentDB in SharePoint

15>what is query server?

16>what is index server>

17>what are different Farm Levels?

18>what is the Change token value in the Content Deployment Jobs?

19>Difference between IIS6.0 and IIS7.0

20>What is performance point service and why it is used for ?


21>what is resource throttling in SP2010?

22>Administrator is getting access denied when he tries to take a back up of the    SiteCollection.

23>Creating a site with already existing Content DB

24>what 403 Page not found?

25>Service unavailable in SharePoint2010

26>New features/advantages in configuring Index server in SharePoint 2010?

27>what is query Component?

28>what is federated search and how you will configure inSharePoint2010?

29>what are all major reasons to load a SharePoint page very very Slowly?

30>what is Machine.config and Web.config and differences?

31>what is Meta Data DB?

32>What are different SharePoint installation types

33>what is 503 PAGE Error in SharePoint?

34>what is a recycle bin and how many types of recycle bins available in SharePoint and

35>Different types of Application Pools in SharePoint?

36>what is a HostHeader?
37>How you will configure the SSL for the SharePoint applications?

38>what are Usage reports and what is the purpose of them?

39> what is STSADM? How you will access the 12/14 Hive path?

40>What is the Difference between Import and Export ?

41>What is the Difference between Back up and Restore ?

42>what are the different types of Back up and restore strategies are there ?

43>what are the different types of Permission levels in SharePoint?

44>what is alternate access mapping?and how you will configure the same?

45>How you will Deploy the SharePoint Solution Packages into the SharePoint Farm.

46>what is FullCrawl and Incremental Crawl?

47>what is unattended Service Account?

48>what is Managed Accounts?

49>How you will migrate the users from one domain to other domain in SharePoint?

50>Installation of all Business Intelligence tools, Power Pivot, Performance Point Services.