Sugumaran's SharePoint Blogger

Form based Authentication ( FBA ) in SharePoint 2013

2014-03-15T07:17:00.000-07:00

What is Form based Authentication (FBA)?

Form Based Authentication (FBA) provides your own authentication method using a web form. More and more companies are using FBA as a way of extending a site for non-Active Directory (AD) users.

SharePoint standard installation uses as default AD to query the Domain Controller and to check user credentials through Windows Authentication. FBA uses a custom database created separate from AD to store user credentials. Authentication using FBA is executed by a SQL DB query. When FBA is used to extend SharePoint sites, external users (non AD users) have access to SharePoint.

Why would you allow access to external users?

A practical reason for extending a SharePoint site through FBA is collaboration on documents with your clients or vendors.

How to achieve FBA in SharePoint 2013?

There are lot of guide are there in internet to explain farm based authentication in SharePoint 2013. But here I hope simple steps through which we can easily achieve the Farm Based Authentication in SharePoint 2013.

Below are the 13 simple steps to achieve FBA.

Step 1. Create aspnetdb using aspnet_regsql

Step 2. Assign SharePoint administrator as a db_owner in aspnetdb using SQL Management Studio

Step 3. Create connection string in IIS Global

Step 4. Add Providers in .Net Roles and .Net User .

Step 5. Do step 4 in SecurityTokenServiceApplication

Step 6. Create Web Application with claim based authentication

Step 7. Create Site Collection with windows authentication

Step 8. Modification in webConfig file in Web Application & Central Admin

Step 9. Change your web application to FBA

Step 10. Select your web application in IIS and add .net Users, if error change the default provider in .net Roles and .net Users.

Step 11. Add the .net user in IIS.

Step 12. Open the web application with windows authentication and share your site with FBA users.

Step 13. Now login with FBA account.

Step 1. Create aspnetdb using aspnet_regsql in Command Prompt

Open command prompt as run as administrator. Then move the directory to C:Windows\Microsoft.NET\Framework64\v4.0.30319 , Type aspnet_reqsql and click enter.

Then the following window will open. Follow the stpes one by one.

Then Click Finish. Now Database has been created in sql server

Step 2. Assign SharePoint administrator as a db_owner in aspnetdb using SQL Management Studio

Open Sql Server Management Studio and check for aspnetdb is available under database

We need to give access to farmadmin to access this database. Below are the steps to give dbowner rights to farmadmin.

Expand security in left panel, and the exaand Logins, check for farmadmin name in logins. If not add it. Else right click on the user name and open the Properties.

Properties Pop up will open, in that select User Mapping and select the DB name in right Panel. In database roles membership select the tick mark for db_owner & click ok.

Now step 2 completed. The farm admin has access to aspnetdb.

Step 3. Create connection string in IIS Global

We need to add connection string in our SharePoint application to access the created DB

Open IIS in your server, and click o connection strings in home page.

Click add button at right side.

Below pop up will come for adding new connection string. Give Connections string name, sql server name, database name correctly as like below fig.

Step 4. Add Providers in .Net Roles and .Net User.

Now add roles and membership in providers. Click providers in home page.

Select .Net Roles in Features drop down and click add to add new roles.

Select SqlRoleProvider as the type, and give role name and make a note on that Role Name. because we need that name at a time of changing our web application to FBA.

Select the connection string the we going to use. And type”/” in application control to affect fab in Whole web application and click ok.

As like creating Roles Provider, we need to create the Membership provider. In provider Page Select .Net Users in Features. And click add link to add new membership provider.

Select SQL Membership Provider as the type & Give Membership Name. we need this name at a time of changing our web application to FBA.

Select Connection string & make true on RequiresUniqueEmail , StorepasswordInSercuredManner.

Step 5. Do step 4 in SecurityTokenServiceApplication

Select your SharePoint SecurityTokenServiceApplication under SharePoint Web Services. And create the Roles and Membership providers for this SecurityTokenServiceApplication as like in step 4.

Step 6. Create Web Application with claim based authentication

Create the new application with normal claim Based authentication as like below image. Don’t select Enable FAB .

Step 7. Create Site Collection with windows authentication

Create the site collection for create web application and give farmadmin as site collection administration.

Step 8. Modification in webConfig file in Web Application & Central Admin

Open webconfig file of Central admin & Web application and Find the name “ PeoplePickerWildCards”. And change the Key name to our Membership Provider name that we created in IIS.

Step 9. Change your web application to FBA

Now Change your Web application in FAB by following steps. Give the Membership provider name & Roles Provider name correctly in this step.

Step 10. Select your web application in IIS and add .net Users, if error change the default provider in .net Roles and .net Users.

Change the default provider as our membership provider and roles providers in .Nets Users & .Net Roles respectively.

Step 11. Add the .net user in IIS.

Now add new users to this member ship by click .Net Users and Click Add Users.

Step 12. Open the web application with windows authentication and share your site with FBA users.

Open web application with windows authentication(farmadmin account) and give site acces to FBA user that we created.

Step 13. Now login with FBA account.

Great, Now we can sign in with different user and we can open our site with Farm Authentication.

SP2010 PowerShell Commands

2013-08-27T02:09:00.000-07:00

