یوزرهای مورد نیاز برای راه اندازی شیرپوینت

http://sharepointgeorge.com/2010/installing-sharepoint-2010-privilege-service-accounts/

restore کزدن یک back up ازیک سرور به سرور دیگر با ورژن متفاوت دیتابیسی

ابتدا دیتابیس را در Sql server رستور کرده وسپس طبق لینک زیر عمل میکنیم

http://www.megren.net/Blog/Lists/Posts/Post.aspx?ID=17

back up and restor with powershell command

 

SharePoint 2010 – How to backup and restore a site collection with PowerShell

Backup a Site collection with PowerShell

Backup-SPSite -Identity http://myserver -Path "c:\backup\file.bak"

Restore a Site Collection with PowerShell

Restore-SPSite -Identity http://myserver -Path "c:\backup\file.bak"

یک لینک مفید از تمام موارد شیرپوینت 2010 در css

http://ipanco.wordpress.com/2011/05/16/sharepoint-2010-master-page-and-css/

Removing the checkbox on list items in SP2010

Here’s a quick one about modifying list views to remove the checkbox that appears next to list items. It’s really simple but it is a new element of SharePoint 2010 list views and one where it is not immediately obvious that it is configurable (to me anyway!).

The checkbox appears next to items in list views so that they can be selected by the user and therefore be ‘acted‘ upon from the ribbon. Sometimes however this just isn’t what’s required – for example when we simply want to show a list of links on a team site home page.

Now as you can see above, the checkboxes are included in the view by default – and as I’ve said above, we don’t want them to be. So to remove them we simply need to modify a setting in the view. This setting is a new one to SharePoint 2010 called Tabular View.

In this scenario we could either open up the web part properties and directly configure the view there or we could chose to create or modify an existing view on the list and then set the web part to use that view. I’ll choose the latter.

1. Navigate to the list
2. Create a new view, e.g. Team Site Home Page
3. In the view modify the Tabular View settings to unselect the option ‘Allow individual item checkboxes‘
4. Now set the web part to use this new view

 

It may just be me but I only noticed this option for the first time the other day, and I thought it

 

http://www.glynblogs.com/2011/02/removing-the-checkbox-on-list-items-in-sp2010.html 

Cannot delete OU in Active Directory

1. Go to the View menu at the top
2. Select Advance Features
3. Right-click on the OU to be deleted
4. Select Properties
5. Select the Object tab
6. Deselect the checkbox Protect Object from Accidental Deletion
7. Click OK
8. Right-click on the OU to be deleted
9. Select Delete

Hide I Like It and Notes and Tags

Hide I Like It and Notes and Tags

If we have a requirement to hide social features from SharePoint 2010 or from windows foundation server which is I Like it and Notes and Tags options, then we can do so with the help of central administration.

Remember this feature is a farm level feature, so if you make a change, it is going to affect every web application that you’ve created and needs to be done on every server running SharePoint.



Now open central administration, go to System settings, Farm management, click on manage features



Deactivate social feature



Come back to any site in any web application, you will now not see I Like it and Tags and Notes option in the ribbon.

Show Quick Launch on SharePoint 2010 Webpart Page

When you create a webpart page on SharePoint 2010 or 2007 for that matter, the quick launch will vanish.

With SharePoint 2007 all you needed to do was edit the page in SharePoint Designer and remove the following 2 lines:

< asp:Content ContentPlaceHolderId="PlaceHolderNavSpacer" runat="server">
< asp:Content ContentPlaceHolderId="PlaceHolderLeftNavBar" runat="server">

With SharePoint 2010 you also need to delete the following:

< style type="text/css">
body #s4-leftpanel {
display:none;
}
.s4-ca {
margin-left:0px;
}


The quick launch will now display on the web part page

http://pscave.blogspot.com/2010/10/show-quick-launch-on-sharepoint-2010.html.

تغییر نام صفحه در صفحه وب پارت شیرپوینت

صفحه  مورد نظر را در شیرپوینت دیزاینر باز می کنیم و کدهای موجود در تگ 

asp:Content ContentPlaceHolderId="PlaceHolderPageTitleInTitleArea" runat="server">
 

تغییر نام صفحه وب پارت در شیرپوینت 2010در قسمت browser windows بدون تغییر URL

برای تغییر نام صفحه وب پارت در شیرپوینت 2010در قسمت browser windows بدون تغییر URL اتدا باید صفحه مورد نظر را در SPD باز کرده و در قسمت

 

کد زیر را که مربوط به این قسمت است  را حذف می کنیم  و نام مورد نظر را به جای آن تایپ میکنیم.

 

 

 

scroll not work in dialog box(add new item) in IE for sharepoint 2010

برای حل این مشکل در صفحه ی مستر پیج  در تگ

 

scroll= “no”

را حذف می کنیم.

موفق باشید.

Change Browser Tab Title in SharePoint

Check the Page Layout you are using for your site.

Open the Page Layout in SharePoint Designer in Advanced mode. Page layouts > Right click Page Layout > Check Out > Right Click Page Layout > Edit in Advanced Mode.

Find the code snippet and replace the text "your title here" with your title.

مقایسه نسخه های مختلف شیرپوینت 2010

در این پست قصد دارم تفاوت بین نسخه های مختلف شیرپوینت 2010 را تشریح کنم .

شیرپوینت 2010 در 3 نسخه عرضه شده است :

• SharePoint 2010 Foundation
• SharePoint Server 2010 Standard
• SharePoint Server 2010 Enterprise​

مهمترین تفاوتی که بین نسخه های مختلف شیرپوینت وجود داره رایگان بودن نسخه Foundation میباشد که بستری است برای تولید نرم افزار و راهکارهای تحت وب و دو نسخه دیگر دارای لیسانس بوده و برای استفاده از آنها می بایست بهای لیسانس رو بپردازید .

اما امکاناتی که این سه نسخه دارند با یکدیگر متفاوته که اگر بخواهیم مقایسه ای بین این امکانات داشته باشیم میتونیم اونها رو به 4 دسته سرویس ها ، قالب های سایت ، امکانات مجموعه سایت و امکانات سایت تقسیم نماییم که در زیر امکانات هر یک را میتوانید مشاهده نمایید :

SharePoint 2010 Foundation

سرویس ها

​BCS
User and Health
Security Token Service (STS)
Claims to Windows Token Service
Application Discovery and Load Balancer Service
Subscription Settings Service
Sandboxed Code Service
SharePoint Foundation Search Service
Workflow Timer Service
State Service

قالب های سایت

​Team
Blank
Document Workspace
Blog
Group Work Site
Basic Meeting Workspace
Blank Meeting Workspace
Decision Meeting Workspace
Social Meeting Workspace
Multipage Meeting Workspace

امکانات مجموعه سایت

​Custom Site Collection Help
Open Documents in Client Applications by Default
Report Server Integration Feature
Three-state Workflow

امکانات سایت

​Group Work Lists
Report Server File Synch
Team Collaboration Lists
Wiki Page Home Page

​SharePoint Server 2010 Standard

سرویس ها

​Managed Metadata Service
Secure Store Service
Word Automation Service
User Profile Service
Web Analytics Service​

قالب های سایت

​Records Center
Enterprise Search Center
My Site Host
Basic Search Center
Publishing Portal
Enterprise Wiki

امکانات مجموعه سایت

​SharePoint Server Standard Site Collection Features
SharePoint Server Publishing Infrastructure
Publishing approval Workflow
Content Type Syndication Hub
Disposition Approval Workflow
Document ID Service
Document Sets
In Place Records Management
Library and Folder Based Retention
Reporting
Search Server Web Parts
Workflows
SharePoint 2007 Workflows

امکانات سایت

​SharePoint Server Standard Site Features
SharePoint Server
Content Organizer
E-mail integration with Content Organizer
Hold and eDiscovery
Metadata Navigation and Filtering
Offline Synchronization for External Lists

SharePoint Server 2010 Enterprise

سرویس ها

​Access Service
Excel Service
PerformancePoint Service
Visio Graphics Service
Lotus Notes Connector Service
Application Registry Service

