Event ID 6398, Event ID 7043, Event ID 2137, Event ID 7362, Event ID 57, Event ID 5586, Server Site Dependencies Common Issue After Upgrade
Microsoft SharePoint Foundation Subscription
The Microsoft SharePoint Foundation Subscription Setting service is one element of a concept known as multi-tenancy in SharePoint 2010. The service provides a means of creating and managing logical groups of site collections based on the need to share settings, features and service data.
Service provides a means of creating and managing logical groups of site collections based on the need to share settings, features and service data.
How to start it
1. The service “Microsoft SharePoint Foundation Subscriptions Settings Service” is stop
2. Start service “Microsoft SharePoint Foundation Subscriptions Settings Service” by Open Management Shell input the script below
<# Start Microsoft SharePoint Foundation Subscriptions Settings Service #>
Get-SPServiceInstance | where{$_.GetType().Name -eq “SPSubscriptionSettingsServiceInstance”} | Start-SPServiceInstance
3. Service “Microsoft SharePoint Foundation Subscriptions Settings Service” is started
Get-SPServiceInstance | where{$_.GetType().Name -eq “SPSubscriptionSettingsServiceInstance”} | Start-SPServiceInstance
For more Go to
http://www.microsofttechnology.net/2013/04/sharepoint-2010-microsoft-sharepoint.html
In this tutorial I will show you how to configure SSL for SharePoint 2013.
Prerequisites:
Steps:
Note: Make sure to perform these steps with admin privileges.
Step 1: Create Self Signed Certificate on IIS 8
Open IIS Manager and then go to Server name and choose IIS Section “Server Certificates”
Click on Create Self-Signed Certificate… on Actions pane
Specify a name like “SharePointSelfSignedCert” and click Ok
Double click on this created Certificate and go to details Tab and click copy to File…
Click Next (Welcome…),
Select No, do not export the private key and…
View original post 290 more words
Fusion Charts Free for SharePoint (FCFS) provides a set of 22 different charts (2D & 3D) that integrates easily into your SharePoint environment (WSS 3.0 / MOSS 2007 / Sharepoint Foundation 2010 / Sharepoint Server 2010).
FCFS provides you a powerful way to display very nice looking charts into SharePoint with minimum effort.
Main Features
For picture gallery
First we need to add the solution then deploy it
Open the sharepoint power shell then run the following to add the solution
Add-spsolution “path of solution”
Then go to central admin farm solutions choose the solution fusionchartssharepoint.wsp
Then doploy the solution 
Choose now and choose the web application you want to deploy on
Then go to your SharePoint site
Site actions site settings
Site collection features under site collection administration
Search for the fusion charts SharePoint then activate 
Site action edit page
Insert web part choose fusion chart
Chart from list And chart from xml as a test 
You can edit the web part and chose the chart type you need
In the edit web part go to fusion charts add the name of the list to be displayed
And the name of the columns
At the end you will get the charts
Login failed for user “NT AUTHORITY\ANONYMOUS LOGON”
This resulted from the fact that apparently the Business Data Connectivity Service wasn’t passing the current user’s credentials to access the external data, although the “Connect with User’s Identity” had been selected on the external content type creation.
Problem
Pass through authentication not working for BCS on a WebApplication which is Claims based and using Kerberos.
While you try to access the External List based on User’s Identity you received the following error
Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON’
PreReq
In this post I will talk about the reason and what are the different workarounds for this issue. I will not be discussing the steps of how to create Web Application in Kerberos or how to set up SPN
Reason
For Service Applications which are not claims aware have the ability to utilize claims to windows token service to convert Claims token. At this time BCS does not leverage C2WTS. More details can be found in the following Guide
Workaround 1 – Revert to Self (BCS Authentication)
By Default Revert to Self is disabled. We will need to run following CMDlets from PowerShell to enable it
Get-SPServiceApplication
#Copy the ID of BCS Service Appliction
$bcs = Get-SPServiceApplication -ID “BCS ServiceApp ID”
$bcs.RevertToSelfAllowed = $true
$bcs.update()
PS C:\Users\SPSadmin> Get-SPServiceApplication
$abc = Get-SPServiceApplication –id ID
PS C:\Users\SPSadmin> $bdc.RevertToSelfAllowed = $true
PS C:\Users\SPSadmin> $bdc.Update()
Afterwards, restart the Business Data Connectivity Service and the list should be working fine.
We will need to modify External Content type by using SharePoint designer and have it use BDC Identity
Select BDC Identity under Default and Client TAB and click on OK.
Now it will let all the users browse to the external list.
Note – Whenever end user brows to the external list, it is the BCS AppPool account which is used to pull the data and not the User’s Identity. Please ensure that BCS App Pool have permissions on the database.
Now it will use the user account which is assigned to the Apppool to connect to SQL
So make sure to give it permission on SQL
References:
http://blog.ozzie.eu/2012/04/sharepoint-2010-bcs-login-failed-for.html
SharePoint 2010: Connecting to SQL Server Using the External Content Type Feature
Prerequisites:
Step 1: Browse the site created by you > Select ‘Site Actions’ and select ‘Edit in SharePoint Designer’. This will start the SharePoint Designer.
Step 2: SharePoint 2010 Designer now shows the Site Information. From the left side pane, select ‘External Content Types’ as below:
This step will retrieve the External Content type.
Step 3: To create a new ‘External Content Type’, click on ‘External Content Type’ in the Top left corner of the Ribbon as below:
This will show the window from where you can set the External Content Type Information. Here in this window, you can set the following Information:
1. Name of the External Content Type Information
2. External Content Operations: This is used to define Operations which can be performed on the External Data Source e.g. Create, ReadList, ReadItem, Update and Delete etc.
Step 4: Set the External Content Type information as below:
Now Click on the ‘Click Here to discover external Data sources and define operations ‘ as shown above, you will get the following window using which you can add connections to external content type:
Click on ‘Add Connection’. You will see a window using which you can select ‘External Data Source type’ > Select Sql Server as below:
After clicking OK, you will be asked to enter Database information as shown below:
Click on ‘OK’ and you will get the Database Connection in Data Source Explorer. Expand it and locate the ‘Customer’ table as shown below:
In this step, you have completed the Connection part.
Step 5: Now after establishing the connection withan External Data Source, it’s time for us to define possible operations on the Data Source. So right click on ‘Customer’ and select all Operations from the Context menu as shown below:
The above image shows self-describing operation types. After selecting ‘Create All Operations’, the wizard will start as shown below. Please read the Instructions.
Click on ‘Next’. The next window will show the Parameter Configuration as shown below. Note: Here you can ignore the Warnings.
Click on ‘Next’. Here it is optional for you to set filter parameters which allows you to set the size of the result set. Click on ‘Finish’. The following operations will get generated as shown below:
Step 6: Once it is done, click on the ‘Save’ button on the top-lfet.
Step 7: Now to create the List, click on ‘Create List & Form’ button on the Ribbon
After clicking on ‘Create List & Form’, you will see a form where you can enter List name and other information as shown below. If you want to create an InfoPath form, you can check the CheckBox ‘Create InfoPath Form’
Step 8: Now go back to the Web Site and Refresh. You will see the ‘CustomerInfoList’ in the Quick Launch window as shown below:
Step 9: Click on the ‘CustomerInfoList’ and you will get the following result:
You must be wondering why did this happen? What does the error ‘Access denied by Business Data Connectivity’ mean? The reason for this error is that, BCS is an external web service which is hosted on IIS and to establish connectivity between the Service Hosted on IIS and a database, an explicit authorization is required. So now we need to do some configuration here.
Step 10: Open SharePoint 2010 Central Administration and Select Application Management. From ‘Application Management’ > select ‘Service Applications’ and click on ‘Manage Service Applications’. You will get a list all the services which are running. From this page, click on ‘Business Data Connectivity Service’ > you will get ‘Service Application Information’ as shown below:
Step 11: Select the ‘CustomerListInfo’ and click on ‘Set Object Permissions’ from the Ribbon. You will get a window for Setting Object Permissions. Add the user info as shown below:
object-permission
Click ‘OK’
Step 12: Now go back to your site and click on the CustomerInfoList from Quick Launch. You will get the following result:
Result
From here, you can perform ‘Create’, ‘Update’, ‘Delete’ and ‘Read’ operations.
Reference
