.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

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

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


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

View Complete Post

More Related Resource Links

Cannot install Sharepoint Server 2010 "A previous installation has been detected with a license type

I'm trying to upgrade to Team Foundation Server 2010 and Project Server 2010. After getting TFS 2010 and Project Server 2007 to work with WSS 3.0, I started upgrade to Project Server 2010 which requires update to Sharepoint Server 2010 Enterprise. I installed pre-requisites and run "stsadm -o preupgradecheck" which passed everything. When I tried to run the installation I get Setup Warning "A previous installation has been detected with a license type that does not match the install in progress". I thought that my trial licence for Project Server 2007 stopped this so I completely uninstalled WSS 3.0 and restarted the server but the installation still stops with Upgrade window. Any ideas? Regards    mjsk

Can't install SQL Server 2008 Enterprise on Windows 2008 Enterprise

A new fresh Windows 2008 installed and install all avaliable updates. Then install SQL server 2008, it firstly install some update too. Then reboot and run setup.exe again, it always give me the following message:Managed SQL Server Installer has stopped workingWhat's wrong with it? how to solve this issue?

Can you install SharePoint 2010 and User PerformancePoint in a single server enviroment?

Hi I Installed SharePoint 2010 in a single server farm and I configured a Performance Point service aplication. Whenever I run dashboard designer it seems to work but it eventually crashes. I don´t know if I have any configuration errors. I read this Run the Secure Store Service on a separate application server that is not used for any other service. Create the secure store database on a separate application server running SQL Server. Do not use the same SQL Server installation that contains content databases. Here http://technet.microsoft.com/en-us/library/ee806889.aspx I believe this service is necesary to run connect to data sources does this mean it all cannot be run in the same server.

HTTP 500 After Sharepoint 2010 Install on Win 2008 R2

Environment specifics: Windows 2008 R2 SQL 2008 (Version: 10.0.2746.0) No internet connection so I installed all the prerequisite software. I have two domain accounts: SPAdmin and SPFarm SPAdmin is what I use to install Sharepoint. SPFarm runs the app pool, timer service etc. Domain: Development domain. Scenario: After the SP Setup Wizard, Central admin is inaccessible and gives a HTTP 500 error. I checked the recommended permissions for both accounts and they both appear to be in the correct groups. The only way I can get it to work is to add the SPFarm account as a local admin. So it appears to be a permissions issue. But I can't figure out what the issue is or even where to start. Any advice would be greatly appreciated.

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  

How to install Sql server 2008 Enterprise edition in windows 7 (32 bit system)

am install Sql server 2008 SP1 But same Problem again Plz Give me Reply Plzzzzzzzzzz Which edition Support in windows 7?

Silent install of SQL Server 2005 fails when SQL Server 2008 is installed


We currently install SQL Server 2005 Express silently during our installation, using the following switches


We also attach a 2005-created database immediately after using the following command line (^ is a path concat operator in Installshield):

sqlcmd.exe -S .\\SQLEXPRESS -E -i \"" + svConfigPath ^ "SetupUapDB.sql\" -vmdfpath=\"" + svConfigPath ^ "UapCfg.mdf\" -vldfpath=\"" + svConfigPath ^ "UapCfg_log.ldf\" -o \"" + svConfigPath ^ "SqlCreateDB.txt\" -e

Note that we do not specify an instance name.  We ran into a situation where someone had installed SQL Server 2008 on a box using a default instance name and our install then failed.  I am considering 2 possible fixes, and have questions for both.

Fix #1: Specify an instance name.  Ideally this would install SQL Server 2005 Express side by side with SQL Server 2008, create a unique instance name and we'd be good to go right?  If yes, what is the accepted convention for specifying instance names?

Fix #2: Not sure if this is possible.  Can we detect if SQL Server 2008 is on the box, and if yes, apply our 2005 database to it instead?  In this case (tell me

How can I install Features into the Sharepoint 2010 Server Standard after the install?


I have installed SharePoint Server 2010 Standard. We are testing the functionality of the new system and what it can do. I got an upgraded copy of the HelpDesk and Knowledge Base Templates (Part of the Fab 40) from http://techsolutions.net/Blog/tabid/65/EntryId/17/Fab-40-Templates-for-MOSS-2010.aspx. They seem to be good, but there is a feature that is in the Server that is not installed that I need to be able to get both of these working.

The feature is: Web Analytics Customize Reports functionality (Display Name: WACustomReports).

I need to be able to get this feature installed and activated so that I can use these 2 templates. Is there someone that can help me with this issue?

NOTE: I have tried to use the command line for SharePoint Power Shell. It is not working. The files that it is looking for are not on the HDD where they should be.

Why I can't install Project Server 2010 on my SharePoint 2010 Server?


I recently installed on my server SharePoint 2010, SQL Server 2008 is on another box and all seems to work fine, except that when I try to install Project Server 2010 it keeps telling me that I need ton install SP 2010.