قالب های سایت

​​Business Intelligence Center
FAST Search Center
Visio Process Repository

امکانات مجموعه سایت

​​SharePoint Server Enterprise Site Collection Features
Performance Point Service Site Collection Features

امکانات سایت

SharePoint Server Enterprise Site Features

نسخه Foundation بیشتر امکانات لازم برای پیاده سازی یک راهکار تحت وب را دارا میباشد و حتی برای تولید نرم افزارها و یا سرویس های تحت شیرپوینت نیز میتوانید از این نسخه استفاده نمایید ولی اگر در شرکتی هستید که نیاز به سرویس های پیشرفته تر دارید میتوانید یکی از نسخه های استاندارد و یا سازمانی را برای سازمان خود انتخاب نمایید .

حل مشکل تغییر نام صفحه در شیرپوینت 2010

-

کدهای بالا را در قسمت ویرایش صفحه حذف کرده و به جای آن نام فارسی صفحه را تایپ کنید.

id="wikiPageNameDisplay" را پیدا کرده و را حذف کنیدو نام فارسی صفحه را بجای آن تایپ کنید.

 

http://sharepointpratik.wordpress.com/2011/07/28/rename-wiki-page-title-in-moss-2007-sharepoint-2010-without-changing-site-url/

 

import&export sitcollection in sharepoint 2010

Try using import/export. The main difference between import/export and backup/restore is that import/export generates new Guids.

http://technet.microsoft.com/en-us/library/ee428301.aspx

 استexport   لینک بالا مربوط به

بعد از اینکه عملیات export انجام شد یک sitcollection ساخته بدون اینکه templateبرای آن انتخاب کنیم.

سپس دستورimport در powershellاجرا کنید

Import-SPWeb -Identity <  site url> -Path

 

 

What’s my SharePoint 2010 Content Database ID

There are several commands that may require you to pass in a SharePoint Content Database ID. PowerShell makes it easy, just use the Get-SPContentDatabase command.

Pass in the WebApplication Parameter to get a list of all of your Content Databases for that Web Application:

Need to know the Content Database of a specific site (web)? Just pass in the site parameter:

For a complete list of SharePoint 2010 Content Database Powershell cmdlets go to http://technet.microsoft.com/en-us/library/ee890116(office.14).aspx

 

 

Cannot find ContentPlaceHolder

http://social.msdn.microsoft.com/Forums/en-US/sharepoint2010general/thread/91004586-8982-4ca8-84de-f868a26d0cc5/

Hide Yellow Status Bar Sharepoint 2010

Open V4.Master file in Sharepoint desginer 2010 and search for

 

تگی که در اون STATUS BAR هست رو پیدا کنید و COMMENT اش کنید.

SharePoint RegistrationID's

http://datacogs.com/datablogs/archive/2008/03/26/913.aspx

InvalidType = -1
GenericList = 100
DocumentLibrary = 101
Survey = 102
Links = 103
Announcements = 104
Contacts = 105
Events = 106
Tasks = 107
DiscussionBoard = 108
PictureLibrary = 109
DataSources = 110
WebTemplateCatalog = 111
UserInformation = 112
WebPartCatalog = 113
ListTemplateCatalog = 114
XMLForm = 115
MasterPageCatalog = 116
NoCodeWorkflows = 117
WorkflowProcess = 118
WebPageLibrary = 119
CustomGrid = 120
DataConnectionLibrary = 130
WorkflowHistory = 140
GanttTasks = 150
Meetings = 200
Agenda = 201
MeetingUser = 202
Decision = 204
MeetingObjective = 207
TextBox = 210
ThingsToBring = 211
HomePageLibrary = 212
Posts = 301
Comments = 302
Categories = 303
Pages = 850 (thanks to Anders Jacobsen for this one)
IssueTracking = 1100
AdminTasks = 1200

 

feature's id in sharepoint 2010

http://sharepointchick.com/archive/2011/06/23/sharepoint-publishing-features-functionality.aspx

اضافه کردن ویژگی PHOTO به ACTIVEDIRECTORY

 

http://msitpros.com/?p=1036

