Business Connectivity Services is a set of services and features that connect SharePoint-based solutions to sources of external data.
This post will explain how to create Microsoft Business connectivity service instance for SharePoint 2013 Farm.
Make sure that you have SharePoint 2013 enterprise license.
You need Farm administrator rights to create BCS service
Need new service account to run BCS service (Add it to SharePoint managed accounts)
Go to the SharePoint Central Administration website for your farm.
On the Quick start menu click “Application Management”
On the “Application Management” page under “Service Applications” click “Manage service applications” as appear in below image
On the “Service Application” tab, click “New” and then select Business Data Connectivity Service from drop-down menu.
Enter the name of the service as you want In the Service Application name box
Leave the database name and database authentication as windows based, unless you have specific design to change them.
If you have SQL Server database mirroring configured and you want to include the Business Data Connectivity Service database in mirroring, provide the name of the failover database server in the Failover Database Server box.
Keep the failover database values empty unless you have database mirroring in-place and want to do mirroring on BCS database.
Provide the “Application Pool” name and service account credential. It is recommended to create new application pool for service applications.
Click “OK” to create the new Business Data Connectivity Service Application and in the next screen click “OK” again
Once it is created use will see it listed in “Manage service application” page
Select the row that the Business Data Connectivity Service Application is in, click Administrators in the Operations area and add any accounts that you want to be able to administer the ”Business Data Connectivity” service application granting them full control.
On the “Application Management” page under “Service Applications” click “Manage services on server” as appear in below image
Start the “Business Data connectivity service”
On the “Application Management” page under “Service Applications” click “Manage service applications”, select the newly create service and click “Manage”, you will see the following screen.
The Business data connectivity service application is created and ready to used!
The installation of workflow manager for development environment can be done on single server SharePoint 2013 farm, but it is highly recommended to install it on separate server for UAT and production environments.
You need local admin rights on the server where you will install the Workflow manager.
Please make sure that Visual studio 2012 Instance is not running and all devenv.exe processes are closed.
Make sure that you have Visual studio Update 2 installed
Navigate to http://www.microsoft.com/web/downloads/platform.aspx and download and download Microsoft Web Platform installer 4.5 (If you don’t have already installed)
Install Microsoft Web Platform installer 4.5
Launch the Microsoft Web Platform installer 4.5
In the top right corner search box, enter “workflow manager”, you will see the following results
Click “Add” button to the following items
Workflow Manager 1.0 Cumulative Update 1
Workflow Manager Tools 1.o for Visual Studio 2012
Workflow Manager 1.0
You can view the” Item to be installed” to make sure that you have added the right items
Click “Close” , it will take you ro the previous screen
Click “Install” button
Press “I Accept” button and the workflow manager instalaltion process will start
After some time you will see the following screen
Fill the below information according to your environment and press Click next arrow button.
You will see the summary page, Press “Check” button and workflow manager configuration wizard will be started
Once the Configuration process is completed, you will see the last screen
Once the installation completes go to IIS 7 manager and start the “Worklfow Management Site”, if not started.
Create a site colleciton in sharpoint and register Wrokflow service with it using powershell command
Register-SPWorkflowService -SPSite “SharePoint site collection url” -workflowHostUri “workflow host site url with port” –AllowOAuthHttp
Workflow Manager communicates by using TCP/IP or Named Pipes. Make sure that the appropriate communication protocol is enabled on the SQL Server instance that hosts the Workflow Manager databases.
The SQL Browser Service must be running on the SQL Server instance that hosts the Workflow Manager databases.
Welcome to SharePoint 2013, the new way of building workflows
I have just enabled SSL on our live intranet site and run the full crawl to index everything to https rather than http. Everything works fine apart from default page. It shows error, when I checked the log file it shows the following error details.
GetFileFromUrl: ArgumentException when attempting get file Url http://site url/_catalogs/masterpage/ PageLayoutName.aspx Value does not fall within the expected range.
During further investigation I found that the default page “Page layout” was still referencing to http address. The below script will update default page “page layout” URL.
$spWeb = Get-SPWeb("https://site collection URL") $spFile = $spWeb.GetFile("https://site collection URL/Pages/default.aspx") $spFile.CheckOut("Online",$null) $spFile.Properties["PublishingPageLayout"] = "/_catalogs/masterpage/SCI_HomePage.aspx, Block" $spFile.Update() $spFile.CheckIn("Update page layout via PowerShell",[Microsoft.SharePoint.SPCheckinType]::MajorCheckIn) $spWeb.Dispose()
In one of my previous post I mentioned how to clean the SharePoint 2010 web application before upgrade to SharePoint 2013.
In this post, I will explain what Information in required from SharePoint 2010 Farm during the SharePoint 2013 upgrade planning.
The following information need to be capture from your existing SharePoint 2010 Farm.