.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

MS SQL 2008 SBS install fails on Server 2008 R2 Standard edition

Posted By:      Posted Date: October 22, 2010    Points: 0   Category :Sql Server

According to edition requirement (http://blogs.technet.com/b/sbs/archive/2009/03/23/requirements-for-installing-sql-2008-standard-edition-for-small-business.aspx), I thought I met the requirements but this link tells me not only I need both the standard edition AND in a domain??  I have Windows 2008 Standard R2 edition.


This is a standalone server and there's no domain.  I can promote it to be a domain controller but don't want that.  Is it the "R2" part that its failing.  I can downgrade to the non-R2 with SP2.  (Windows Server 2008 with sp2).

View Complete Post

More Related Resource Links

cannot install Microsoft SQL Server 2008 Standard Edition for Small Business

im trying to install this on MS windows Server 2008 R2 STD ED.  is says on the installation " Operating system supported for this edition " ( failed ). is it not compatible with my O.S. thank you.

SQL Server 2008 R2 fails after Windows XP Pro SP3 install

We recently encountered an issue with SQL Server 2008 R2 failing to run after the upgrade from Windows XP Pro SP2 to SP3. This was tested and reproduced (with varying results) on more than one computer. Steps to reproduce this. On a Windows XP Pro machine with Service Pack 2 installed, install SQL Server 2008 R2. Next upgrade Windows to Service Pack 3. Now upon opening SSMS or trying to start the SQL server service you receive the following message: "This application has failed to start because the application configuration is incorrect. Reinstalling the application may fix this problem". In some instances reinstalling/repairing SQL Server 2008 R2 does fix the issue.  In other cases the installer crashes and you need to use msizap to clean it up before you can reinstall.  In other cases you do not receive any errors at all. After testing in multiple virtual machines it looks like the cleaner the Windows install the more likely you are to run into this issue.  On machines with most or all windows updates (prior to SP3) installed you do not necessarily even get the failure.  On machines with just Windows XP Pro SP2 installed with no additional updates you get the failure every time. Obviously the SQL Server 2008 R2 prerequisites are installed in all cases in order to be able to install SQL server to begin with. Any help with this would be appre

In windows server 2008 standard edition feature Failover clustering is not looking

In windows server 2008 standard edition feature Failover clustering is not looking.Yet microsoft is telling that we give 2 node cluster support on 2008 server standard edition.Therefore I have suggested the company to buy it and now I am fixed due to this.  Please Help  "SQLSERVER DBA" "INDIA"

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?

MOSS 2007 Standard installation with SQL Server 2008 EXPRESS Edition server

Hello I have installed MOSS 2007 with SQL Server 2008 Express edition. Can anyone tell me what all features will be missing when compared this setup to MOSS 2007 Stanadard with SQL server 2008 lisenced editon? Specifically will I not be getting forms services with "MOSS 2007 with SQL Server 2008 EXPRESS edition"? Thanks in advance.

MOSS 2007 Standard installation with SQL Server 2008 EXPRESS Edition server

Hello I have installed MOSS 2007 with SQL Server 2008 Express edition. Can anyone tell me what all features will be missing when compared this setup to MOSS 2007 Stanadard with SQL server 2008 lisenced editon? Specifically will I not be getting forms services with "MOSS 2007 with SQL Server 2008 EXPRESS edition"? Thanks in advance.

SQL Server 2005 Standard edition install fails; An instance with the same name.../


Good Morning

I am trying to install SQL Server 2005 onto Windows Server 2003 Small Business Edition. Previously SQL Server 2000 from the SBE disk was installed, automatic updates are enabled.

I have selected the default instance and everything I try results in the error:

An instance with the same name is already installed on this computer. To proceed with SQL Server Setup, provide a unique instance name.

Log file says;

Machine         : ISAINTERNET
Product         : Microsoft SQL Server 2005
Product Version : 9.00.1399.06
Install         : Failed
Log File        : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0002_ISAINTERNET_SQL.log
Last Action     : DetectInstanceClash
Error String    : An instance with the same name is already installed on this computer. To proceed with SQL Server Setup, provide a unique instance name.
Error Number    : 28086

Ian Smith

Can't install SQL Server 2008 R2 Express Edition x64 from Command Line


I can't get R2 Express (x64) installed from the command line... x86 using this same command line works fine, just x64 is broken.

Using this:


Everytime it fails with:

2010-09-19 15:30:48 SQLEngine: : Checking Engine checkpoint 'ConfigureServiceBroker'
2010-09-19 15:30:48 Slp: --SafeSqlCommand: ALTER DATABASE tempdb SET NEW_BROKER ALTER DATABASE msdb SET NEW_BROKER
2010-09-19 15:30:48 Slp: Sco: SqlException: Message:The operating system returned error 38(Reached the end of the file.) to SQL Server during a read at offset 0000000000000000 in file 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\Template Data\MSDBData.mdf'. Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Onlin

SQL Server 2008 R2 Setup fails to install properly


Hello, I am not able to install 2008 R2 on my laptop. I have 2005 and 2008 installed previously. It says in one of the attached screenshots that the OLAP service cannot be started. I have attached the errors in screenshots and also my summary log, please advise thank you.

Edit: I am able to manually startup the SQL 2008 R2 service, and can login as "sa" without a password... but strangely I did select mix mode authentication and did supply a password during the installation wizard too..


Overall summary:
  Final result:                  SQL Server installation failed. To continue, investigate the

reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server

  Exit code (Decimal):           -733426222
  Exit facility code:         &nbs

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

SQL Server 2008 R2 Standard edition running from one Core


Hi, I have a client who we just upgraded to Win 2008 R2 Standard Edition and SQL 2008 R2 Standard Edition

They are complaining about System performance. 

Looks like SQl runs only on 1 core, maybe sometime 2 which is maxed out.

"Automatically set Processors affinity mask for all processors" is checked and also

"Automatically set I/O affinity mask for all processors" is checked...

The server was maxed out with memory a few days ago but looks to me that that is something taht SQL 2k8 R2 does. The server has got 16GB ram

Pretty urgent. Got 3 hours to solve it.



Failures in running Repair for 2008 SQL Server standard edition


Dear users,

2008 SQL Server Standard edition.


While running Repair I got below failures,

1. Upgrade failed due to the following error. The error code is :-214747259.Message:Unspecified error

2. The process cannot access the file 'C:\Windows\system32\perf-SQLSERVERAGENT-sqlagtctr10.0.1600.22.dll' because it is being used by another process.

3. The service did not start due to a logon failure.

I wonder what causes the failures and what I should do to fix them.


Could you tell me what to do?

Thank you,


Upgrade SQL Server 2008 Standard Edition to 2008 R2

I'm trying to find the right down load to use to upgrade SQL Server 2008 Standard Edition to Standard Edition R2.  This is the first upgrade I've done for SQL Server and I can't find any download for R2 that is specifically for Standard Edition.  Can anyone point me in the right direction please?

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

Will SQL Server 2008 Developer Edition install on Windows 7 64-bit Professional? OS not listed on re

I just purchased Windows 7 Professional  for installation on an Intel 64-bit laptop. I planned on purchasing SQL Server 2008 Developer Edition but noticed that Windows 7 Professional is missing on the requirements list. 

I was hoping someone here could verify that SQL Server 2008 Developer Edition will install on the OS mentioned above. 

Here's the requirements page I was viewing:


Preventing SQL Server 2008 Express install fails


I'm working on an installer, that installs SQL Server 2008 Express SP1 (soon I will upgrade to SP2) silently, so that my customers can install it without making choises. It all works fine, except of course when the SQL Server installer fails for some reason.

I start the installer with the following parameters:

/QUIETSIMPLE /ACTION=Install /Configurationfile={tmp}\sql2008setup.ini

The ini file simply looks like this:


I do not wish to keep coding my installer reactively, meaning I want to take care of install issues before they happen on the customer side. Therefore I would like to ask here, and find all possible error scenarios, and code my way around them.

I have read the Installing SQL Server 2008 article, but I still have some questions.

This is what I have come up with for my installer so far:

   1. Only install on OS equal or higher

SQL Server 2008 Express Management Studio fails to install because it thinks visual studio is instal


I tried to install SQL Server 2008 R1 Express with Tools on Windows Server 2008 R2. It installed, but the management studio failed to install because it said I already had Visual Studio installed and it needed Visual Studio service pack 1 before Management Studio could install.

Visual Studio is nowhere to be found in Programs and Features, and when I try to install Visual Studio SP1, it won't install, saying:

A compatible version of Visual Studio 2008 was not detected on the system. This update is designed for only the Microsoft Visual Studio 2008 (ENU) product family, and is not compatible with any Express editions.

Though I can't find any Express version of SP1 to try, and there is no SP1 in windows update.


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