As you all know by now there are several areas you can elevate pictures from Active Directory. What I mean is that you can add a picture to the thumbnailphoto attribute in Active Directory and it will be displayed in Outlook (not only Outlook 2010: http://www.stevieg.org/tag/thumbnailphoto/ ) and Lync. You could also achieve this on SharePoint. But what you probably did not know is that you can also automate the process of setting a user tile picture (User picture) on the start menu on Windows7 clients reading the picture from Active Directory. I will explain the process.

First we need to add a picture to accounts in Active Directory. This can be achieved in many ways. One way is to use the dll from oLID: http://www.dewdney.co.uk/adext/adext.zip (readme inside zip file), another way is to use this tool: http://www.cjwdev.co.uk/Software/ADPhotoEdit/Info.html. A Third option is to use PowerShell. In order to import a picture using powershell you can use this code (you need Active directory modules):

 

حذف خانه از نام اصلی سایت

When we browse our Sharepoint site, IE's title reads "Home - My Site Name - Windows Internet Explorer". We can't find any way to remove the "Home" string, regardless of how we change the site's name. This is critical for our ISO review tomorrow!

Now, I'm no ISO reviewer, but it seems a bit excessive even for the strictest ISO test. But hey, I'm just your friendly neighborhood technical solutions provider.

The first step to changing it is to understand where this string is stored. Easiest way to do that is to open the default.aspx page with Sharepoint Designer. We can see it contains a content block that replaces the master page's Title content placeholder.

This is the master page bit (line 14 on my unedited default.master):

And this is the replacement in default.aspx:

EncodeMethod="HtmlEncode"/> -

We can see that the title is made up of two parts, the localized "Home" string (in red) and the current site's name (in blue) taken from the site's properties. We have two options here - we can either find the resource string and change it, or remove it from the ASPX altogether (along with the connecting dash) and have a clean page title. The second option is pretty straightforward, so we'll focus on the first:

text="<%$Resources:wss,multipages_homelink_text%>"

We can see that the actual text is retrieved from some Resource Manager. The format of the $Resources token is as follows:

$Resources:filename,localizedString

So what we need is the string "multipages_homelink_text" under the file wss.resx. Finding it, however, took me a while. I found the file under 12\CONFIG\Resources (under the base 12 folder) rather than the more obvious 12\RESOURCES. This folder contained wss.resx, and also wss.en-US.resx and wss.he-IL.resx, the two languages I had installed. Seemed fitting. Editing the multipages_homelink_text value in them, however, didn't seem to change anything. So I expanded the scope again.

Seems that resx files in the 12 directory are only template files, copied to each specific Virtual Server when its created. From there on, the virtual server has its own copy of the resx files, residing under C:\inetpub\wwwroot\wss\VirtualDirectories\\App_GlobalResources. There I found another copy of the wss.resx file, and changing the value there instantly updated the site, no IISRESET necessary. Joy!

data view در شیرپوینت 2010

To display a list in a site collection from a different site collection:

1. Open Internet Explorer and browse to your SharePoint list from which you would like to display data from.
2. In the ribbon, click on Library
   
3. Click on Library Settings
   
   
4. In Internet Explorer’s address bar, copy the contents of the url after the List=
   
5. Open notepad and paste contents.
   Example: %7B4C36CA74%2DF413%2D493B%2DA5FA%2D3C3B607FC5D5%7DNext we need to decode contents of the list GUID:Replace the beginning %7B with {
   Example: {4C36CA74%2DF413%2D493B%2DA5FA%2D3C3B607FC5D5%7DReplace the %7D at end with }
   Example: 4C36CA74%2DF413%2D493B%2DA5FA%2D3C3B607FC5D5Replace all instances of %2D with –
   Example: {4C36CA74-F413-493B-A5FA-3C3B607FC5D5}

   Keep this window open as we will need the list GUID later.

6. Open SharePoint Designer 2010.
7. Open the web site where you would like to display the list contents.
8. In the left-menu, under Site Objects, click on Data Sources.
   
9. On the top, click on Data Sources tab, then on SOAP Service Connection.
   
   
10. In the Data Source Properties window:
    1. Click on the login tab.
    2. Under options, select “Save this username and password in the data connection”. Enter appropriate service account and password that has access to the site.
       
    3. Click on the Source tab.
    4. In the Service description location field, type in: /_vti_bin/lists.asmx
    5. Click on Connect Now button.
    6. Set Port drop-down = ListsSoap.
    7. Set Option drop-down = GetListItems.
    8. Open the notepad file and copy the list guid from step 5.a above.
    9. In the Parameters sub window, double-click on listName.
    10. Paste the copied list GUID into Value field.
        
    11. Click on the OK button.
    12. Window should look similar to:
        
11. Click on the OK button.
12. In the left-menu, click on Site Pages:
    
13. In the right-window, right-click on the page you would like to add the list and select checkout.
14. Right-click on the file again and select Edit File in Advanced Mode.
15. Left-click in the page area where you want to add the Data View.
16. On the top menu, click on Insert then Data View, then under SOAP services, double-click on the connection created above (e.g. Lists on yourcompany.com).
    
17. A Data Form Web Part will appear.
    
    Also, on the right-side the Data Source Details will appear.
    
18. Save and check-in the page.
19. View the page in the browser.

loadکردن سایت با IP Address

Alternate Access Mappings by IP address!

You should not do this… but here’s how

You can add an IP address in the alternate access mappings from Central Admin (System Settings > Configure alternate access mappings)

e.g.

There are a few other caveats, assuming that you are using some level of NAT you will have an internal IP address which the external IP address is translated to:

1. The internal IP address must be unique for that server on that port

2. You will need to setup the binding in IIS such that the IP address is the host header

3. Any load-balancing will be bypassed; this will target a single WFE server

This may not be the right solution for you (or anybody!) but in this case it was the only way we could guarantee access to the SharePoint site urgently.

templateهای مخفی در شیرپوینت 2010

One of my favorite site templates for creating root site collection back in SharePoint 2007 was Collaboration Portal. But in SharePoint 2010 it is not available in the selection tabs/lists during site collection creation process. I searched the web to see if somebody else is missing this one and found several resources where this is explained.

So, this site template is deprecated in SharePoint 2010. It exists, but it is hidden and is intended to be used by the SharePoint 2007 site collections created from this template and migrated to SharePoint 2010. But, with PowerShell you can view all site templates, even hidden ones. Use Get-SPWebTemplate command to list them.

As we can see, our Collaboration Portal site template is named SPSPORTAL#0. Now, once again, with PowerShell command New-SPSite we can create new site collection using this SPSPORTAL#0 site template.

New-SPSite -url http://portal/sites/spcolportal -name "collaboration portal template site" –owneralias -template "SPSPORTAL#0"

Here is the resulting site:

But, once again to mention, this site template is deprecated and not intended to be used by the users. Is is for migration purposes only.

I want to share one very good blog post about SharePoint 2010 site templates by Todd Baginski: http://0.mk/sp2010-st1

 

http://mkdot.net/mknetug/mk_sp/b/darko/archive/2011/02/22/collaboration-portal-site-template-is-missing-in-sharepoint-2010.aspx

نحوه ساختن لیست خارجی در شیرپوینت 2010

http://community.bamboosolutions.com/blogs/sharepoint-2010/archive/2011/04/27/sharepoint-2010-cookbook-how-to-create-external-list-including-database-from-sharepoint-designer-2010.aspx

Solution:

SharePoint 2010 has a new type of List called the External List which is used for displaying data that comes from Business Connectivity Services (BCS).

First, I will demonstrate how to create an External List that uses data from a SQL table through SharePoint Designer 2010.

• Step 1: Make sure that you created a Northwind database in SQL Server.
  

• Step 2: We go to SharePoint Designer to connect the database with SQL Server as follows:
  • Click on the External Content Types menu on the left pane
  • Then, select the External Content Types icon on the top.
  • You will see a Connection window appear:
    

• Step 3: Click on Add Connection button
  

• You will see a dialog appear to select Data Source Type as pictured below
• Of course, we will select SQL Server
  

• After selecting Data Source Type, we fill in the SQL information fully, including Database Server, Database Name, and Secure store Application ID as shown below:
  

• Don't forget to enter User Name and Password when BSC Secure Store is shown:
  

• Step 4: After connecting successfully, you will see Northwind database shown on Data Source Explorer as shown below.
• We will select a Table to create in here by right-clicking Table Name and selecting Create All Operations:
  

• A Parameter Configuration is shown after that; you can select any columns which you need and click the Finish button to complete:
  

• Finally, don't forget to click the Save button after you're done. This is pretty important, for obvious reasons:
  

• Now, we have a Northwind database as we expected:
  

Now, I will show you how to create an External List including a database, from SharePoint Designer. It's very easy.

• Step 1: First, we go to SharePoint Designer 2010 to select a site for configuring

  For example: I select the http://singlemoss2010 link
  

• Make sure that we have configured BDC before. Don't forget that we are getting data from BDC so we must have a database in here.

  For example: I created the Northwind database in here.
  

• Next, click on the External List menu on the Ribbon to create a new list. You will see a Create External List form appear. You only need to fill in the List Name in the Name textbox as pictured below:
  

• Step 2: Now, go to the site which you selected for configuring earlier. We will see a new External List created from SharePoint Designer.
• But you may be surprised when clicking on the new list since you will not see its database in here. Don't worry about this! This only means that you have not yet assigned access privileges for the current logged-in user yet.
  

• Step 4: To assign access privileges for a user, go to the Central Admin Page --> Application Management and select Manage service applications:
  

• Click on the Business Data Connection Services hyperlink as shown below:
  

• After clicking on BDC Services, you will see the database which you created earlier. Please click on the Database Name to expand the context menu and select Set Permissions:
  

• You should add users and assign access permissions for them in here:
  

• Step 5: After finishing the configurations above, you only need to go to the site and press F5 to refresh the page.
  • Now, everything is OK. You will have an External List including database in here:
    

Notes:

• CAUTION: SharePoint 2010 External List throws a webpart exception when working with an external content type that was created in Visual Studio 2010.

I have created an external content type in Visual Studio which connects to a SQL 2008 database. Following is what I've covered:

1. Created External Content types in Visual Studio 2010
2. Wrote implementation for ReadItem, ReadList, Create and Update
3. Deployed the content type through Visual Studio (Right click Solution name -> Deploy)
4. Verified through SharePoint Designer 2010 that the content type has been added
5. Added permissions for this ECT through Central Administration
6. Created an External List using SharePoint 2010 (also created directly from browser - Web Application)

2. Mapping External List Columns to Database Columns

• Every column in the file you want to import must be mapped to an existing column in the prospects table in the Siebel Database, or to an attribute created for this purpose. If you import response or campaign data, you can also map to response and campaign fields. For information about mapping attributes, see Adding Additional Attributes to a List.
• CAUTION: Make sure that you map every column before launching the import.
• To map list columns to database columns in the prospect table:

1. Navigate to the List Management screen > Lists view.
2. Drill down on the list name.
3. Click the List Import view tab.
4. Scroll down to the List Import Format list and map every column to an existing database column in the prospect table or to an attribute created for this purpose.
5. In the List Import Format list, save the format in one of the following ways:
6. The first time you save a format, click Save as New.
7. Save as New allows you to retain the original format and save the modified format separately. All saved formats appear in the List Management screen's List Imports Formats view tab.
8. Click Save to overwrite the original format.
9. Use this save option if you make changes to the mappings and want to preserve them.
10. After you save the List Import Format, perform the following steps to verify the columns that will be used for matching and update.
11. In the form in the List Import view, copy the name of the List Import Format in the List Import Format field.
12. In the List Management link bar, click List Import Formats.
13. Query for the name that you copied in the List Import view.
14. In the lower list, you will see the columns that you mapped from the import file.
15. In the Exact Match Column field, check each column from the list that you want to use for the exact match.
16. NOTE: These settings are only used when you have selected Exact match or Exact and intelligent match as the matching approach.
17. In the Allow Field Updates field, check any fields that you want to allow to be overwritten when using the Overwrite existing record match resolution.

خطای external list

http://www.zimmergren.net/technical/sp-2010-bcs-problem-with-authenticationmode-and-reverttoself

You might receive an error message like this when trying to hook up a new External Data Source depending on your configuration:

The metadata object that has Name ‘yourName‘ has a Property with name ‘AuthenticationMode‘ and value ‘RevertToSelf‘. This value indicates that the runtime should revert to the identity of the application pool, but reverting to the application pool must be explicitly enabled for the service application by a farm administrator.

Solution

While digging around for a couple of minutes I couldn’t really find a suitable UI option for changing this behavior, so I dug into the power of PowerShell instead – which probably saved me quite some troubleshooting.

First you need to check the name of your Business Data Connectivity Service Application – a quick way is to check the UI, or you could use a PowerShell Cmdlet or use the API. I’m just using the UI for easy access:

Next, launch a new SharePoint 2010 Management Shell console and type in the following lines of code. Note that the name of the Service App below, is a copy of the name you took above:

$bcsServiceApp = Get-SPServiceApplication | where {$_ -match "Business Data Connectivity Service"}

$bcsServiceApp.RevertToSelfAllowed = $true;

$bcsServiceApp.Update();

This should now execute nicely (if you’ve got the appropriate permissions) and you should be able to see the RevertToSelfAllowed property be changed to true:

If you now would try to hook up your connections again, you should hopefully not see this message again.

Quick fix, done. Enjoy.

فعال کردن SharePoint Server Publishing Infrastructure

stsadm -o deactivatefeature -id f6924d36-2fa8-4f0b-b16d-06b7250180fa -url "http://*url of site collection*" -force

stsadm -o activatefeature -id f6924d36-2fa8-4f0b-b16d-06b7250180fa -url "http://*url of site collection*" -force

http://sharepoint.stackexchange.com/questions/17040/cant-activate-server-publishing

رفع خطای excell

Then tried opening the file in the browser again only to be confronted with a new error "The workbook cannot be opened." This had me scratching my head for a little while until I looked in the event log where I found that the Service Account being used for Excel Services hadn't been given any rights on the content database. After which the fix was easy to implement with the following PowerShell commands

view plaincopy to clipboardprint?

1. $webApp = Get-SPWebApplication "http://YourSharePointSite"
3. $webApp.GrantAccessToProcessIdentity("YourDomain\ExcelServicesAccountName")

$webApp = Get-SPWebApplication "http://YourSharePointSite" 

$webApp.GrantAccessToProcessIdentity("YourDomain\ExcelServicesAccountName")

Hopefully this will save someone else a bit of time.

رفع خطای power pivot

 

 

 

Could not load type ‘Microsoft.AnalysisServices.SharePoint.Integration.ReportGalleryView’. This is not what you were planning on seeing, am I correct? Didn’t think so. How do we fix this and why is it happening?

Why it happens: This particular library type needs an ASP.Net control which can’t be found because the code for it is in a dll that is missing. It is likely occurring because powerpivotwebapp.wsp has not been deployed to the particular Web Application where the site in question is located.

How to fix it: Luckily the fix isn’t too difficult, although it does require that you are an administrator since we need to do some work in Central Administration. See below for the steps.

1. Open SharePoint 2010 Central Administration from the Start Menu or by typing in the web address in your browser
2. Go to the System Settings section
3. Click on Manage Farm Solutions under the Farm Management section
4. Click on powerpivotwebapp.wsp
5. In the Deployed To section the web application where the error occurred will not be listed
6. Click Deploy Solution at the top of the screen (Shown in the first screenshot below)
7. In the Deploy To section select your web application from the drop down list (Examples in second screenshot below)
8. You have the option to schedule the deployment, keep the Now button selected if you want to be able to use the gallery immediately
9. Click OK
10. Go back to your site and click on the link to load the PowerPivot gallery again, don’t just refresh the error page

Image 1: On this screen click Deploy Solution in the top left corner.

Image 2: Select your web application from the drop down list and click OK.