Name
----
Add-FormControl
Add-InlineFunction
Add-SPClaimTypeMapping
Add-SPDiagnosticsPerformanceCounter
Add-SPInfoPathUserAgent
Add-SPPluggableSecurityTrimmer
Add-SPProfileLeader
Add-SPServiceApplicationProxyGroupMember
Add-SPShellAdmin
Add-SPSiteSubscriptionFeaturePackMember
Add-SPSiteSubscriptionProfileConfig
Add-SPSolution
Add-SPUserSolution
Backup-SPConfigurationDatabase
Backup-SPFarm
Backup-SPSite
Clear-SPLogLevel
Clear-SPMetadataWebServicePartitionData
Clear-SPPerformancePointServiceApplicationTrustedLocation
Clear-SPSecureStoreCredentialMapping
Clear-SPSecureStoreDefaultProvider
Clear-SPSiteSubscriptionBusinessDataCatalogConfig
Connect-SPConfigurationDatabase
Copy-SPBusinessDataCatalogAclToChildren
Disable-SPBusinessDataCatalogEntity
Disable-SPFeature
Disable-SPInfoPathFormTemplate
Disable-SPSessionStateService
Disable-SPSingleSignOn
Disable-SPTimerJob
Disable-SPWebApplicationHttpThrottling
Disconnect-SPConfigurationDatabase
Dismount-SPContentDatabase
Dismount-SPStateServiceDatabase
Enable-SPBusinessDataCatalogEntity
Enable-SPFeature
Enable-SPInfoPathFormTemplate
Enable-SPSessionStateService
Enable-SPTimerJob
Enable-SPWebApplicationHttpThrottling
Export-SPBusinessDataCatalogModel
Export-SPEnterpriseSearchTopology
Export-SPInfoPathAdministrationFiles
Export-SPMetadataWebServicePartitionData
Export-SPSiteSubscriptionBusinessDataCatalogConfig
Export-SPSiteSubscriptionSettings
Export-SPWeb
Get-SPAccessServiceApplication
Get-SPAlternateURL
Get-SPAuthenticationProvider
Get-SPBackupHistory
Get-SPBrowserCustomerExperienceImprovementProgram
Get-SPBusinessDataCatalogMetadataObject
Get-SPBusinessDataCatalogThrottleConfig
Get-SPCertificateAuthority
Get-SPClaimProvider
Get-SPClaimProviderManager
Get-SPContentDatabase
Get-SPContentDeploymentJob
Get-SPContentDeploymentPath
Get-SPCustomLayoutsPage
Get-SPDatabase
Get-SPDataConnectionFile
Get-SPDataConnectionFileDependent
Get-SPDesignerSettings
Get-SPDiagnosticConfig
Get-SPDiagnosticsPerformanceCounter
Get-SPDiagnosticsProvider
Get-SPEnterpriseSearchAdministrationComponent
Get-SPEnterpriseSearchCrawlComponent
Get-SPEnterpriseSearchCrawlContentSource
Get-SPEnterpriseSearchCrawlCustomConnector
Get-SPEnterpriseSearchCrawlDatabase
Get-SPEnterpriseSearchCrawlExtension
Get-SPEnterpriseSearchCrawlMapping
Get-SPEnterpriseSearchCrawlRule
Get-SPEnterpriseSearchCrawlTopology
Get-SPEnterpriseSearchExtendedClickThroughExtractorJobDefinition
Get-SPEnterpriseSearchExtendedConnectorProperty
Get-SPEnterpriseSearchExtendedQueryProperty
Get-SPEnterpriseSearchIndexPartition
Get-SPEnterpriseSearchLanguageResourcePhrase
Get-SPEnterpriseSearchMetadataCategory
Get-SPEnterpriseSearchMetadataCrawledProperty
Get-SPEnterpriseSearchMetadataManagedProperty
Get-SPEnterpriseSearchMetadataMapping
Get-SPEnterpriseSearchPropertyDatabase
Get-SPEnterpriseSearchQueryAndSiteSettingsService
Get-SPEnterpriseSearchQueryAndSiteSettingsServiceInstance
Get-SPEnterpriseSearchQueryAndSiteSettingsServiceProxy
Get-SPEnterpriseSearchQueryAuthority
Get-SPEnterpriseSearchQueryComponent
Get-SPEnterpriseSearchQueryDemoted
Get-SPEnterpriseSearchQueryKeyword
Get-SPEnterpriseSearchQueryScope
Get-SPEnterpriseSearchQueryScopeRule
Get-SPEnterpriseSearchQuerySuggestionCandidates
Get-SPEnterpriseSearchQueryTopology
Get-SPEnterpriseSearchRankingModel
Get-SPEnterpriseSearchSecurityTrimmer
Get-SPEnterpriseSearchService
Get-SPEnterpriseSearchServiceApplication
Get-SPEnterpriseSearchServiceApplicationProxy
Get-SPEnterpriseSearchServiceInstance
Get-SPEnterpriseSearchSiteHitRule
Get-SPExcelBlockedFileType
Get-SPExcelDataConnectionLibrary
Get-SPExcelDataProvider
Get-SPExcelFileLocation
Get-SPExcelServiceApplication
Get-SPExcelUserDefinedFunction
Get-SPFarm
Get-SPFarmConfig
Get-SPFeature
Get-SPHelpCollection
Get-SPInfoPathFormsService
Get-SPInfoPathFormTemplate
Get-SPInfoPathUserAgent
Get-SPInfoPathWebServiceProxy
Get-SPLogEvent
Get-SPLogLevel
Get-SPManagedAccount
Get-SPManagedPath
Get-SPMetadataServiceApplication
Get-SPMetadataServiceApplicationProxy
Get-SPMobileMessagingAccount
Get-SPPerformancePointSecureDataValues
Get-SPPerformancePointServiceApplication
Get-SPPerformancePointServiceApplicationTrustedLocation
Get-SPPluggableSecurityTrimmer
Get-SPProcessAccount
Get-SPProduct
Get-SPProfileLeader
Get-SPProfileServiceApplicationSecurity
Get-SPSearchService
Get-SPSearchServiceInstance
Get-SPSecureStoreApplication
Get-SPSecurityTokenServiceConfig
Get-SPServer
Get-SPServiceApplication
Get-SPServiceApplicationEndpoint
Get-SPServiceApplicationPool
Get-SPServiceApplicationProxy
Get-SPServiceApplicationProxyGroup
Get-SPServiceApplicationSecurity
Get-SPServiceContext
Get-SPServiceHostConfig
Get-SPServiceInstance
Get-SPSessionStateService
Get-SPShellAdmin
Get-SPSite
Get-SPSiteAdministration
Get-SPSiteSubscription
Get-SPSiteSubscriptionConfig
Get-SPSiteSubscriptionEdiscoveryHub
Get-SPSiteSubscriptionEdiscoverySearchScope
Get-SPSiteSubscriptionFeaturePack
Get-SPSiteSubscriptionMetadataConfig
Get-SPSolution
Get-SPStateServiceApplication
Get-SPStateServiceApplicationProxy
Get-SPStateServiceDatabase
Get-SPTaxonomySession
Get-SPTimerJob
Get-SPTopologyServiceApplication
Get-SPTopologyServiceApplicationProxy
Get-SPTrustedIdentityTokenIssuer
Get-SPTrustedRootAuthority
Get-SPTrustedServiceTokenIssuer
Get-SPUsageApplication
Get-SPUsageDefinition
Get-SPUsageService
Get-SPUser
Get-SPUserSolution
Get-SPVisioExternalData
Get-SPVisioPerformance
Get-SPVisioSafeDataProvider
Get-SPVisioServiceApplication
Get-SPVisioServiceApplicationProxy
Get-SPWeb
Get-SPWebAnalyticsServiceApplication
Get-SPWebAnalyticsServiceApplicationProxy
Get-SPWebApplication
Get-SPWebApplicationHttpThrottlingMonitor
Get-SPWebPartPack
Get-SPWebTemplate
Get-SPWorkflowConfig
Grant-SPBusinessDataCatalogMetadataObject
Grant-SPObjectSecurity
Import-SPBusinessDataCatalogDotNetAssembly
Import-SPBusinessDataCatalogModel
Import-SPEnterpriseSearchTopology
Import-SPInfoPathAdministrationFiles
Import-SPMetadataWebServicePartitionData
Import-SPSiteSubscriptionBusinessDataCatalogConfig
Import-SPSiteSubscriptionSettings
Import-SPWeb
Initialize-SPResourceSecurity
Initialize-SPStateServiceDatabase
Install-LiveService
Install-NFService
Install-NWLService
Install-SPApplicationContent
Install-SPDataConnectionFile
Install-SPFeature
Install-SPHelpCollection
Install-SPInfoPathFormTemplate
Install-SPService
Install-SPSolution
Install-SPUserSolution
Install-SPWebPartPack
Install-SPWebTemplate
Merge-SPLogFile
Mount-SPContentDatabase
Mount-SPStateServiceDatabase
Move-SPBlobStorageLocation
Move-SPProfileManagedMetadataProperty
Move-SPSite
Move-SPUser
New-SPAccessServiceApplication
New-SPAlternateURL
New-SPAuthenticationProvider
New-SPBusinessDataCatalogServiceApplication
New-SPBusinessDataCatalogServiceApplicationProxy
New-SPCentralAdministration
New-SPClaimProvider
New-SPClaimsPrincipal
New-SPClaimTypeMapping
New-SPConfigurationDatabase
New-SPContentDatabase
New-SPContentDeploymentJob
New-SPContentDeploymentPath
New-SPEnterpriseSearchCrawlComponent
New-SPEnterpriseSearchCrawlContentSource
New-SPEnterpriseSearchCrawlCustomConnector
New-SPEnterpriseSearchCrawlDatabase
New-SPEnterpriseSearchCrawlExtension
New-SPEnterpriseSearchCrawlMapping
New-SPEnterpriseSearchCrawlRule
New-SPEnterpriseSearchCrawlTopology
New-SPEnterpriseSearchExtendedConnectorProperty
New-SPEnterpriseSearchLanguageResourcePhrase
New-SPEnterpriseSearchMetadataCategory
New-SPEnterpriseSearchMetadataCrawledProperty
New-SPEnterpriseSearchMetadataManagedProperty
New-SPEnterpriseSearchMetadataMapping
New-SPEnterpriseSearchPropertyDatabase
New-SPEnterpriseSearchQueryAuthority
New-SPEnterpriseSearchQueryComponent
New-SPEnterpriseSearchQueryDemoted
New-SPEnterpriseSearchQueryKeyword
New-SPEnterpriseSearchQueryScope
New-SPEnterpriseSearchQueryScopeRule
New-SPEnterpriseSearchQueryTopology
New-SPEnterpriseSearchRankingModel
New-SPEnterpriseSearchSecurityTrimmer
New-SPEnterpriseSearchServiceApplication
New-SPEnterpriseSearchServiceApplicationProxy
New-SPEnterpriseSearchSiteHitRule
New-SPExcelBlockedFileType
New-SPExcelDataConnectionLibrary
New-SPExcelDataProvider
New-SPExcelFileLocation
New-SPExcelServiceApplication
New-SPExcelUserDefinedFunction
New-SPLogFile
New-SPManagedAccount
New-SPManagedPath
New-SPMetadataServiceApplication
New-SPMetadataServiceApplicationProxy
New-SPPerformancePointServiceApplication
New-SPPerformancePointServiceApplicationProxy
New-SPPerformancePointServiceApplicationTrustedLocation
New-SPProfileServiceApplication
New-SPProfileServiceApplicationProxy
New-SPSecureStoreApplication
New-SPSecureStoreApplicationField
New-SPSecureStoreServiceApplication
New-SPSecureStoreServiceApplicationProxy
New-SPSecureStoreTargetApplication
New-SPServiceApplicationPool
New-SPServiceApplicationProxyGroup
New-SPSite
New-SPSiteSubscription
New-SPSiteSubscriptionFeaturePack
New-SPStateServiceApplication
New-SPStateServiceApplicationProxy
New-SPStateServiceDatabase
New-SPSubscriptionSettingsServiceApplication
New-SPSubscriptionSettingsServiceApplicationProxy
New-SPTrustedIdentityTokenIssuer
New-SPTrustedRootAuthority
New-SPTrustedServiceTokenIssuer
New-SPUsageApplication
New-SPUsageLogFile
New-SPUser
New-SPVisioSafeDataProvider
New-SPVisioServiceApplication
New-SPVisioServiceApplicationProxy
New-SPWeb
New-SPWebAnalyticsServiceApplication
New-SPWebAnalyticsServiceApplicationProxy
New-SPWebApplication
New-SPWebApplicationExtension
New-SPWordConversionServiceApplication
Ping-SPEnterpriseSearchContentService
Publish-SPServiceApplication
Receive-SPServiceApplicationConnectionInfo
Remove-FormControl
Remove-InlineFunction
Remove-SPAlternateURL
Remove-SPBusinessDataCatalogModel
Remove-SPClaimProvider
Remove-SPClaimTypeMapping
Remove-SPConfigurationDatabase
Remove-SPContentDatabase
Remove-SPContentDeploymentJob
Remove-SPContentDeploymentPath
Remove-SPDiagnosticsPerformanceCounter
Remove-SPEnterpriseSearchCrawlComponent
Remove-SPEnterpriseSearchCrawlContentSource
Remove-SPEnterpriseSearchCrawlCustomConnector
Remove-SPEnterpriseSearchCrawlDatabase
Remove-SPEnterpriseSearchCrawlExtension
Remove-SPEnterpriseSearchCrawlMapping
Remove-SPEnterpriseSearchCrawlRule
Remove-SPEnterpriseSearchCrawlTopology
Remove-SPEnterpriseSearchExtendedConnectorProperty
Remove-SPEnterpriseSearchLanguageResourcePhrase
Remove-SPEnterpriseSearchMetadataCategory
Remove-SPEnterpriseSearchMetadataManagedProperty
Remove-SPEnterpriseSearchMetadataMapping
Remove-SPEnterpriseSearchPropertyDatabase
Remove-SPEnterpriseSearchQueryAuthority
Remove-SPEnterpriseSearchQueryComponent
Remove-SPEnterpriseSearchQueryDemoted
Remove-SPEnterpriseSearchQueryKeyword
Remove-SPEnterpriseSearchQueryScope
Remove-SPEnterpriseSearchQueryScopeRule
Remove-SPEnterpriseSearchQueryTopology
Remove-SPEnterpriseSearchRankingModel
Remove-SPEnterpriseSearchSecurityTrimmer
Remove-SPEnterpriseSearchServiceApplication
Remove-SPEnterpriseSearchServiceApplicationProxy
Remove-SPEnterpriseSearchSiteHitRule
Remove-SPExcelBlockedFileType
Remove-SPExcelDataConnectionLibrary
Remove-SPExcelDataProvider
Remove-SPExcelFileLocation
Remove-SPExcelUserDefinedFunction
Remove-SPInfoPathUserAgent
Remove-SPManagedAccount
Remove-SPManagedPath
Remove-SPPerformancePointServiceApplication
Remove-SPPerformancePointServiceApplicationProxy
Remove-SPPerformancePointServiceApplicationTrustedLocation
Remove-SPPluggableSecurityTrimmer
Remove-SPProfileLeader
Remove-SPSecureStoreApplication
Remove-SPServiceApplication
Remove-SPServiceApplicationPool
Remove-SPServiceApplicationProxy
Remove-SPServiceApplicationProxyGroup
Remove-SPServiceApplicationProxyGroupMember
Remove-SPShellAdmin
Remove-SPSite
Remove-SPSiteSubscription
Remove-SPSiteSubscriptionBusinessDataCatalogConfig
Remove-SPSiteSubscriptionFeaturePack
Remove-SPSiteSubscriptionFeaturePackMember
Remove-SPSiteSubscriptionMetadataConfig
Remove-SPSiteSubscriptionProfileConfig
Remove-SPSiteSubscriptionSettings
Remove-SPSocialItemByDate
Remove-SPSolution
Remove-SPSolutionDeploymentLock
Remove-SPStateServiceDatabase
Remove-SPTrustedIdentityTokenIssuer
Remove-SPTrustedRootAuthority
Remove-SPTrustedServiceTokenIssuer
Remove-SPUsageApplication
Remove-SPUser
Remove-SPUserSolution
Remove-SPVisioSafeDataProvider
Remove-SPWeb
Remove-SPWebApplication
Remove-SPWordConversionServiceJobHistory
Rename-SPServer
Repair-SPManagedAccountDeployment
Restart-SPEnterpriseSearchQueryComponent
Restore-SPEnterpriseSearchServiceApplication
Restore-SPFarm
Restore-SPSite
Resume-SPEnterpriseSearchServiceApplication
Resume-SPStateServiceDatabase
Revoke-SPBusinessDataCatalogMetadataObject
Revoke-SPObjectSecurity
Set-SPAccessServiceApplication
Set-SPAlternateURL
Set-SPBrowserCustomerExperienceImprovementProgram
Set-SPBusinessDataCatalogMetadataObject
Set-SPBusinessDataCatalogServiceApplication
Set-SPBusinessDataCatalogThrottleConfig
Set-SPCentralAdministration
Set-SPClaimProvider
Set-SPContentDatabase
Set-SPContentDeploymentJob
Set-SPContentDeploymentPath
Set-SPCustomLayoutsPage
Set-SPDataConnectionFile
Set-SPDesignerSettings
Set-SPDiagnosticConfig
Set-SPDiagnosticsProvider
Set-SPEnterpriseSearchAdministrationComponent
Set-SPEnterpriseSearchCrawlContentSource
Set-SPEnterpriseSearchCrawlDatabase
Set-SPEnterpriseSearchCrawlRule
Set-SPEnterpriseSearchCrawlTopology
Set-SPEnterpriseSearchExtendedConnectorProperty
Set-SPEnterpriseSearchExtendedQueryProperty
Set-SPEnterpriseSearchIndexPartition
Set-SPEnterpriseSearchMetadataCategory
Set-SPEnterpriseSearchMetadataCrawledProperty
Set-SPEnterpriseSearchMetadataManagedProperty
Set-SPEnterpriseSearchMetadataMapping
Set-SPEnterpriseSearchPropertyDatabase
Set-SPEnterpriseSearchQueryAuthority
Set-SPEnterpriseSearchQueryComponent
Set-SPEnterpriseSearchQueryKeyword
Set-SPEnterpriseSearchQueryScope
Set-SPEnterpriseSearchQueryScopeRule
Set-SPEnterpriseSearchQueryTopology
Set-SPEnterpriseSearchRankingModel
Set-SPEnterpriseSearchService
Set-SPEnterpriseSearchServiceApplication
Set-SPEnterpriseSearchServiceApplicationProxy
Set-SPEnterpriseSearchServiceInstance
Set-SPExcelDataConnectionLibrary
Set-SPExcelDataProvider
Set-SPExcelFileLocation
Set-SPExcelServiceApplication
Set-SPExcelUserDefinedFunction
Set-SPFarmConfig
Set-SPInfoPathFormsService
Set-SPInfoPathFormTemplate
Set-SPInfoPathWebServiceProxy
Set-SPLogLevel
Set-SPManagedAccount
Set-SPMetadataServiceApplication
Set-SPMetadataServiceApplicationProxy
Set-SPMobileMessagingAccount
Set-SPPassPhrase
Set-SPPerformancePointSecureDataValues
Set-SPPerformancePointServiceApplication
Set-SPProfileServiceApplication
Set-SPProfileServiceApplicationProxy
Set-SPProfileServiceApplicationSecurity
Set-SPSearchService
Set-SPSearchServiceInstance
Set-SPSecureStoreApplication
Set-SPSecureStoreDefaultProvider
Set-SPSecureStoreServiceApplication
Set-SPSecurityTokenServiceConfig
Set-SPServiceApplication
Set-SPServiceApplicationEndpoint
Set-SPServiceApplicationPool
Set-SPServiceApplicationSecurity
Set-SPServiceHostConfig
Set-SPSessionStateService
Set-SPSite
Set-SPSiteAdministration
Set-SPSiteSubscriptionConfig
Set-SPSiteSubscriptionEdiscoveryHub
Set-SPSiteSubscriptionMetadataConfig
Set-SPSiteSubscriptionProfileConfig
Set-SPStateServiceApplication
Set-SPStateServiceApplicationProxy
Set-SPStateServiceDatabase
Set-SPSubscriptionSettingsServiceApplication
Set-SPTimerJob
Set-SPTopologyServiceApplication
Set-SPTopologyServiceApplicationProxy
Set-SPTrustedIdentityTokenIssuer
Set-SPTrustedRootAuthority
Set-SPTrustedServiceTokenIssuer
Set-SPUsageApplication
Set-SPUsageDefinition
Set-SPUsageService
Set-SPUser
Set-SPVisioExternalData
Set-SPVisioPerformance
Set-SPVisioSafeDataProvider
Set-SPVisioServiceApplication
Set-SPWeb
Set-SPWebAnalyticsServiceApplication
Set-SPWebAnalyticsServiceApplicationProxy
Set-SPWebApplication
Set-SPWebApplicationHttpThrottlingMonitor
Set-SPWebTemplate
Set-SPWordConversionServiceApplication
Set-SPWorkflowConfig
Show-InlineFunctions
Start-SPAdminJob
Start-SPAssignment
Start-SPContentDeploymentJob
Start-SPEnterpriseSearchQueryAndSiteSettingsServiceInstance
Start-SPEnterpriseSearchServiceInstance
Start-SPInfoPathFormTemplate
Start-SPServiceInstance
Start-SPTimerJob
Stop-SPAssignment
Stop-SPEnterpriseSearchQueryAndSiteSettingsServiceInstance
Stop-SPEnterpriseSearchServiceInstance
Stop-SPInfoPathFormTemplate
Stop-SPServiceInstance
Suspend-SPEnterpriseSearchServiceApplication
Suspend-SPStateServiceDatabase
SyncServices-NWLService
Test-SPContentDatabase
Test-SPInfoPathFormTemplate
Uninstall-LiveService
UnInstall-NWLService
Uninstall-SPDataConnectionFile
Uninstall-SPFeature
Uninstall-SPHelpCollection
Uninstall-SPInfoPathFormTemplate
Uninstall-SPSolution
Uninstall-SPUserSolution
Uninstall-SPWebPartPack
Uninstall-SPWebTemplate
Unpublish-SPServiceApplication
Update-NFSiteId
UpdateSiteMappings-NWLService
Update-SPFarmEncryptionKey
Update-SPInfoPathAdminFileUrl
Update-SPInfoPathFormTemplate
Update-SPInfoPathUserFileUrl
Update-SPProfilePhotoStore
Update-SPSecureStoreApplicationServerKey
Update-SPSecureStoreCredentialMapping
Update-SPSecureStoreGroupCredentialMapping
Update-SPSecureStoreMasterKey
Update-SPSolution
Update-SPUserSolution
Upgrade-NFService
Upgrade-SPContentDatabase
Upgrade-SPEnterpriseSearchServiceApplication
Upgrade-SPSingleSignOnDatabase

