.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Sharepoint 2010 and SQL Express. Limits in functionality yes or no ?

Posted By:      Posted Date: October 24, 2010    Points: 0   Category :SharePoint


Does somebody know of any limits in sharepoint 2010 related to the use of sql express ?
Suppose an install of Sharepoint on Windows server 2008 R2.

I dont want the list of sql express limits (10 GB DB size, 1GB RAM use, 1 CPU limit and everything else found on the SQL web site).

I want a list of things that will not work in Sharepoint if I use SQL Express. If there is nothing on that list then fine but I would be surprise.



View Complete Post

More Related Resource Links

Quotas and Limits in SharePoint 2010

I upload pictures to the gallery in Sharepoint 2010 but it only allows me to upload a max  of 100 at a time.  Is there a setting I can change to make it 200 instead?

SharePoint Search Server 2010 Express returns no search results for non-admin users

This is going to sound crazy, but anyway... bare with me... I have a SharePoint Search Server 2010 Express (RTM) installed with a crawl account (call it sharepoint_crawl) which has full read permission to an entire site collection of 100,000 documents. I have logged in with this account to make sure it has read access to everything, and it does. I run a full crawl of all documents and allow it to finish. If I try and search the content for an extremely common term (i.e. 50,000+ hits) I get no results. However, if I log in with a site collection admin I do get search results. There are no indexing errors or query errors in either log files or event log. Everything looks like it is working correctly - just no results for non-admins Anyone tripped on this? I have recreated the crawl account and perform a full re-index with the same results. What gets me is that the crawl account does have read permission to the content it is indexing, the content is indexed correctly, but the crawl account cannot get results back. It is as if security-trimming is removing everything. Any ideas?

Purpose of initial "site" in SharePoint Server 2010 Express Install

