.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

SQL Server 2008R2 licensing: exactly how to update the eval license to a permanent license...

Posted By:      Posted Date: May 22, 2011    Points: 0   Category :
I have two instances of SQL Server 2008R2 running with soon-to-expire evaluation licenses.  I need a step-by-step procedure for updating the license to a permanent non-expiring license, as I have never done this and I can't seem to find this info anywhere on the web.  If there is a reference you could point me to, that would be appreciated.   Thanks, everyone!

View Complete Post

More Related Resource Links

SQL Server 2008 R2 Standard edition License update (Developer license to Production License)


We have an MSDN copy of the SQL server 2008 R2 standard edition which we have installed in production environment. We have subsequently bought a licensed copy of MS SQL server 2008 r2 Standard edition. Using the feature Maintenance and Edition Upgrade in SQL setup, we have updated the licensed product key information of the SQL server 2008 R2 from licensed setup file in production environment. We wanted to know how to view the licensed product key information from the server. Also we wanted to check if we have completed the process and we are legally using the software

Query: select serverproperty('LicenseType'),serverproperty('NumLicenses') Is always returning “Disabled” and “NULL” before and after using Edition upgrade with valid license details.


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

SQL Server 2005 Express - Does it require a Client Access License (CAL)

Do you need a Client Access License (CAL) for each device that will connect to a SQL Server 2005 Express edition database?

SharePoint 2010 - The license state for the current server doesn't match the farm's license state.

I already have a SharePoint 2010 server built, up and running. Yesterday I built a brand new server Windows 2008 and installed all necessary windows updates. Then I joined the server to the domain where the other SharePoint 2010 box is. Today, I installed all necessary pre-requisites for SharePoint 2010 including the KB971831. After that I installed SharePoint 2010 binaries on the new server. When I run the configuration wizard now, it sees the database server with the configuration database, but will not allow me to join the new server to the farm. I get the following error in the diagnostic logs. Resource retrieved id ConfigurationDatabaseTaskConnectFailConfigDisplayLabel is Failed to connect to the configuration database. 02/18/2010 17:54:12 8 INF Leaving function StringResourceManager.GetResourceString 02/18/2010 17:54:12 8 ERR Failed to connect to the configuration database.   An exception of type System.InvalidOperationException was thrown. Additional exception information: The current server cannot be joined to this farm because the set of installed products does not match the products installed in the farm.   The license state for the current server doesn't match the farm's license state. System.InvalidOperationException: The current server cannot be joined to this farm because the set of installed products does not match the products installed in the farm.

Do you need to license Office Web Apps seperate from sharepoint server 2010 enterprise license?

Hi All, I been reading this article http://technet.microsoft.com/en-us/library/ff431687.aspx#bkmk_ins_exis_farm  and have come to the conculsion that if you want word viewing services and power point services you need to license and download office web apps separate from the SharePoint Licensing/download. Can anyone confirm this that may know more about the subject? I thought those services would come along with enterprise but from what I’m reading I guess not.   Regards, Jeff

The license state for the current server doesn't match the farm's license state.

Help!!!! I removed project server 2010 from my server hosting SP 2010 and when I run the config wizard I get the error The license state for the current server doesn't match the farm's license state.  I need to bring it back online asap... :(  Any ideas please.

Microsoft SQL Server 2008 Express License For Deployment

I know that Microsoft SQL Server 2008 Express is free for download, but can i deploy it to client side for business purpose? Is there any license purchase required?

SQL Server License - PROCESSORS


Does SQL Server count sockets or cores as processors?  In other words, if you have a 4 quad core processors would SQL Server view that as 4 or 16?  In order to use all 16, do you need standard or enterprise edition? 

Even if Standard edition will use all 16, what do you need legally - from a license perspective

Need to enter new license key for SQL Server 2008. Where though?

I have searched high and low and cannot for the life of me find where to convert my trial of SQL Server 2008 with a new key. Please help!


Web Synchronization require which server edition license?


I read somewhere that mention Web Synchronization is only supported in SQL 2005 Enterprise edition. Is this true?

My client is using SQL 2005 Standard, does this mean I can't use web synchronization?

Upgrade License for SQL server 2008 R2 from evaluation to standard



I am trying to upgrade the license on a 32bit SQL Server 2008 R2 from evaluation to standard, but it said my key is invalid and refused it. I've checked with Microsoft and they said the license is a valid copy. Please help me, Thanks.


update/delete not working on server only


my aspx page works in VWD, and everything works on the server EXCEPT update and delete sql functions. any ideas?


ClickOnce: Deploy and Update Your Smart Client Projects Using a Central Server


ClickOnce is a new deployment technology that allows users to download and execute Windows-based client applications over the Web, a network share, or from a local disk. Users get the rich interactive and stateful experience of Windows Forms, but still have the ease of deployment and updates available to Web applications. ClickOnce applications can be run offline and support a variety of automatic and manual update scenarios.Learn all about it here.

Brian Noyes

MSDN Magazine May 2004

SQL Server CE: New Version Lets You Store and Update Data on Handheld Devices


Handheld device users need to be able to synchronize with a main data store when it's convenient and, preferably, when the back-end database server isn't busy. SQL Server 2000 Windows CE Edition allows you to build a traveling data store that can be displayed and run on a variety of devices. SQL Server CE supports a subset of the full SQL Server package, and can be used as a standalone server or in tandem with SWL Server and IIS. The architecture of SQL Server CE, along with data manipulation, synchronization, and connectivity issues, are discussed in this article. Topics such as making your data public, choosing the right type of replication, and handling errors are also covered.

Paul Yao and David Durant

MSDN Magazine June 2001

MOSS 2007 License and Pricing

I just need a small help related to MOSS 2007 License and Pricing.

The scenario is that we have the following number of servers and users are 750.

# moss-SQl1 - (DB server 1)
# moss-SQl2 - (Mirrored DB server 2)
# moss-app -    (Application server)
# WFE1 -  (Web front end server 1)
# WFE2 -           (Web front end server 2)
# MOSS-SQLWITNESS –   (witness server for database mirroring)

To my understanding we need to purchase:
MOSS 2007 Server Licenses -- 2 @ 4424$
Enterprise CALs           -- 750 @ 75$ + 94$ for standard CAL

and it amounts to: 2 * 4424 + (75+94) * 750 =   8848 + 126750 = 135598$.

I think this calculation has gone wrong somewhere. Could you please correct me if I assumed anything wrong here.

One more question is: If we purchage one CAL, can this be used by only one user?

Thanks, Chandralekha

How to update Sql Server related tables from Dataset(SchemaFill)

Hi!I would like to update new records that get inserted in DataSet to Sql Server Database.Below is a working example of how to do this if you use "DataAdapter.Fill(ds)". But i don't want to fill data, becouse i don't need data, i only need shema (I will use this dataset to insert new data to Sql), so i would like to use "DataAdapter.FillSchema(ds)"Please help me out at least with this one... i'm stuck... can't continue untill i crack this nut.<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default2.aspx.vb" Inherits="Default2" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title></title> </head> <body> <form id="form1" runat="server"> <div> <table> <tr> <td> <asp:GridView ID="GridView1" runat="server" ShowHeaderWhenEmpty="True"> <Columns> <asp:CommandField ShowSelectButton="True" /> </Columns>
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