"Sign in as Different User" menu option is missing in SharePoint Server 2013

2013-07-22T02:33:00.002-07:00

"Sign in as Different User" menu option is missing in SharePoint Server 2013

To work around this issue, use one of the following methods

Start Internet Explorer by using the Run as different user option, and then go to the SharePoint site.

Note: The Run as different user option is visible if you hold the Shift key when you right-click a program icon.
Access the SharePoint site by using the the URL as http://siteurl/_layouts/closeConnection.aspx?loginasanotheruser=true

Important:

This option uses an unsupported browser feature which is unreliable and causes other issues. Currently this option does not work in IE 10 and Safari.

Event receiver for specific list

2013-04-26T08:06:00.002-07:00

Introduction

In this post we will see how we can attach event receiver for specific list in SharePoint 2010.

In general coders tend to write event receiver which is global for all the lists. In the event receiver code they will compare with the list name and then provide specific functionality.

In this post we will see the better practice and simple way how to set the event receiver(ex: ItemAdding event) only for a particular list

Event Receiver

Open Visual Studio 2010, select File > New > Project.

Select Event Receiver template under SharePoint > 2010

Provide the site url and select deploy as form solution and click Next button

Select List Item Events under type of the event receiver. Select Custom List and check the events we want to trigger.

Once finished, go to the solution explorer and see the the elements.xml.