I’m installing Search Server 2010 Express using “Farm” mode. After the SharePoint Configuration Wizard completes, and selecting  the SharePoint config wizard, one needs to create a website. What is that site intended for? Is it for the Search Center itself? (If so, then I better select the Enterprise – “Basic Search Center" template. If it is intended for a "normal" top level site, then I will create a new Search site in its own web app). TIA, Barkingdog  

Sharepoint 2010 Foundation with Search Server Express


I have Sharepoint 2010 Foundation with Search Server Express installed. The Sharepoint was an upgrade from WSS v3 and search server express 2003.

After the upgrade whenever users search from the main site I get web part errors displayed on the search page. I think because it is trying to use the old search server express which is no longer installed.

Search Server Express 2010 is now installed and a Search Center web page can be viewed however when searching via the entire sites I site the web page with web part errors.

Any thoughts or any further information you require I can provide.

Sharepoint Foundation 2010 and Search Server Express


Can I get some clarification on a couple of points?


Firstly, what is the recommended installation path for SPFoundation and Search Server Express on the same server.  Do I just install SSE 2010?  Or SPF 2010 and then SSE 2010?

Secondly, when the two are installed together how do I add the a SSE 2010 search center link to my SPF 2010 site so I can search all crawled content?  I've created crawls of Exchange public folders and file shares but when I use the built-in site search box it's only returning content crawled from the local site and not anything from the other crawls.



SharePoint 2010 Foundation - Standalone - SQL Server Express 2008 R2 - Moving databases to another d


Setting up a new install who will be using SharePoint Foundation 2010 in Standalone mode. They do not have SQL SERVER 2008 so need to utilize the Standalone option and the latest version of SQL Server 2008 Express R2. They are just getting started with SharePoint and it is unknown how much the technology will be embraced to afford to purchase SQL Server at this point. I wanted to get that explanation out of the way before everyone tells me the best practice of installing in Farm mode only! I realize the best practice but sometimes we have to roll with the punches because getting a client to begin using SharePoint on their current budget is better than never getting the chance to use it at all.

So SharePoint Foundation 2010 is installed with the default SQL Server 2008 R2 Express instance. Is there a procedure for moving the databases to a new drive? What is the default instance name that is created? I'm having a hard time locating that information in the documentation. I've done this before with WSS 3.0 without issue but wondered if there were any documents on moving the newest databases and what the default instance name is. Thank you in advance.


Sharepoint 2010 custom .aspx page for custom functionality





I want to include a custom .aspx page with code behind in sharepoint 2010. This aspx page is supposed to take data 
from custom list and generate an xml. So the output is xml. Our site is an internet facing site and it is anonymous
access. Some swf files are using this aspx page to get dynamic data from list in xml format. When flash is trying
to get xml from this page sharepoint first redirects to login page. I need help from you guys, since I am new in sharepoint I got really struck here.

Thanks in advance,
Jiju Alex.

Integrating Sharepoint Foundation 2010 and Search Server Express

I've been searching for ways to do this but I haven't come up with anything.  Surely this is a very common need/want.  Basically I want to use Sharepoint Foundation 2010 but I would like to run Search Server Express in the same installation.  Additionally instead of going to a dedicated search page and then searching, I'd like to add the Search Server Express search functionality as a Web Part to the Sharepoint Foundation home page.  Is there any documented procedures to this?  If not how have you done it?

Bug? AssetURLSelector functionality changed in SharePoint 2010...



After upgrading a site from SharePoint 2007 to SharePoint 2010, we have encountered some problems with the AssetURLSelector which is a graphical pop-up control for browsing files and lists etc. within the specific site collection.

In SP2007 when selecting a list with this selector, the following URL was returned: /se/top/events/Lists/Eventslist/AllItems.aspx
This is fully compatible with the SharePoint function SPWeb.GetListFromUrl.

In SP2010 when selecting the same list, the AssetURLSelector instead for some strange reason returns the URL on the following format: http://localhost:82/se/top/events/Lists/Eventslist

Difference 1: The complete URL including domain is returned. This generates errors in our SharePoint solution since the domain differs between for instance authoring and live environments. The relative path is instead needed here as it used to be in 2007...

Difference 2: The AllItems.aspx is excluded if you make the selection from the tree-view to the left which causes an exception when using the GetListFromUrl

Sharepoint 2010 Foundation vs Search Server 2010 Express


Does Search Server 2010 Express include Sharepoint Foundation? Or do I need to install Sharepoint first and then install Search Server on top? This is for a brand new install on a single server.

SharePoint 2010 Foundation - How To create PressRelease functionality




I need to create means to create pressreleases. In SharePoint 2010 Standard/Enterprise that isn't such a big deal. I create a pagelayout et voila. Seems that Foundation does not provide this functionality.

My Questions:

  1. Is this correct?
  2. If not how can I create this functionality?

I already found this link but...



Reporting services and Sharepoint Foundation 2010 + SQL Server 2008 R2 RTM - Express with Advanced S



is possible use reporting services in Sharepoint Foundation 2010 if I have installed SQL Server 2008 R2 RTM - Express with Advanced Services? I tried various settings and configurations, but it not works (I am not able successfully configure Reporting Services Integration in Central Administration).

Now I am not sure that is possible use reporting services in SPF 2010 + SQL Server 2008 R2 RTM - Express with Advanced Services...

Thank you!

Move SharePoint Foundation 2010 database from SQL 2008 R2 Express to SQL 2008 R2 Standard.


Currently, our Sharepoint Foundation 2010 's is installed in same server with SQL 2008 R2 express hosting the databases. We would like to move all the Sharepoint Foundation 2010 database to a new SQL 2008 R2 Standard Server. Can it be done?

In this technet document, http://technet.microsoft.com/en-us/library/cc512725.aspx, it stated "The new database server must be running the same version of Windows Server and Microsoft SQL Server as the existing database server." Does it mean that I cannot move the database to  SQL 2008 R2 Standard Server?

Web Bot Functionality not included in Sharepoint 2010... Why?


1. First question is why have they took this functionality out of sharepoint 2010 when you can still technically use it in sharepoint deisnger 2010?

2. In my sharepoint 2007 site I had 2 pages set up for basic anonymous submission of suggestions, no way to track who sent it which is why I chose to use it. By using basic HTML form with a name and suggestion field and a HTML submit button that had a mailto:assignment to go to a suggestions email box. I can no longer use this because Web Bot has been removed from Sharepoint 2010...

Is there another way I can do something simple like I had before or are things going to have to get complicated to do something so seemingly simple... Any information would be appreciated.

SharePoint Foundation - Search Server Express 2010 "upgrade" ?


I have an existing install of SP2010 Foundation. Can I just install Search Server Express 2010 on the WFE server and connect it to the existing farm? Or can I "upgrade" SP2010 Foundation to Search Server Express 2010?




Sharepoint 2010 Central Administrator giving 500 error w/ TFS 2010 & SQL 2010 express


I've been reading about this issue all day.  Some have said it's the DB and others have offered up Failed Request Tracing but nothing is working.  We have a standalone server running SharePoint 2010, TFS 2010 and SQL Express 2010.  Everything has been fine for a few months but now it appears that the SharePoint side is down.  Developers are able to check in code and work with TFS with no problem but as soon as anything dependant on SharePoint is accessed it throws a HTTP 500 error, this includes the Central Administrator.

When I run any Powershell I get this:

Get-SPFarmConfig : Microsoft SharePoint is not supported with version 4.0.30319
.1 of the Microsoft .Net Runtime.
At line:1 char:17
+ Get-SPFarmConfig <<<<
    + CategoryInfo          : InvalidData: (Microsoft.Share...etGetFarmConfig:
   SPCmdletGetFarmConfig) [Get-SPFarmConfig], PlatformNotSupportedException
    + FullyQualifiedErrorId

Short Overview of SharePoint Features in Visual Studio 2010

As you probably know, Visual Studio 2010 was announced earlier this week and it contains a lot of cool features and project templates for SharePoint developers. Below is a short overview for some of the SharePoint development related features and project templates.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend