.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 Foundation Server on SQL 2005 x64

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

Hi, i need to check the requirements for Sharepoint Foundation server.

What the client have:

SQl Server:

  • Win 2008 SP1 x64
  • SQL 2005 x64

What im suggesting:

SQl Server: 


  • Win 2008 R2 x64(Upgrade to R2 or latest SP)
  • SQL 2005 x64 (Install latest SP)


EP Server: (New server they are buying)
  • Win 2008 R2 x64
My biggest concern and question is can Sharepoint Foundation server sun on SQL 2005 R2 x64?


View Complete Post

More Related Resource Links

Problem when installing Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint


I have configured the SharePoint Production Server(Standalone) with WS 2008 64 bit version, SQL Server 2005 with SP3 , Visual Studio 2008 and MOSS 2007(SP3). I have configured SSRS 2005 in SharePoint integration mode. Everything works fine till the last step. Now, i am trying to install Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies feature and failed. I am getting below error message.

Product: Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies -- You must first install SharePoint Server before installing SQL Server 2005 Reporting Services Add-in for SharePoint Technologies

Any help will be very appreciated!


Redeploying Customizations and Solutions in SharePoint Foundation 2010 and SharePoint Server 2010

Learn how to redeploy customizations and custom solutions that you created for Windows SharePoint Services 3.0 and SharePoint Server 2007 in SharePoint Server 2010 and SharePoint Foundation 2010.

Publish Sharepoint Foundation Server to Internet

Hi guys, first of all I don't want exactly to publish SPF server to Internet, but place it in DMZ and make available from Internet. So I won't have any dedicated web server, only one server with MSSQL and SPF on it. Is there any practices to make it more secure? So far I'm only came up with form authentication... Any ideas or links are highly appreciated!

Sharepoint Foundation 2010 to Sharepoint Server 2010

Hi there, We have Sharepoint Foundation 2010 already installed on Windows Server 2008, which uses SQL Server 2008 R2 Express (64 bit). There are sites already created and Custom lists and workflows. We then purchased a Sharepoint Server 2010 license. Is there an easy way to upgrade our current sharepoint using the same Database (Content DB). How do I deploy this new Sharepoint (on top of the Foundation) Worst case scenario: I have to remove Sharepoint Foundation and then install the licensed "Sharepoint Server 2010" version Please advise

Upgrading to SharePoint 2010 Foundation on SBS Server 2008

Hi all, I've just tried to install SharePoint Foundation on 2010 on Windows Small Business Server 2008 and whilst the literature I've found suggests that this is supported, I receive the following error: SharePoint 2010 Products cannot be installed in Stand-alone mode on a Domain Controller.  For more information on upgrading, see http://support.microsoft.com/?kbid=975805. What's funny about the KB ID, is that it doesn't exist.  The pre-requisites for SharePoint 2010 Foundation installed OK and the SharePoint installer has detected that it will perform an in-place upgrade.  the STSADM -o preupgradecheck output is below. Any idea's?  It would be really great if we could start using the shared workspace and ribbon features that are inherent with SPF2010. Jason.  

SharePoint integration with SQL Server 2005 Reporting Services

Hello Everyone,   I have been banging my head against the wall with trying to integrate SharePoint 2007 and SQL Reporting Services.  If anyone could offer any assistance, I would appreciate it greatly. I have been following these 2 websites down to the letter in trying to configure everything:     1. http://msdn2.microsoft.com/en-us/library/bb326356.aspx     <---Microsoft's Steps   2. http://blogs.msdn.com/sharepoint/archive/2007/02/19/microsoft-sql-server-2005-sp2-reporting-services-integration-with- wss-3-0-and-moss-2007.aspx   <---SharePoint Blog Group     Basically my setup is as follows:   Server 1 = SharePoint 2007 Server 2 = SQL Server Reporting Services SP2 / SharePoint 2007 services Server 3 = Database   Server1 is setup and running SharePoint 2007 fine with no problems. It was installed under the complete option with its own server farm. Then with the Server2, SharePoint 2007 is installed again, also under the complete complete option, and configured to join Server1's server farm. In this way, Server2 is able to supply Server1 with services and it has been said that if you are using 2 different servers, one for SharePoint and one for Reporting Services, you need to have an instance of SharePoint on the reporting services box. With a SharePoint "front-end" the reporting-services now has a way to also join Server1s farm.   This is where the headache be

Visual Studio 2010 can't find the Sharepoint Foundation 2010 Server when compiliing, Standalone vs

I'm wondering if we installed Visual Studio correctly cos when we get into Visual Studio 2010 the "Deploy as a Farm Solution" is the only available button option and the "Deploy as a Sandbox Solution" is un-selectable, grayed out, assuming the "Sandbox" solution is the "Standalone" approach? So when we go to compile a Workflow, the error message says the Sharepoint Server is not found" Could this "Deploy as Farm Solution" be a problem when we were instructed to install Sharepoint 2010 Foundation as a "Standalone" install? in other words we're trying to find out why when we go to compile a Workflow in Visual Studio 2010 that it can't find the Sharepoint Server Step 3: Install SharePoint 2010 1.  To install SharePoint Server 2010 or SharePoint Foundation 2010, open a Command Prompt window, and then type the following at the command prompt: On the Choose the installation you want page, click Standalone to install everything on one developer workstation. Thanks very much for any suggestions, ideas or pointers! BobK

Team Foundation Server and WSS 3.0 SharePoint Service Search not visible

I am having issues with setting up SharePoint Search service on the TFS 2008 server WSS 3.0. The Windows SharePoint Service Search service doesn't appear in Central Administration>Operations>Services on Server page. Only the Central Administration, Windows SharePoint Services Incoming E-Mail, and Windows SharePoint Services Web Application appear. I have Windows SharePoint Service Search running through Services in Windows and still it doesn't appear on the page to configure it. The service account that this service running under has db_reader role access to the WSS_Content database and is a db_owner for the WSS_AdminContent and WSS_Config database as well as for the WSS_Search database. I have executed iisreset and even rebooted the server to no avail. The installation/set up of TFS was done prior to me join the team. It was a default set up with dual servers. The Event Logs show nothing out of the ordinary to help me troubleshoot the issue. Does anyone have any other suggestions I should try or other things I should be looking for? Thank you in advance, WillWill Piedmont

re: Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies

To have access to the webpart "report viewer for sql server reporting services" you can of course install Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies. My question though is, does your SharePoint 2007 server have to be running in integrated mode so as to be able to install and use the report viewer web part? Thanks.

Migrate Sharepoint Foundation 2010 to New Server


Due to unusual blue screen problems on virtual host, I need to migrate Sharepoint Foundation 2010 to a new server. Everything is installed on the same server. I have a new server stood up and awaiting data. Is it as simple as going into Backup/Restore and performing a Farm Backup and then a Farm Restore on the new server? What exactly needs to happend to get this done?


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.



Can I install SQL 2008 on a server running SQL 2005 to install Sharepoint 2010 Enterprise (Productio



Sharepoint 2010 Upgrade Question - A customer is currently running sharepoint 2007 on a 64bit windows 2003 OS with SQL 2005 sp2, they are looking to install/upgrade to Sharepoint 2010 and want to use the current SQL server,for the upgrade a new SharePoint 2010 environment will be built and for a short while they will have two instances of SharePoint running SP2007 and SP2010. The plan is to then manually migrate the data from SP2007 to SP2010 (ENT), the web and application servers will be newly built. From research I think they have three options

1) Upgrade the current SQL 2005(SP2) instance to SQL 2008 R2 standard.

2) Install a new instance of SQL 2008 R2 on the same server and have both SQL 2005 & SQL 2008 running on the same server (Is this an option? Will sharepoint happily run from a SQL server running two SQL instances, do I have to be careful regarding the installation and configuration, could I break the existing sharepoint farm doing this?)

3) Upgrade the current SQL server to SP3 and install a new instance of SQL 2005 SP3 and install SharePoint 2010 Enterprise here, again I have all the questions from point 2 above.

We are thinking of trying option 1, then 2, then 3, and obviously only moving to the next option if we come across a show stopper. H

Moving Sharepoint 2007 from Virtual Server 2005 to Hyper-V


I'm a little unsure of the exact sequence to move my Sharepoint 2007 Virtual server from VS2005 to Hyper-V.  In my enviroment, my sharepoint machine and SQL machine are on 2 different boxes.  SQL 2005 is on Hyper-V and Sharepoint is on Virtual Server 2005.  Do I shutdown the SQL VM before I move Sharepoint???   Will the new VM and SQL sync back up without any help??

Also, what happens to the SQL database if the new Sharepoint VM (on Hyper-V) has issues or problems??  Does that make my SQL server

out of sync with my old Sharepoint VM???  I have done multiple moves between VS2005 and Hyper-V so I really familiar with the process.

I usually keep the old VM around for a while after moving just in case there is a problem.   I can always blow away the new VM and crank up the old.   Viola!  I'm back to square one.

Any ideas??



Report Builder 3.0 unable to access SharePoint Foundation 2010 Report Server


I am having a terrrible time getting this to work. I have configured the SharePoint site and the SQL Servers involved to use Kerberos. That has been confirmed working.

I then configured the SharePoint site's Reporting Services integration (trusted account), enabled anonymous access and enabled report builder. I can launch report builder without any issues at all. The problem comes when I try to save my report. When Report Builder is started Items->New-ReportBuilder Report it opens and display in the lower left hand corner "No current report server." When I close the Wizard dialog and click connect I enter http://server.fqdn.net and I receive the following error:

Connection failed:

Unable to connect to the server that is specified in the URL, 'http://servername.fqdn.net/'.

Make sure that the server is running, the URL is correct, and you have permission to use the server.

I have also tried http://servername.fqdn.net/reportsserver/. When I try that I receive a login prompt. When I enter my credentials it tries for a few seconds and then sends another login prompt. I installed the report server using default settings. The reporting services db is on the same server as sharepoint. The configuration and other databases are on a remote S

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.


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?
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