ListTemplateId=”100″ is the main value that attaches event receiver to any custom list.

Change the ListTemplateId to ListUrl like the following and deploy the solution

ListUrl=”Lists/MyCustomList”

MyCustomList is the name of the custom list which I have created in my site. Now the Item Adding event receiver will be triggered only for the custom list MyCustomList but not to all the lists.

You can test the triggered event by attaching the debugger to see the event is fired only for that list.

Conclusion

In this way we can attach any event receiver for a specific list. Small change in the elements.xml file makes a better coding.

Error occurred in deployment step ‘Activate Features’: Cannot start service SPUserCodeV4 on computer

2013-03-19T00:02:00.001-07:00

"Error occurred in deployment step ‘Activate Features’: Cannot start service SPUserCodeV4 on computer "

If you ever try to deploy a sand boxed solution and run into Error occurred in deployment step ‘Activate Features’: Cannot start service SPUserCodeV4 on computer, this only means that the Windows service running sand boxed solutions is not running on the server.

To start the service go to SharePoint Central Administration, go to System Settings tab and click on Manage services on server:

In the page that opens start Microsoft SharePoint Foundation Sand boxed Code Service:

That’s all! Your solution should deploy just fine now.

If you have a more elegant solution – please post a comment…

Custom Page Layout in SharePoint Publishing Site

2013-02-05T01:02:00.003-08:00

Custom Page Layout in SharePoint Publishing Site:

Create one page layout in SharePoint Designer 2010 Or Copy BlankWebPartPage.aspx and rename to user defined name.

Create one table and arrange alignment (TR & TD tags)

Put webpart Zone in TD tags where you required webpart.

Publish the Layout page.

Now create one page with the Custom Layout Page.

Microsoft Lync configuration with SharePoint server

2013-01-29T05:48:00.005-08:00

Microsoft Lync configuration with SharePoint server & Site

Steps:

Install the lync server in SharePoint Server with the help this video Installing the Lync Server
Update the User profile For Every User With Sip address,Email Id.
Create sandbox solution to Show Group users in Grid view.
Select some users in Grid View and Start Group Conversation Using Lync

JavaScript:

<script type="text/javascript">

function getGrid() {
var grid = document.getElementById('<%=GridView1.ClientID%>');
var div = document.getElementById('SIPDIV');
var name = "";
var namearray = new Array();
if (grid.rows.length > 0) {
for (i = 0; i <= grid.rows.length - 1; i++) {
var cell = grid.rows[i].cells[0];
for (j = 0; j < cell.childNodes.length; j++) {
if (grid.rows[i].cells[0].childNodes[j].type =='checkbox') {
var cellPivot = false;
cellPivot = grid.rows[i].cells[0].childNodes[j].checked;
if (cellPivot == true) {
//name += grid.rows[i].cells[1].innerHTML;
if (name == "") {
name = grid.rows[i].cells[1].childNodes[1].innerText;
}
else{
name += "," + grid.rows[i].cells[1].childNodes[1].innerText;
}
}
}
}
}
var IDQuery = SplitValues(name);
window.open(IDQuery,"Lync");
}
}
var emailid = "";
var sipId = "";
function SplitValues(emailid) {
var Emailarr = new Array();
Emailarr = emailid.split(",");
for (i = 0; i < Emailarr.length; i++)
{
if (i == 0)
{
sipId = "im:<sip:" + Emailarr[i] + ">";
}
else
{
sipId = sipId + "<sip:" + Emailarr[i] + ">";
}
}
return sipId;
}
</script>

aspx Html Code:

<asp:GridView ID="GridView1" runat="server" EnableModelValidation="True"
onrowdatabound="GridView1_RowDataBound">
<HeaderStyle BackColor="#099BC4" ForeColor="White" Wrap="True" />

<Columns>
<asp:TemplateField ShowHeader="true" HeaderText ="">
<HeaderTemplate>
<asp:CheckBox runat="server" ID="CheckBox2" Checked="false"/>
</HeaderTemplate>

<ItemTemplate >
<asp:CheckBox ID="CheckBox1" runat="server" Checked="false" >
</asp:CheckBox>
</ItemTemplate>

<ItemStyle Width="30px" BackColor="AliceBlue" />
</asp:TemplateField>
</Columns>

</asp:GridView>

<asp:Button ID="Button1" runat="server" Text="Start Conference"
onClientClick="getGrid()"/>

C# Code:

SPFieldUserValueCollection fvc = new SPFieldUserValueCollection();
DataTable dt = new DataTable();
DataRow dr;

protected void Page_Load(object sender, EventArgs e)
{
try
{
dt.Columns.Add("Users");
SPWeb web;
web = SPContext.Current.Web;
SPGroupCollection collGroups = web.Groups;
SPList list = web.Lists["UserGroup"];
SPFieldUserValueCollection fvc = new SPFieldUserValueCollection();
foreach (SPListItem item in list.Items)
{
string fieldValue = item["UserName"].ToString();
Getusers(fieldValue);
}
}
catch (Exception ex)
{
Label1.Text = ex.Message;
Label1.Visible = true;
}
}

void Getusers(string fieldValue)
{
SPWeb web;
web = SPContext.Current.Web;

fvc = new SPFieldUserValueCollection(web, fieldValue);
foreach (SPFieldUserValue userValue in fvc)
{
SPUser user = userValue.User;
}
//string Html = string.Empty;
GetPresenceHTMLFromUVC(SPContext.Current.Site, fvc);
// Label1.Text += Html;
}

public void GetPresenceHTMLFromUVC(SPSite thisSite, SPFieldUserValueCollection uvc)
{
StringBuilder html = new StringBuilder("");
using (SPWeb thisWeb = thisSite.RootWeb)
{
foreach (SPFieldUserValue uv in uvc)
{
string sipAddress = "";
//Get the sip address if it exists
SPListItem user = thisWeb.SiteUserInfoList.GetItemById(uv.LookupId);
if (user["SipAddress"] != null)
{
sipAddress = user["SipAddress"].ToString();
}
//construct the html for this user and add to overall html
html.Append(String.Concat(
"<div id\"PresenceLink"
, sipAddress
, "\">"
, "<img border=\"0\" height=\"12\" src=\"/_layouts/images/imnhdr.gif\" onload=\"IMNRC('"
, sipAddress
, "')\" ShowOfflinePawn=\"1\" style=\"padding-right: 3px;\" id=\"PresencePawn"
, sipAddress
, "\" alt=\"presence pawn for "
, sipAddress
, "\"/>"
, "<a href=\""
, thisWeb.Url
, "/_layouts/userdisp.aspx?ID="
, uv.LookupId
, "\" id=\"ProfileLink"
, sipAddress
, "\">"
, uv.User.Name
, "</a></div><div id='SIPDIV' style='display:none'>"+sipAddress+"</div>"
//, "</a></div><div id='"+sipAddress+"' style='display:none'></div>"
));

dr = dt.NewRow();
dr["Users"] = html;
dt.Rows.Add(dr);
//Bind data into gridview
GridView1.DataSource = dt;
GridView1.DataBind();
}

}

}

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{

foreach (TableCell cell in e.Row.Cells)
{
if (e.Row.Cells.GetCellIndex (cell)!=0)
{
cell.Text = HttpContext.Current.Server.HtmlDecode(cell.Text);
}
}


}

OutPut:

Getting Hierarchy Of User Profiles In SharePoint Using C#

2013-01-11T03:52:00.003-08:00

Getting Hierarchy Of User Profiles In SharePoint Using C#

Below is the examples respectively for

Find immediate manager of a particular user.
All the users who reports the same manager.
All the managers above in the chain for a particular user

Note :

Add Following Dll Before Coding.

"Microsoft.Office.Server.dll & Microsoft.Office.Server.UserProfiles.dll"

Location For The Dll:

C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\ISAPI\Microsoft.Office.Server.dll
C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\ISAPI\Microsoft.Office.Server.UserProfiles.dll

Find Manager for currently logged in user.

private void GetManegerProfile()

