Failed to create a database. An exception of type System.Data.SqlClient.SqlException was thrown. Additional exception information: Could not find stored procedure ‘sp_dboption’. – Error Occurred when Installing SharePoint 2010 in SQL 2012.

got a new server for my Test environment and started creating a lab of SharePoint 2010 in it with SQL Server 2012 R2. everything went smoothly until I start Configuration Wizard. It came to the 3rd Level and Error Occurred suddenly saying – Failed to create a database. An exception of type System.Data.SqlClient.SqlException was thrown. Additional exception information: Could not find stored procedure ‘sp_dboption’.

image

After thinking a while realized that my setup was just SharePoint 2010 RTM which is None SP. since my lab is brand new thought of trying on installing SP1. just downloaded and installed the SP1 for SharePoint 2010 and started the wizard again.

Everything Gone perfect after SP1. further when reading understood that it’s must to have SP1/above for SharePoint to install in SQL 2012.

Download SharePoint SP1 here – http://support.microsoft.com/kb/2460045

All SharePoint Updates are here – http://technet.microsoft.com/en-us/sharepoint/ff800847.aspx

Integrate Search Server 2010 Express with SharePoint Foundation 2010 – Get the Maximum out of Foundation Functionalities

Empowering your SharePoint Foundation farm through an readily available Add-on which will make more worth of continuing is the prime goal of writing this article.

Note : This Testing has been carried out in SharePoint Foundation 2010 with SP2 and Search Server Express 2010 Full version which was functioning as expected. 

Advanced Search was one of the most utilized feature in SharePoint 2010 for me in last few years in my SharePoint Experiences. 70 % of our projects I have used Search Solutions for my clients. however though we have enterprise clients across the world, there are lot of medium and small level clients as well so having SharePoint Enterprise or standard may block their interest of SharePoint in Financial Perspective so still there are considerable number of organizations across the globe which are using SharePoint Foundation/WSS 3.0.

thought of writing this after one of my testing carried out to discover the power of Search Server Express 2010 which can be integrated with SharePoint foundation 2010. the objective is to discover the capabilities of Search Server Express with SharePoint Foundation 2010 which would be helpful for the foundation crowd out there.

as you already know, Foundation edition of SharePoint does not capable of providing customizable searching or it’s interface since there is no Search Application as it is embedded with an windows service so the whole thing is automated (Schedules/Content Sources/File Types etc..). no wonder that this is Foundation but you can keep faith on yet an extremely good news which is Search Server Express 2010.

Search Server Express is an Separate Setup that you can Download here. This is the Full Version. this addition will install not only the Search Services but also Secure Store Service and Web Analytics Services which are really useful and makes SharePoint foundation More shined. many techies still worries about not having these core features in foundation and thinks that they have to pay for Search Server also but not really, Search Server Express totally free with few limitation but yet really useful and almost covered as same as enterprise.

right after this deployment, you will be able to experience below capabilities on your foundation setup.

1. Search Service Application (Create Search Service Application and customize as you want which is same as Enterprise). Manage Content Sources, Define File Types, Search Web Parts Such as Advanced Search Box.

2. Web Analytics Services

3. Secure Store Service

So lets start with the deployment. I have an SharePoint foundation farm back ending SQL Express 2008 R2 which is in a Single Server. this post I will start with the Search Server Deployment.

Normally these are the only service applications you have in SharePoint Foundation 2010. additionally BDC is there which you can create via New –> Service Application

image

Starting with setup by just click on Install Search Server Express is the first step once you done with the prerequisites. make sure you have the internet on server during the prerequisites installation.

clip_image002

Accept the License Agreement as usual to proceed.

clip_image001 

Change the Program path if you need it to be installed in another location as the default goes to C: Drive and just hit Install to start.

clip_image003

Give it a moment. this wont take than 5 Minutes if you have proper resources on server.

clip_image004

Config Wizard will automatically pop-up right after the installation. leave the tick box selected to run the wizard (this will make your IIS reset for several time during the process)

clip_image005

Just Click Next

clip_image006

the summary will be here so again “Next” to go.

clip_image007

Leave it for few minutes. not more than 5-6 minutes again.

clip_image008

