.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

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

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

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

Please help.

View Complete Post

More Related Resource Links

Upgrade SQL server 2008 R2 from Evaluation Edition to Enterprise Edition

Hello SQL Support group, I have SQl server 2008 R2 installed on a Win 2003 R2 and it is for our SharePoint and Project server 2007 environment. Today I noticed that we have only 75 days left! Seems like we installed it on evaluation mode. Here what we have on Helpàabout : Microsoft SQL Server Management Studio Complete (expires in 75 days)    10.50.1352.12 We do have MSDN account, and we have the KEY that comes with the SQL server 2008 R2 enterprise. We would like to assign the key to our SQl server ( we want to have enterprise edition). It is in a production environment now. I would like to know how we can do it  with minimum of down time. I found this link: http://blogs.technet.com/b/sqlman/archive/2010/03/16/sql-server-2008-upgrading-to-standard-enterprise-edition-from-evaluation-edition.aspx On the internet, but doesn’t say anything that we are losing any data after upgrade or not. Please let us know the best way to assign the key, and if it has any impact in our data. Thanks Bahram  

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 performance: Decision to spend budget to upgrade to enterprise edition

Hi, Currently, we use SQL Server 2008 standard edition. We are planning to improve the performance of our application. The application is built by 3<sup>rd</sup> party and we can’t change/modify database objects and they seem to be designed fine. The options are spending our budget to upgrade to sql server hardware, or upgrade to SQL Server Enterprise edition. I am a bit confused over the benefits of SQL Server Enterprise edition. The following chart suggests that SQL EE includes “Parallel Index Operations” and “Enhanced Read-ahead and Scan”: http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx  How significant are “Parallel Index Operations” and “Enhanced Read-ahead and Scan”? Considering the fact that new hardware is cheaper than sql enterprise license, Should I spend budget to upgrade enterprise edition instead of buying as server with faster CPU and RAM? Thank you, Max

2005 Enterprise upgrade to 2008 Standard?

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

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

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?

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



Is there no way to upgrade from SQL Server 2008 Standard to SQL Server 2008 Enterprise with MSDN?

There are no Product Keys for MSDN copies?  I'm in the SQL Upgrade wizard and it needs a Product Key to upgrade?

SQL 2008 Upgrade from Standard to Enterprise



Can you tell me if this upgrade from Standard SQL 2008 to SQL Enterprise 2008 using simply the product key would also work if you have an existing A/P Standard 2008 Cluster. I wish to upgrade the hosts to Enterprise SQL 2008 to avail of Asyn Mirroring.


SQL 2005 Standard to Enterprise Edition upgrade on existing three-node cluster


Current set-up: three node cluster running Windows Server 2003 Enterprise Edition SP2 with two instances of SQL Server 2005 Standard Edition SP2.


Virtual node 1: Standard Edition, default instance, Database Engine only

Virtual node 2: Standard Edition, named instance, Database Engine, Analysis Services and Integration Services


Physical node A: Prefered node for virtual node 1

Physical node B: Failover node for both virtual node 1 and 2 (thus having two installations of Standard Edition)

Physical node C: Prefered node for virtual node 2


We started off with this set-up because there was no need for Enterprise features, and SQL 2005 supports failover clustering with two nodes in Standard Edition. Saved a bundle of cash, so everybody's happy. Now we need to run a solution on virtual node 2 that requires Enterprise features in Analysis and Integration Services, so an edition upgrade is required on virtual node 2. I have done some research and found several edition upgrade examples, but none that match the above scenario. We are running production on these machines, so I can't risk experimenting with command line options, I have to be right the first time.


Is it possible to mix two editions of SQL Server 2005 in one cluster? Can I upgrade virtual node 2 to Enterprise but leave virtual node 1 at

Error in installing SQL Server 2008 enterprise/Developer edition.


Hi, I am trying to install sqlserver 2008 enterprise edition.

I hv already installed vs-2010 professional.

OS-windows7 Ultimate

Throwing error like :


Please help...........


Cannot install SQL 2008 Enterprise edition

Hello , i am trying to install SQL 2008 Enterprise edition (trial) on my computer and i reached a stage of installation progress which showed the failure of the Analysis, Reporting, Integration, and Business intelligence. This is showing all failed, so what do i do?  

Upgrade to SQL 2008 R2 Enterprise fails

Trying to upgrade one of my SQL 2008 SP1 Enterprise (v 10.0.2531.0) edition to SQL 2008 R2 Enterprise, the OS is Windows Server 2008 (x64) SP1.  The process fails with no explanation beyond this:   Description:   SQL Server 2008 R2 Setup has encountered an error.   Problem signature:   Problem Event Name: SQL100MSI   Problem Signature 01: 10.50.1600.1   Problem Signature 02: Unknown   Problem Signature 03: SqlSupport.msi   Problem Signature 04: 0x162A16FE   Problem Signature 05: 0x1645   Problem Signature 06: Install_SqlSupport   OS Version:      6.0.6001.   Locale ID:           1033   Additional information about the problem:   LCID:    1033 I tried running the installation through Remote Desktops with Administrator login and also through Remote Desktop Connection with Administrator login, I got the same error each time.  There are no users connected to the database.  The installation is English. I have viewed the thread on Connect and it is not applicable as I'm running an English installation, not Italian and I am using the Administrator login. I saw another on another thread where they

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

Please Advice SQL 2008 Standard Edition

·         I have a issue with subscriptions since we have SQL 2008 Standard edition and i found out that Data Driven Subscription are disabled. We have about 100 reports subscribed by our internal & external customers. I have a DB "Prices" In that we have 4 Tables, Analysts,Users,SalesReps & Sub Sales rep the subscriptions are by anyone and everyone from these 4 tables.... we have a Project thats in Build in sql server 2008, which is a repository for all our 100 reports....basically what we are trying to do is based on Relationship, security level and user hierarchy they can access the reports... Any ideas will help ???????????FM

Error connecting to Remote report server database in SQL Server 2008 R2 DataCenter Edition

I am trying to configure my report server installed on Server A to point to a reporting services DB on Server B. I am able provide the name and test the connection. However, when i click next on the configuration wizard after providing the Server A name I am receiving the below error: The feature: "Remote access to report data sources and/or the report server database" is not supported in this edition of Reporting Services I have SQL Server 2008 R2 DataCenter Edition on both the servers.    

how many open connection is recommended to leave - in sql server 2008 Enterprise Edition

hi i have my C# program that work with sql-server 2008 Enterprise Edition i have 40 users that connect to this database. i dont close the connection. how many open connection is recommended to leave ? or is it better to close connection ? thank's in advance
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