{

SPSite site;

SPWeb web;

SPServiceContext serviceContext;

UserProfileManager profiles;

UserProfile profile;

try

{
using (site = new SPSite(SPContext.Current.Web.Url))

{

using (web = site.OpenWeb())

{

serviceContext = SPServiceContext.GetContext(site);

profiles = new UserProfileManager(serviceContext);

//Getting the profile of logged in user.

profile = profiles.GetUserProfile(web.CurrentUser.LoginName);

//Getting profile of the manager of the logged in user.

profile = profile.GetManager();

}

catch { }

}

Find all the user who reports the same manager as logged in user.

private void GetManegerProfile()

{

SPSite site;

SPWeb web;

SPServiceContext serviceContext;

UserProfileManager profiles;

UserProfile profile;

List<UserProfile> peers;

try

{

using (site = new SPSite(SPContext.Current.Web.Url))

{

using (web = site.OpenWeb())

{

serviceContext = SPServiceContext.GetContext(site);

profiles = new UserProfileManager(serviceContext);

//Getting the profile of logged in user.

profile = profiles.GetUserProfile(web.CurrentUser.LoginName);

//Getting peers of the logged in user.

peers = new List<UserProfile>(profile .GetPeers());

}

catch { }

}

Find all the managers above in the chain for the logged in user.

private void GetManegerProfile()

{

SPSite site;

SPWeb web;

SPServiceContext serviceContext;

UserProfileManager profiles;

UserProfile profile;

List<UserProfile> managers;

try

{

using (site = new SPSite(SPContext.Current.Web.Url))

{

using (web = site.OpenWeb())

{

serviceContext = SPServiceContext.GetContext(site);

profiles = new UserProfileManager(serviceContext);

//Getting the profile of logged in user.

profile = profiles.GetUserProfile(web.CurrentUser.LoginName);

//Getting manager profiles of the logged in user.

managers =new List<UserProfile>( profile.GetManagers());

}

catch { }

}

WebPart Custom Properties For "Site Url","List Url","Item Url" Etc

2013-01-10T06:55:00.003-08:00

Web Part Custom Properties For "Site URL","List URL","Item URL" Etc

WebPart.CS file

protected override void CreateChildControls()

{

CAFUserControl control = Page.LoadControl(_ascxPath) as CAFUserControl;

if (control != null)

{

control.WebPart = this;

}

Controls.Add(control);

}

[WebBrowsable(true), Category("CAF Properties"), Personalizable(PersonalizationScope.Shared), WebDisplayName("Enter OEM list name")]

public String OEMListName { get; set; }

[WebBrowsable(true), Category("CAF Properties"), Personalizable(PersonalizationScope.Shared), WebDisplayName("Enter Licensing list name")]

public String LicensingListName { get; set; }

[WebBrowsable(true), Category("CAF Properties"), Personalizable(PersonalizationScope.Shared), WebDisplayName("Enter Purchasing list name")]

public String PurchasingListName { get; set; }

UserControl.aspx.cs file

public partial class CAFUserControl : UserControl

{

public CAF WebPart { get; set; }

}

Eg: ascx Path ( @"~/_CONTROLTEMPLATES/...." )

private const string _ascxPath = @"~/_CONTROLTEMPLATES/AmexCalendar_VWP/AmexCalendar_VisualWebPart/AmexCalendar_VisualWebPartUserControl.ascx";

JavaScript for differentiation of two different dates & Exclude the Saturdays and sunsays in total days

2012-12-31T05:56:00.002-08:00

JavaScript for getting Total days between of two dates & Exclude the Saturdays and Sundays in total days.

Code:

function DateDifference() {

var startDate = document.getElementById('<%= txtStartDate.ClientID%>').value;

var endDate = document.getElementById('<%= txtEndDate.ClientID%>').value;

var startDateSplit = startDate.split("/");

var endDateSplit = endDate.split("/");

//getting Start Date,End Date

var stDate = new Date(startDateSplit[2], startDateSplit[0] - 1, startDateSplit[1]);

var enDate = new Date(endDateSplit[2], endDateSplit[0] - 1, endDateSplit[1]);

//getting difference B/W Start Date & End Date

var difference = (enDate.getTime() - stDate.getTime()) / (1000 * 60 * 60 * 24);

var LeaveCount = difference + 1;

if (stDate.getDay() == 0) {

LeaveCount = LeaveCount - 1;

}

else if (stDate.getDay() == 6) {

LeaveCount = LeaveCount - 1;

}

var loopDate = new Date();

loopDate = stDate;

// Excluding Sat ,Sun in Selcted Dates

for (var i = 1; i < difference + 1; i++) {

var NextDate = new Date(loopDate.getYear(), loopDate.getMonth(), loopDate.getDate() + 1);

var Ndate = NextDate.getMonth() + 1 + "/" + NextDate.getDate() + "/" + NextDate.getYear();

var NdateSplit = Ndate.split("/");

var NxtDate = new Date(NdateSplit[2], NdateSplit[0] - 1, NdateSplit[1]);

loopDate = NxtDate;

if (NxtDate.getDay() == 0) {

LeaveCount = LeaveCount - 1;

}

else if (NxtDate.getDay() == 6) {

LeaveCount = LeaveCount - 1;

}

document.getElementById('<%= txtTotalDays.ClientID%>').value = LeaveCount;

}

How to Enable Document Information Panel in SharePoint 2010

2012-12-17T04:32:00.004-08:00

How to Enable Document Information Panel in SharePoint 2010

The SharePoint 2010 Document Information Panel allows users to enter metadata for Microsoft-based documents that are stored in SharePoint. However, the SharePoint 2010 Document Information Panel is not visible by default. To view the SharePoint 2010 Document Information Panel, click the "Show Document Panel" option under the Info menu.

During an implementation of Sharepoint 2010 for an Australian client, the client had a requirement for showing the Document Information Panel whenever a document is opened from a particular document library. IOTAP was able to meet this requirement by enabling the Document Information Panel in the Document Library settings.

How to Enable SharePoint 2010 Document Information Panel for a Document Library:

1. Navigate to the Document Library for which the Document Information Panel needs to be enabled

2. Click on Library Settings in the Library Tools Ribbon

3. In the Library Settings page, click Document Content Type which is located under the Content Type Category

4. Click on Documents Information Panel Settings under Settings

5. Select the check box for “Always show Document Information Panel on document open and initial save for this conten type”
6. Click OK

Now, whenever a document is opened from the document library the Document Information Panel will be displayed as shown below.

50 Limitations of SharePoint Sandboxed Solutions

2012-12-05T22:17:00.000-08:00

1. Deployment at site collection level (No Web Application-scoped Features or Farm-scoped Features). So, If you have 100 site collections, then you have to deploy the same sandbox solution to 100 site collections.

2. No SPSecurity - Therefore no Elevated Privileges

3. You can't use SPSite object to get other site collections. (But you can use it to get current site as : SPSite site = SPContext.Current.Site)

4. Visual webparts are not supported (But you can use the "Visual Studio 200 SharePoint Power Tools" to get this functionality)

5. cannot call to the network resources. E.g. You cannot read/write to a database on the server (But you can use Silverlight)

6. Only "No code" workflows allowed. No Visual studio workflows (But the workflows without classes which are imported and edited in Visual studio will work!)

7. No support for System.IO, Therefore you Cannot read/write to the file system.

8. HideCustomAction, CustomActionGroup are not allowed. But you can use <CustomAction>

9. Remember, Resource Usage Quotas/Limits applied on Sandboxed solutions http://msdn.microsoft.com/en-us/library/gg615462.aspx

10. No Feature stapling supported.

11. Can't write to registry (But you can read)

12. Limited Server Object Model MSDN: http://msdn.microsoft.com/en-us/library/gg615454.aspx

13. Can't set cookies in the sandbox. Use JQuery plugin instead http://plugins.jquery.com/project/cookie

14. No call to external WCF/web services such as HTTP calls (But we can use AJAX)

15. Content Type Binding is not supported

16. No support for custom Timer jobs

17. Can't use SharePoint mapped folders such as _layouts

18. Can't export a Sandboxed Web Part

19. Microsoft.SharePoint.WebControls and Microsoft.SharePoint.WebPartPages Namespace are not available.

20. Managed Metadata - No programmatic access to taxonomy object model.

21. No ADO.NET support!

22. No support for SPUtility.SendEmail, So you can't Send Mails using this class.

23. No caching support

24. No Custom HTTP Modules

25. No developer dashboard

26. No Site Definition

27. Can't use controls for delegation

28. No Business Connectivity Services support

29. No Localization support

30. No SPWebConfigModification usage

31. Most of the Microsoft.SharePoint.Administration are disabled

32. No Document converters

33. No User Control support.

34. NO Custom service applications

35. SharePoint web controls (such as SPTreeView) are not supported

36. ClientScriptManager is not available - No access to ScriptManager.

37. Can't access the event viewer for logging

38. No PropertyBags of SharePoint Object model are not accessible,( But you can use SPWeb.AllProperties or custom list to store settings)

39. No GAC Deployment - Your solutions will be stored in content database. Can't deploy assemblies to GAC and Cannot call assemblies deployed out of Global Assembly Cache

40. CustomPropertyToolPart not supported

41. Can't create application pages or site pages with code behind

42. No Server side redirects, such as Response.Redirect, Server.Transfer, SPUtility.Redirect.

43. Can't access some of the enterprise services like UserProfile, Search

44. Can't access dlls from BIN and resources files(.resx)

45. Can't access code that is not marked to allow partially trusted callers

46. Can't access Cache object.

47. HttpRequest.Files collection will not contain anything

48. Only SPLimitedWebPartManager is available.

49. SharePoint Web controls (namespace SharePoint.WebControls) are not available,

50. Last but not least: site Template Binding is not supported.

Filter SharePoint List by Workflow Status

2012-11-26T07:36:00.000-08:00

Filter SharePoint List by Workflow Status

Often we need to filter a SharePoint list by the status of a workflow.

This is rather simple and can be done in the same way as filtering any other field.

The only thing you need to know is that the status of the workflow is an integer, not a text. So we can’t add a filter like ‘Workflow name’ IS EQUAL TO ‘In Progress’

The following list gives the integer values of each status.

This data can also be used within InfoPath to change the layout of the form depending on the status of the workflow.

A blog was written earlier how to do this:

http://blueinfopath.blogspot.com/2008/11/how-to-make-infopath-forms-readonly.html

List of Workflow statuses

0 - Starting

1 - Failed on Start
2 - In Progress
3 - Error Occurred
4 - Canceled
5 - Completed
6 - Failed on Start (retrying)
7 - Error Occurred (retrying
15 - Canceled
16 - Approved
17 - Rejected

Current User's Group Owner details Using Client object model

2012-10-27T05:18:00.002-07:00

Current User's Group Owner details Using Client object model

Here i am trying to get the Group owners Email Id. Similar way we can get all details of the group owner.

//COM For Current User

ClientContext COMforCurrentUser = new ClientContext("http://htschdev01:8000/sites/hr");

COMforCurrentUser.Load(COMforCurrentUser.Web.CurrentUser);

COMforCurrentUser.ExecuteQuery();

User CurrentUser=COMforCurrentUser.Web.CurrentUser;

// Smtp Server Details

MailMessage mail = new MailMessage();

SmtpClient SmtpServer = new SmtpClient("smtp.gmail.com");

//COM For Owner Details

ClientContext clientContext = new ClientContext("http://htschdev01:8000/sites/hr");

Web web = clientContext.Web;

GroupCollection groupColl = web.SiteGroups;

clientContext.Load(groupColl,

groups=>groups.Include(

group=>group.Title,

group=>group.Id));

clientContext.ExecuteQuery();

int Ownerid = 0;

string OwnerMailID = "";

foreach (Group siteGroup in groupColl)

{

clientContext.Load(siteGroup);

clientContext.ExecuteQuery();

clientContext.Load(siteGroup.Users);

clientContext.ExecuteQuery();

UserCollection Tolalusers = siteGroup.Users;

int count = siteGroup.Users.Count;

string Groupname = siteGroup.Title;

User SiteOWner;

foreach (User singleuser in Tolalusers)

{

if (singleuser.LoginName == CurrentUser.LoginName)

{

clientContext.Load(siteGroup);

clientContext.ExecuteQuery();

clientContext.Load(siteGroup.Owner);

clientContext.ExecuteQuery();

Ownerid = siteGroup.Owner.Id;

string Ownername = siteGroup.Owner.LoginName;

foreach (User Owner in Tolalusers)

{

if (Owner.Id == Ownerid)

{

OwnerMailID = Owner.Email;

break;

}

break;

}

mail.From = new MailAddress(OwnerMailID);

mail.To.Add(CurrentUser.Email);

mail.Subject = "Test Mail";

mail.Body = "This is for testing SMTP mail from GMAIL";

SmtpServer.Port = 587;

SmtpServer.Credentials = new System.Net.NetworkCredential("XYZ@gmail.com", "Password");

SmtpServer.EnableSsl = true;

SmtpServer.Send(mail);

MessageBox.Show("mail Send");

SharePoint RegistrationID For Sharepoint Contents

2012-10-09T06:40:00.001-07:00

SharePoint RegistrationID For Sharepoint Contents

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
IssueTracking = 1100
AdminTasks = 1200

Referance:http://techtrainingnotes.blogspot.in/2008/01/sharepoint-registrationid-list-template.html

Inserting/Updating/Deleting the items in share point list by C# coding

2012-08-29T09:04:00.001-07:00

Inserting/Updating/Deleting the items in share point list by C# coding:

using (SPSite site = new SPSite("http://website url/" ))

02// Or SPContext.Current.Site.Url

03{

04    using (SPWeb Web = site.OpenWeb())

05    {

06            Web.AllowUnsafeUpdates = true;

07 

08            // Open List

09             SPList list = Web.Lists["MyList"];

10 

11            // Add new item in List

12             SPListItem item = list.Items.Add();

13             item["Title"] = "Test Title";

14             item["Description"] = "Test Description";

15             item.Update();

16 

17            // Get Item ID

18             listItemId = item.ID;

19 

20            // Update the List item by ID

21             SPListItem item = list.GetItemById(listItemId);

22             item["Description"] = "Update Description";

23             item.Update();

24 

25            // Delete item

26             SPListItem item = list.GetItemById(listItemId);

27             item.Delete();

28 

29            Web.AllowUnsafeUpdates = false;

30       }

31 }

JavaScript for differentiation of two different dates

2012-08-29T09:02:00.001-07:00

JavaScript for differentiation of two different dates

following is the Java script for getting difference between two different dates

<script type="text/javascript">
function DateDifference()
{
var startDate = document.getElementById('<%=txtStartDate.ClientID%>').value;
var endDate = document.getElementById('<%=txtEndDate.ClientID%>').value;

var startDateSplit = startDate.split("/");
var endDateSplit = endDate.split("/");

var stDate = new Date(startDateSplit[2], startDateSplit[0]-1, startDateSplit[1]);
var enDate = new Date(endDateSplit[2], endDateSplit[0]-1, endDateSplit[1]);

var difference = (enDate.getTime() - stDate.getTime())/(1000*60*60*24);

document.getElementById('<%=txtTotalDays.ClientID%>').value = difference+1;
}
</script>

Changing the size of display form/ edit Form/ New Form manually in share point list Using CSS

2012-08-29T08:57:00.002-07:00

Changing the size of display form/ edit Form/ New Form manually in share point list Using CSS

Adding the following CSS styles in DispForm/NewForm/EditForm.aspx file of the item:

<style type="text/css">

.ms-dialog{

z-index: 1505;
display: block;
width:1000px;
height:600px;
margin-left:auto;
margin-right:auto;
left: 30px;
top: 20px;
}

</style>

Steps:

1) open the list in share point designer

2) open the DispForm/NewForm/EditForm.aspx in 'Edit In Advanced Mode'

3)Add the Above css style under

<SharePoint:UIVersionedContent UIVersion="4" runat="server">

4) Save it and check in browser.

Hiding the Ribbon In Share point Item Dialog Box

2012-08-29T08:53:00.001-07:00

Hiding the Ribbon In Share point Item Dialog Box Using CSS:

Adding the following CSS styles in DispForm/NewForm/EditForm.aspx file of the item:

<style type="text/css">

.s4-ribbonrowhidetitle
{
display: none;
}

</style>

Steps:

1) open the list in share point designer

2) open the DispForm/NewForm/EditForm.aspx in 'Edit In Advanced Mode'

3)Add the Above css style under

<SharePoint:UIVersionedContent UIVersion="4" runat="server">

4) Save it and check in browser.

Export the Excel without a custom code in Share point 2010

2012-08-05T23:33:00.003-07:00

Export the Excel without a custom code in Share point 2010:

Requirement:

We have requirement to export the list to excel without custom coding on click of an Excel icon at the top of the list view.

· Add the List view to a page

· Add a content editor web part at the top of the list view
· Add an Excel icon in the same with href property value as below

{siteurl}/_vti_bin/owssvr.dll?CS=109&Using=_layouts/query.iqy&List={GUID of list}&View={GUID of view}&CacheControl=1

For GUID of List & List View:

· Go to your list
· Click on List Settings
· Click on the View from the list of Views in the settings page
· Get the List GUID and View GUID
· Modify the GUID with remove %7B, %7D & replace %2D with “–“

For Example:

http://hvprod2:5555/_vti_bin/owssvr.dll?CS=109&Using=_layouts/query.iqy&List={93A56B7A-E6C5-4329-AEC8-BA80D4CA6A58}&View={2063B695-5FC4-4700-89B3-FF665E731D7D}&CacheControl=1

In the above,

GUID of List is 93A56B7A-E6C5-4329-AEC8-BA80D4CA6A58
GUID of List View is 2063B695-5FC4-4700-89B3-FF665E731D7D

Add the link with anchor tag.

<a href=”http://hvprod2:5555/_vti_bin/owssvr.dll?CS=109&Using=_layouts/query.iqy&List={93A56B7A-E6C5-4329-AEC8-BA80D4CA6A58}&View={2063B695-5FC4-4700-89B3-FF665E731D7D}&CacheControl=1” > Click Here </a>

Exporting List or Library in Excel Report using custom web part

2012-07-30T23:52:00.003-07:00

Exporting List or Library in Excel Report using custom web part

To export the list or library in excel sheet, we have to do the following points:

- pull the items from list or library and Drop it in grid view.

- create a button for Click event to export the Excel sheet

- create override render function for Exporting the Excel sheet

* Pull the items from list or library and Drop it in grid view

C# Code To display The Library & List Items:

SPWeb objWeb;

SPSite objSpSite;

SPList oList;

objSpSite = SPContext.Current.Site;

objWeb = objSpSite.OpenWeb();

oList = objWeb.Lists["GBMListNew"];

SPView objView = oList.Views["All Documents"];

SPListItemCollection collItem = oList.GetItems(objView);

DataTable dtSponsorships = collItem.GetDataTable();

gvGBMFormLib.DataSource = dtSponsorships;

gvGBMFormLib.DataBind();

Client Side Code:

<asp:GridView ID="gvGBMFormLib" runat="server" Visible ="true" >

</asp:GridView>

* create a button for Click event to export the Excel sheet

<asp:Button ID="btnexcel" runat="server" Text="Export to Excel"

CssClass="ms-ButtonHeightWidth" Visible="true" onclick="btnexcel_Click" />

* create override render function for exporting the Excel sheet

Declare bExport as global variable (Eg: private bool bExport = false)

Add the code in server Side:

protected override void Render(HtmlTextWriter writer)

{

if (Page != null)

{

if (bExport)

{

string stFileName = "AmexSummaryReport_";

gvGBMFormLib.Visible = true;

this.bExport = false;

Page.Response.Clear();

Page.Response.Buffer = true;

Page.Response.ContentType = "application/ms-excel";

Page.Response.AddHeader("content-disposition", "attachment; filename=" + stFileName + DateTime.Now + ".xls");

Page.Response.Charset = "UTF-8";

DateTime ct = DateTime.Now;

string currentdate = Convert.ToString(ct);

HttpContext.Current.Response.Write("<b><h1 style='Text-align:left; padding-left:65px; color: #008000; font-weight: bold; font-style: normal; font-size: large'>GABM Full Excel Summary</b></h1>");

this.EnableViewState = false;

System.IO.StringWriter sw = new System.IO.StringWriter();

System.Web.UI.HtmlTextWriter htw = new System.Web.UI.HtmlTextWriter(sw);

gvGBMFormLib.RenderControl(htw);

Page.Response.Write(sw.ToString() + "<br/><br/><b>Report Date : " + currentdate + "</b>");

Page.Response.End();

}

base.Render(writer);

}

Showing Library & List Items in Custom Grid View Web part

2012-07-30T23:30:00.002-07:00

Showing Library & List Items in Custom Grid View Web part:

pulling the library & list items data from share point 2010 site and showing in custom grid view web-part

using visual studio 2010.

C# Code To display The Library & List Items:

SPWeb objWeb;

SPSite objSpSite;

SPList oList;

objSpSite = SPContext.Current.Site;

objWeb = objSpSite.OpenWeb();

oList = objWeb.Lists["GBMListNew"];

SPView objView = oList.Views["All Documents"];

SPListItemCollection collItem = oList.GetItems(objView);

DataTable dtSponsorships = collItem.GetDataTable();

gvGBMFormLib.DataSource = dtSponsorships;

gvGBMFormLib.DataBind();

Client Side Code:

<asp:GridView ID="gvGBMFormLib" runat="server" Visible ="true" >

</asp:GridView>

Creating Form Based Authentication (FBA) Using Membership IN MOSS 2010

2012-07-19T00:56:00.000-07:00

Creating Form Based Authentication (FBA) Using Membership IN MOSS 2010
Creating new FBA Site in Share point 2010

Steps:
A) Setting up ASP.NET Forms Authentication User and Role Data Source

· Create Database

· Configure Membership and Role Provider

· Create User

B) Create Web Application and Site Collections

C) Configure Web.Config file

· Configuring FBA web application web.config file

· Configuring Central Administration web application web.config file

· Configuring Security Token Service web.config file

D) Adding User Policy to the FBA Web Application

