.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

Enterprise/Standard multi-instance licensing

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

Currently we are upgrading our SQL Server 2000 box to 2008 R2 Enterprise.  However, one of the apps locks itself to the Standard edition and will not install to Enterprise (without an additional 100K).  With SQL Server Enterprise you can install multiple instances of SQL Server without additional licensing--my question is, can one of the instances be a downgraded Standard version installation from the SQL Server Enterprise license, or do we have to get an additional SQL Server Standard license for the same box?

All licenses we are looking at moving to are SQL 2008 R2 processor licenses.

View Complete Post

More Related Resource Links

Downgrading from Sharepoint 2010 Internet Enterprise to Standard (Purely a licensing rights question

My company already owns a license for Sharepoint 2010 Internet Enterprise.  We are planning a two server Internet farm.  We need to buy one more license and we only need the standard version which is significantly cheaper.  Is it allowed to use Standard when we own a license for Enterprise?

Content migration from MOSS Enterprise edition to MOSS Standard edition

Hi,     I have developed a web application using MOSS 2007 enterprise edition. I have customized the site using custom ASPX pages, custom Webpart and custom features. Also I referred http://blog.brianfarnhill.com/2009/03/19/changing-list-forms-through-code/ for updating the contents of list forms. I have configured SQL-Form based Authentication for this site. Now I have a need to migrate this site to an environment which has MOSS 2007 standard edition and use a Active Directory Authentication instead of SQL-Form based Authentication. So can anyone guide me wether this scenario is possible or it will create any compatibility issue?      Which are the precautions I need to consider for performing this task? I would appreciate any help on this. Thanks, Patav

SQL 2008 Upgrade Standard to Enterprise: Fail

I'm trying to upgrade an existing SQL Server 2008 SP1 Standard Edition to Enterprise.  Running the enterprise edition maintenance->Upgrade Edition wizard first got me the dreaded "Invoke or BeginInvoke cannot be called on a control until the window handle has been created." Eventually, I found an entry on Connect that mentioned closing all other windows and ensuring that the installer has the focus and this got me past that error.  Now that I can run the edition upgrade through to successful completion, it's not actually doing anything. Edition still reports as "Standard" and enterprise features such as "Compress Backups" do not work. I've run the upgrade twice and restarted the system to no effect. Before I do a "Rip and Replace" does anyone have any ideas on how to actually get the edition upgrade to work? Steve G. OS:    Windows Server 2008 R2 DB:    Product: SQL Server Standard Edition (64-bit)   Version: 10.0.2531.0 P.S. Just in case someone asks, yes, I did follow the instructions located here.

sql server 2008 cluster multi instance

we have a cluster with 2 nodes and we are thinking to add another instance so that node 1 takes care of instance 1 and node 2 takes care of instance 2, and at anytime they are watching each other's back. How is this done???? what is the procedure? thanks.  

2005 Enterprise upgrade to 2008 Standard?

We are currently running 2005 Enterprise Edition. Is it possible to move the database to 2008 Standard Edition?  

upgrade standard to enterprise MOSS 2007

When installed MOSS 2007, we provided the key for standard edition. Now we have to Install and configure Excel Calculation Services and full features in MOSS 2007. it is possible? If not support for standard edition how can we upgrade enterprise edition. we have a Enterprise key also.

MS SQL Server 2005 Standard or Enterprise with default encryption

Hi, I wish to know whether or not by default MS SQL Server 2005 Std or Ent edition will encrypt the communication over the network by default? As, when we test out the database activity monitoring solution to capture the SQL traffics from the network, we are unable to see the DB user name and Source Program but SQL statements is able to seen. According to the vendor, it is due to the nature of MS SQL Server 2005 that encrypt the communication by default. But, why is it only encrypted the DB user name and Source Program but not the SQL statement? Can someone provide me the answer? Is that true what the vendor claims?   regards, Teh

Move SSIS from Enterprise Ed to Standard




We have developed a SSIS solution on SQL Server 2008 R2 EE (64 bit) and now a client would like it on SQL Server 2008 R2 (64 bit), are there any issues? Workarounds ?



SQL Server 2005 standard Edition to SQL Server 2005 enterprise edition



My current version of SQL server is Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86)   Nov 24 2008 13:01:59   Copyright (c) 1988-2005 Microsoft Corporation  Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

I want to upgrade this to Enterprise edition. I would like to know the below information please

  • step by step instructions on how to perform this upgrade
  • I have databases & replications setup on this server. Will the upgrade have any adverse effects on the current replication setup?

Any help and guidance is truly appericiated. Thanks.

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

Slow sql-server after upgrade from SQL-Server 2005 x64 standard to SQL-Server 2008 R2 x64 enterprise


We moved our databases to new hardware today (using copy database wizard)


The new hardware should be better than the old one.

We went from 28 GB ram to 128 GB.

We went from 16 cores to 32 cores (with even more cache etc.). We also moved from external SAN with 40 disks to intern disks (8 Samsung SS805 100gb ssd slc)

                             According to our own metrics we could get twice the IO using IO m



We are a Prtner and get both of theseas part of our Action Pack subscription.  I am also installing CRM 4.0 on our SBS STANDARD 2008 Server.  Is it possible to put both the SQL 2008 ENTERRISE R2 and SBS 2008 STANDARD on the same box?  CRM 4.0 REQUIRES SQL for the Reporting functions etc.

  I need to do this asap as our Old Server is failing daily

Is Enterprise Edition necessary for a remote distributor, or is Standard edition sufficient


We're implementing SQLServer 2005 peer to peer replication on two servers running SQLServer 2005 EE. We also want each server to use a remote distributor (2 additional servers). Can we run SQLServer 2005 Standard Edition on the remote distributors, or is it necessary that they too need Enterprise edition?





WSS 3.0 on W2K3 Standard Server or 2K3 Enterprise?


Hi All,

Functionally, WSS 3.0 sites will work similarly on both Windows 2003 Server - Standard and Enterprise Editions. What would be the reasons for choosing one over the other?

How to Install MSDTC on a multi Instance SQL Server Fail OverCluster (SQL 2005 & Windows 2003 R2 x64


I am installing 2 SQL instances on a fail over cluster.

Currently I have my Quorum and DTC resources on the default Group and the 2 sql instances on 2 other groups.

In this way would the DTC resource  be available for both the SQL groups or is there any other way i should go about doing this ?

Unable to "upgrade" SQL 2008 Enterprise to Standard Edition - Error: the credentials you provided fo


I already tried changing the logon account for SQL services and still receive the error.

Please help.

how to upgrade moss 2007 standard edition from enterprise trail version.



i have one problem in my server.

it's trial version is expired.

Initially we deploy a trial version of moss 2007 enterprise edition.

Now i have moss 2007 standard edition with key, but it's not work on server.

Kindly suggest how to activate  standard edition.

and i want to switch SQL server to another server which is presently on same server.

Please response asap.

Ankit jain



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