I already checked that the required edition of SP is the Enterprise, as far as I remember that is the edition I activated because I used the Product Key for the  "SharePoint Server 2010 For Internet Sites Enterprise", but to double check this (and correct it if I am wrong I went to the 'Convert License Type' page and not only it does NOT show what my current license is (information is empty), but also the box to type a new Key is disabled, so I am not allowed to try to change the one used.

Can anybody tell me what is going wrong?

DNS Server to install Sharepoint 2010


do I need to install/add role of DNS Server on windows server 2008 to install sharepoint 2010. Can someone guide me to step by step guide to install Sharepoint 2010?

Install fails wth SQL Server 2008 Enterprise on Windows Server 2008 R2


I have a new server onto which I have installed Windows Server 2008 R2 Enterprise. I have not been successful at installing SQL Server 2008 Enterprise on it. After many attempts, I continue to get the following error message:

        Microsoft .NET Framework 3.5 installation has failed.
        SQL Server 2008 setup requires .NET Framework 3.5 to be installed.

Some notes:

  • I got my copies of Windows Server 2008 R2 and SQL Server 2008 Enterprise through my MSDN subscription.
  • Upon first installing WinServer2008 R2, I notice that the .NET Framework 3.5.1 is not installed and is not available as a feature to add through the Programs and Features control panel.
  • Upon first installing WinServer2008 R2, Server Manag

Want to install Sharepoint 2010 and RDS Gateway on same server, multiple questions


Background:  SMB environment, only have 4 servers.  Want to run SharePoint 2010 Foundation and RDS Web Access and RDS Gateway on same 08R2 server.

1. which one to install first, WSS or RDS?  Either one will install IIS and build and bind to the default website, so does it really matter which one goes first?  I seem to remember on old server installing TS WebApp and Gateway first, then WSS3, and TS WebAccess stopping until I added the host header to WSS.

2.  how to enable HTTPS access to both WSS and RDS WebAcess/Gateway?  this failed on a previous server, which I am now migrating to new hardware/OS.  RDS Web Access and Gateway use the default website.  I can make WSS work http with a host header, but not https.  on old server everytime I enabled an https AAM for my WSS site it stopped the TS Gateway service, but I only had one NIC on that server at the time.  My new server has four NIC's.  So, would a valid solution be to restrict the default website (RDS Web Access and Gateway) binding in IIS to one NIC and then restrict the WSS site to another?  I seem to remember adding a NIC to the old server and trying to change the default site binding from "all unassigned" to just one IP and TS Gateway stopped, but I could be imagining that, it's been a while.


install Sharepoint foundation 2010 with windows 2008 WEB and Sql 2008 Web Edition



i wonder if it possible to install Sharepoint foundation 2010 with windows 2008 WEB and Sql 2008 Web Edition,





Constant 'server restart pending' whenever I try to install Sharepoint Server 2010 Beta


I've installed all the prerequisites just fine, but every time I run the main installation program it tells me:

"Setup is unable to proceed due to the following error(s):

A system restart from a previous installation or update is pending. Restart your computer and run setup to continue."

After restarting, and doing nothing else, I run the setup again to get the same result.  There are no pending restarts, Server Manager itself normally complains if there is a restart pending, so I don't know where it is getting this from.

THe next thing I will try is to give it a little more RAM in case it makes a difference; the virtual machine currently has 4GB overall and has a few other minor roles as well.  But it would make sense for the installation program to say that instead of telling me it's a reboot.


Dev Lunsford

Install Sharepoint 2010 on server farm


Hi All,

I am trying to install Sharepoint 2010 on my machine using server farm.Steps I performed are:

1.Installed Sql Server 2008 R2

2.After installing Sharepoint 2010,I ran Sharepoint 2010 Products and Configuration.I selected "Create a new server farm".On the next screen I gave Database Server - local;Database Name - Sharepoint_Config;Under Specify Database Access Account,I entered my windows credentials Username-Siddharth-PC\Siddharth AND Password - my windows password.After this I am getting an error - "The specified user Siddharth-PC\Siddharth is a local account.Local accounts should only be used in stand alone mode.

I am stuck here.Any kind of help will be appreciated.




SQL Server 2005 fails to start after install on Server 2008 R2 SP1 64-bit


New install of Server 2008 R2 64-bit upgraded to SP1.

I have SQL Server 2005, no matter how I install it, it fails to start the main SQL Service giving me the error:

"The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually.""

It then rolls back just that portion of the install and completes the install. I thought the following article might be the ticket, but no matter which SQL Server 2005 SP I try this with or which method they describe (reducing processor count, etc), I get the same error: http://support.microsoft.com/kb/954835/en-us

Is it SP1 on Server 2008 R2 that is the problem? I have found various articles online speaking of pretty much the same issue, but these are posted before SP1 and people seem to be able to get things working.

Any thoughts?

Install SQL Server 2008 R2 Enterprise on Windows Server 2008 R2 64 bit problem.



I am installing SQL Server 2008 R2 Enterprise Edition 64bit to Windows Server 2008 R2 standard (64bit) on VMware Virtual Machine.

The OS version is 6.1.7601 Service Pack 1 Build 7601. Processor value shows "Interl(R) Xeon(R) CPU.

On the "Installation Rules" page, it shows the status of "64-bit processor" and "64-bit operating system" are  is "Not applicable". Click the link to see details, it shows "... rule is not applicable based on your system configuration or selections.".

I have checked the forums, and see someone asked the same question but the answer was to ignore it. The installation was completed, but I can see both 32bit and 64bit folders (\Program Files (x86) and \Program Files) have files installed on "Microsoft SQL Server". So, I don't know it is exatly 64bit or mixed with 32bit and 64bit.

Is there anything wrong on my server's setting?


Xiaogang Zheng

Xiaogang Zheng
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