E) Verification Steps

A) Setting up ASP.NET Forms Authentication User and Role Data Source

* Create database:

Create database in sql server and do the following steps to add membership tables, functions, procedures to the database

1)Open visual studio command prompt(2010) form Visual studio 2010 ->visual studio tools. It will open as follows.

2) type aspnet_regsql in visual studio command prompt and press enter.

3) Following screen will open in window

4) Click Next in the asp.net sql server set up wizard, and

select configure sql application server for service radio button and click next.

5) type the server name , username & password for sql server authentication , and select the database name in dropdown and click next.

6) Click next and Click Finish to complete the setup wizard.

7) Check the database that specified in above wizard for membership tables & Procedures

* Configure Membership and Role Provider

Database is created successfully. Now we need to add a user in to database. Using ASP.NET Configuration Wizard, users can be added the database. This can be achieved by creating web site that will allow us to add the users and roles and also ensure the database connection strings, membership and role providers are correctly configured before we bring SharePoint in to equation.

Below steps explains creating web site and configuring membership and role providers and executing ASP.Net Configuration Wizard.

1) Open Visual Studio 2010 and select File -> New -> Web Site. In the New Web Site dialog, select the ASP.Net Web Site template and enter the location to store the web site files.

You can choose any location whichever is comfortable for you. web.config file will be added to project automatically.

