.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
MarieAdela
Imran Ghani
Post New Web Links

SQL Server License - PROCESSORS

Posted By:      Posted Date: September 29, 2010    Points: 0   Category :Sql Server
 

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




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

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?

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!

-Brent

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?


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.

 


Upgrade License for SQL server 2008 R2 from evaluation to standard

  

Hi,

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.

 


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

  
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!

call JavaScript - jQuery code from ASP.NET Server-Side

  
jQuery got so close to me lately that I can see myself adding the scripts to my project almost unconsciously. The thing is, jQuery is very useful for me, in almost all situations and it has been a do or die enhancement for all my project since I first put my hands on it.

Of course while using it, you encounter few situations which need a bit of research to solve, mostly when you are trying to combine it with some other technologies like: UpdatePanels and ASP.NET Ajax. For instance there are many situations when I would like to run some jQuery magic based on some decision that I make on the server side.

Making Ajax Callbacks to the Server Using jQuery with ASP.NET

  
In the first part of this article series I introduced jQuery's functionality and how it provides a rich client side programming model. This time around I'll expand on these concepts and show you how you can use jQuery in combination with ASP.NET using it as an AJAX backend to retrieve data. I'll also discuss how you can create ASP.NET controls and otherwise interact with jQuery content from ASP.NET pages in WebForms.


jQuery is just a JavaScript library so it will work seamlessly with ASP.NET both from page code as well as through backend driven code using the Page.ClientScript object or ScriptManager. You can use jQuery on its own as a client side and Ajax library that communicates with ASP.NET or you can use jQuery in combination with ASP.NET AJAX. The two actually complement each other quite well as jQuery provides functionality that the ASP.NET AJAX library does not and vice versa. For the most part the interaction between the two libraries is trouble free except for a few very rare edge cases.

MS SQL Server: Disconnect Users From Database - Kill User Session

  
If you ever wanted to restore your database from a SQL backup file (.bak), but there are still users connected to your database, the backup operation will fail causing the error: Exclusive access could not be obtained because the database is in use.

MS SQL Server: Search All Tables, Columns & Rows For Data or Keyword Query

  
If you need to search your entire database for specific data, this query will come in handy.

So when a client needs a custom report or some sort of custom development using Great Plains, most of the time I will have to track down the data in the system by running this query and find the table(s) it is in.

call JavaScript - jQuery code from ASP.NET Server-Side

  
jQuery got so close to me lately that I can see myself adding the scripts to my project almost unconsciously. The thing is, jQuery is very useful for me, in almost all situations and it has been a do or die enhancement for all my project since I first put my hands on it.

Of course while using it, you encounter few situations which need a bit of research to solve, mostly when you are trying to combine it with some other technologies like: UpdatePanels and ASP.NET Ajax. For instance there are many situations when I would like to run some jQuery magic based on some decision that I make on the server side

Publishing SQL Server Database using Publishing Wizard : Tips & Tricks

  
We can use SQL Server Publishing Wizard to deploy our local Database to remote hosting server/production server.This feature is available in SQL Server 2008/VWD 2008.

Below is the complete step by step guide of this process.
Categories: 
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