That’s all and we done the installation and Search Server Express is now integrated to your SharePoint farm.

clip_image009

Let’s check out whether we got it as expected. indeed, direct to Service Applications through Central Administration and you will realize that you have few more Service Applications available for creations. isn’t this the greatest news for foundation crowd ever heard of?

clip_image010

As next let’s go to ‘Services of Server’ through the CA and we are now about to start our New Services (SharePoint Server Search, Web Analytics Service etc.. which are newly embedded through Search Server Express deployment)

clip_image011

Let’s Start the Search Service as same as we do in SharePoint Enterprise. I’m filling Service Credentials, Names of DBs, Schedules of Crawling etc..

clip_image012

Now to Configure Search Service Application which is also identical as same as Enterprise. so far I’m so excited !!. hit OK to create the Search Service Application.

clip_image013

Give it a moment. indeed again this depends on your server’s performance. coming in to mind that you are on an enterprise environment, yes I am.

clip_image014

Alright we done with it as this resulting “Succeeded”

clip_image015

Get in to Service applications and you will see our newly created Search Application is started there.

clip_image016

click on it and get in to the configuration panel. you will see all the capabilities such as File Types, Content Sources, Crawl Log etc.. which are about to shine your Foundation Farm here after.

clip_image017

clip_image018

clip_image019

let me now check the Service Connection mapping of my web application though CA –> Service Connections for Web Application in order to try with searching.

clip_image020

Starting a Crawl for my default content source to check out on searching.

clip_image021

meanwhile I would Enable Site Collection Level Search Features. I’m activating Search Server Web Parts here. this is totally same. more Excited !

clip_image022

And Search Settings from CA –> Site Collection Administration

clip_image023

You would see the familiar Search Settings Page as same as enterprise.

clip_image025

alright, Now the interesting part where we are going to add an Search Web Part to a page. by just editing a newly created web part page –-> Insert –-> Web Part –-> Search Web Parts -–> Advanced Search Box. there will be lot more web parts which are were limited only up on SharePoint Standard such as Advanced Search Box, Refinement Panel, Search Box, Search Statistics, Search Core results, Federated Results etc..

clip_image024

done with adding Advanced Search Box to my web part page as you see below so what are we waiting for ? let me search something as I guess it has completed crawling which I already started in an earlier step.

clip_image026

it is it is … !!! we are now having Advanced search functionality in our Foundation setup.

clip_image027

hope this was a great news and tip for SharePointers out there and will come up with next post soon ..

August 2013 Cumulative Update Now Available for SharePoint 2013

If your SharePoint 2013 Farm is just RTM, Make sure that you have installed March PU prior to the August Update as it’s mandatory to proceed with future updates.

If you aren’t having March PU, you wont be able to proceed with any later updates and below error will pop out.

“The expected version of the product was not found on the system”

image

KB 2817517 – SharePoint Foundation 2013

KB 2817616 – SharePoint Server 2013

KB 2817521 – Office Web Apps Server 2013

KB 2817507 – SharePoint Designer 2013

KB 2817615 – SharePoint Server 2013 with Project Server 2013

Note :

Anyway what’s the difference between PU and a CU package. Stefan Gobner has written a informative article for TechNet which I would suggest you to refer on this.

Further information, for Farm which are having Search Components and Highly available search topologies are enabled across servers refer to Kirk Stark’s Article on How to install update packages on a SharePoint farm where search component and high availability search topologies are enabled (which is well described)

Unable to Run PowerShell Scripts on Windows PowerShell–“Execution of scripts is disabled on this system” Error Occurred.

Tried to execute a PowerShell script in one of my test server (windows server 2008 R2) and got an error saying Execution of scripts is disabled on this system.

Note : Basically this policy helps you to prevent untrusted scripts which can be affected to Production/critical environments. you may revert back to default once you done with your scripts if it is and critical server on production in order to prevent untrusted affections.

clip_image001

Running below line on PowerShell fixed the point and PowerShell was back to work.

  1. Set-ExecutionPolicy Unrestricted
  2. Type ‘Y’ and Enter to agree and proceed

clip_image002

Note : Run below line to revert back the policy setting to default.

Set-ExecutionPolicy Restricted