2) By default, you will see a <connectionStrings/> node within <configuration> node. Specify the connection string to the database which has been created in the previous section.

Eg:

<add name="AspNetSqlProvider"

connectionString="Data Source=hvdatabase;Initial Catalog=FBA_Users;Persist Security Info=True;User ID=sa;Password=Hexacorp123;"

providerName="System.Data.SqlClient" />

</connectionStrings>

Also add the membership provider and role provider within <system.web> tag

Eg:

<system.web>

<add name="AspNetSqlMembershipProvider" connectionStringName="AspNetSqlProvider"

applicationName="/"

type="System.Web.Security.SqlMembershipProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />

</providers>

</membership>

<add connectionStringName="AspNetSqlProvider" applicationName="/"

description="Stores and retrieves roles data from the local Microsoft SQL Server database"

name="AspNetSqlRoleProvider" type="System.Web.Security.SqlRoleProvider, System.Web,Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />

</providers>

</roleManager>

</system.web>

3) Save web.config file and launch the ASP.Net Configuration Wizard by clicking on

Website -> ASP.Net Configuration.

Set the authentication type in the above wizard. To do this, click Security link. In the Security tab, under Users section, click Select authentication type link. Select From the internet option and press Done button which is available in the bottom right corner. By selecting this option, which means that site will use form authentication to identify users.

To test the membership and role providers, click on Provider tab. In the Provider tab, click on Select a different provider for each feature (advanced) link. Select right / correct membership and role provider and click Test link to ensure that providers are communicating to right database.

At this point, we configured web.config file with connection string and providers information. Also we tested the providers with the database

* Create User

To add users, click on Security tab. In Security tab, under Users section, click Create user link. Here I am adding user as testFBA and password as password which will be used for testing form authentication later.

Now we have created a user successfully

B) Steps to create web application and site collection.

Go to Central Administration -> Application Management -> Select ‘Manage Web Application’ link present under ‘Web Applications’ section.

Click on ‘New’ option in the ribbon.

1. See the below image for ‘Authentication’ and ‘IIS Web Site’ section.

2. See the below image for ‘Security Configuration’ and ‘Claims Authentication Type’ section

3. See the below image for configuring ‘Sign In Page URL’ and ‘Public URL’ section.

4. See the below image for configuring ‘Application Pool’ and ‘Database Name and Authentication’ section.

5. Create Site Collection after creating web application.

C) Configure Web.Config Files

1. Configuring FBA web application web.config file

Open FBA web application web.config file and add the below entries.

Go to Start => Run => inetmgr.
Go to Sites => SharePoint - site => Right Click => Explore.
Open the web.config file.
Add the Following

</connectionStrings>

</providers>

</membership>

</providers>

</roleManager>

2. Configuring Central Administration web application web.config file

Open Central Administration web application web.config file and add the below entries.

Go to Start => Run => inetmgr.
Go to Sites => SharePoint Central Adminstration=> Right Click => Explore.
Open the web.config file.
Add the Following

<add name="AspNetSqlProvider"

connectionString="Data Source=hvdatabase;Initial Catalog=FBA_Users;Persist Security Info=True;User ID=sa;Password=Hexacorp123;"

providerName="System.Data.SqlClient" />

</connectionStrings>

<system.web>

<add name="FBAMembership" connectionStringName="AspNetSqlProvider"

applicationName ="/" type="System.Web.Security.SqlMembershipProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />

</providers>

</membership>

<add name="FBARoles"

connectionStringName="AspNetSqlProvider"

applicationName="/"

type="System.Web.Security.SqlRoleProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />

</providers>

</roleManager>

</system.web>

3. Configuring Security Token Service web.config file

Open Security Token service web.config file and add the below entries

Go to Start => Run => inetmgr.
Go to Sites => SharePoint Web Services =>Security TokenServiceApplication => Right Click => Explore.
Open the web.config file.

<add name="AspNetSqlProvider"

connectionString="Data Source=hvdatabase;Initial Catalog=FBA_Users;Persist Security Info=True;User ID=sa;Password=Hexacorp123;"

providerName="System.Data.SqlClient" />

</connectionStrings>

<system.web>

<add name="FBAMembership" connectionStringName="AspNetSqlProvider"

applicationName ="/" type="System.Web.Security.SqlMembershipProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />

</providers>

</membership>

<add name="FBARoles"

connectionStringName="AspNetSqlProvider"

applicationName="/"

type="System.Web.Security.SqlRoleProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />

</providers>

</roleManager>

</system.web>

D) Adding User Policy to the FBA Web Application

Follow the below steps to add user policy to the web application.

a. Go to Central Administration ->Manage Web Applications -> Select the FBA web application and click on ‘User Policy’ option in the ribbon.

b. Click on ‘Add Users’ link and select ‘Default’ as the zone and click on ‘Next’ button.

c. Type the user name created in ‘Create User’ section in the ‘Users’ textbox and click on people picker icon. You should see the user name get underlined in the ‘Users’ textbox.

d. Follow the verification steps to test form based authentication.

E) Verification Steps

1. Go to FBA SharePoint site and select ‘Forms Authentication’ option.

2. Enter User Name and Password and select ‘Sign In’ button.

3. You should be redirected to home page.

For Clarification Contact me : sugumaran.krs@gmail.com