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

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

SQL Server Licensing in a VMWare Environment with hyperthreading turned on.

Posted By:      Posted Date: September 16, 2010    Points: 0   Category :Sql Server
Question:   If we have a 2 - quad core host server with hyper-threading turned on so that we see 16 virtual cpu's how are the SQL licenses (per processor) used ? I know that a single  per processor SQL License will cover 4 virtual cpu's on a QUAD cord processor but with hyper-threading turned on does that translate to a single processor SQL license covering 8 virtual cpu's ? Thanks

View Complete Post

More Related Resource Links

SQL Server 2008 Licensing and VMWARE

Hi, We are currently running a vmware environment with 10 physical machines and we are thinking of running SQL Server 2008 Std Edition in one virtual operating environment. We already have SQL 2008 user cal's, am I correct in assuming that we only now need one SQL Server 2008 Std Edition Server license, or do we need to licence each of the 10 machine the VOE could be running on. Thanks Adam Sankey

Cannot export from a Report in SharePoint integrated mode in a server hardend environment


We have installed Reporting Services 2008 integrated with MOSS with SQL Server 2008 on a 64 bit platform.

The environment has worked fine in test (but the servers are not hardend).

With the production environment, any attempt to export from a report into another format (eg excel, tiff etc) results in an unexpected error within SharePoint requiring closing the browser and reopening.

There are no details behind the error. We can also find no traces of the error within any of the logs (SharePoint, Reporting Services, Windows event log etc)

When the report is opened directly from Reporting Services (ie http://servername:8080/reportserver) the report exports fine. Similarly, if the report is opened directly from Report Builder 2, or through opening Report Builder 2 from SharePoint there is no issue. This issue only happens when the report is invoked directly through SharePoint.


We can only assume that this issue has something to do with server hardening/UAC as we have

SQL Server 2005 - Installation in Cluster Environment - "Service SQL Server Browser (SQLBrowser) fai

Windows Server 2003 R2 Enterprise Edition SP2 32-bit All updates and patches installed Two-node cluster environment configured. Cluster functions perfectly. Trying to install SQL Server 2005 Enterprise Edition (32-bit) as a clustered application. Installation proceeds fine until it begins to install the SQL Server Database Services product. Status window says "Starting Services. Service: SQL Server Browser". Error message is presented: "Service 'SQL Server Browser' (SQLBrowser) failed to start. Verify that you have sufficient privileges to start system services". SQL Server Service Account is in the Administrators group on both local systems, and is a domain account. Account used for the installation is in the Administrators group on both local systems, and is a domain account. Have cancelled out of the install and rebooted both servers numerous times. Exact same error continues to occur. Cluster is active and all resources are owned by node #1 - the node where SQL Server Installation is being run. In the event viewer, I see: Event ID: 10 Description: The SQLBrowser service was unable to establish SQL instance and connectivity discovery". I am also seeing errors like: Source: SQLBrowser. The SQL configuration for SQL is inaccessible or invalid. Source: SQLBrowser. The Configuration of the AdminConnection\TCP protocol in the SQL instance xxxxxx i

Sql Server 2005 Cluster on EXS 4.0 VMWARE

Hi, I have this problem, i have sql server on Cluster with two nodes, the nodes are machine vmware, i was exs 3.5 and in december the esx was upgrade to version 4.  Of January the nodes present this problem:The node lost communication with cluster node 'SVRSQLN02' on network 'Servidores'.The node lost communication with cluster node 'SVRSQLN02' on network 'HeartBeat'.What can i do?

Network failure in Cluster Environment,will it stop the SQL Server Instances?

Hi All I have problem with cluster Environment that is there is network failure in Cluster Environment,will it stop SQL Server Instances Event viewrer Information 6:22:09 The MSSQLSERVER service entered the stopped state. 6:22:05 The MSSQLSERVER service was successfully sent a stop control. 6:22:04 The SQLSERVERAGENT service entered the stopped state. 6:21:43 The node lost communication with cluster node 'MSSQL0002' on network 'LAN'. 6:22:02 The SQLSERVERAGENT service was successfully sent a stop control. 6:22:02 Cluster resource 'SQL IP Address1(SQLCLUSTER)' in Resource Group 'SQL' failed. 6:22:02 The TCP/IP interface for Cluster IP Address 'Cluster IP Address' has failed. 6:22:02 The TCP/IP interface for Cluster IP Address 'Cluster IP Address' has failed. 6:22:02 The TCP/IP interface for Cluster IP Address 'MSDTC IP address' has failed. 6:22:02 The TCP/IP interface for Cluster IP Address 'MSDTC IP address' has failed. 6:22:02 The TCP/IP interface for Cluster IP Address 'SQL IP Address1(SQLCLUSTER)' has failed. 6:21:58 The TCP/IP interface for Cluster IP Address 'SQL IP Address1(SQLCLUSTER)' has failed. 6:21:58 Cluster network 'LAN' is operational (up). All available server cluster nodes attached to the network can communicate using it. 6:21:58 The interface for cluster node 'MSSQL0002' on network 'LAN' failed. If the condition persist

SSIS Deployment Reads local Environment Variable and not Server

Hi All, I have an SSIS package that uses an Environment variable to hold the connection string for the local SSISConfiguration table.  This works properly on my local machine.  However, when I import the package to Integration Services(through SSMS) it reads the environment variable from the local machine and not the server it is deployed to.  If I log on to the server remotely and do the same process it uses the the correct environment varible... (SQL Server 2005) Is there a way to deploy the package to the server and get it to use the correct Env variable without having to log-in to the server and import it?  Let me know if anyone is looking for additional information.   Thanks!

Visual Studio 2010 Lab Environment for Student to deploy to a IIS 7.5 web server with SQL 2008

Currently the environment I am trying to create is a teaching lab for Visual Studio 2010 and ASP.NET website development. The intent is to setup an environment where students can create a website with an attached database written with the assistance of Visual Studio 2010. When the website is completed they need to use one of the Visual Studio deploy technologies to upload the website to a locally run server (Windows 2008 R2 with IIS 7.5 running and SQL Server 2008.) I am responsible for setting up the correct deploy technology in Visual Studio as well as setting up the IIS 7.5 deployment server that is running the right version of SQL Server. I have already started this process and figured out how to configure a deployment package in visual studio and have it published on our local server. I am trying to get a very streamlined environment that does not require students have to configure a lot of SQL strings and IIS settings because this is not really what the teaching lab is all about. Just to let you know, we have had  this exact setup using Visual Studio 2008, Server 2003 with front page server extensions on IIS 6.0 and SQL Server Compact edition running on the server. My issue is that since it is now time to update everything there does not seem to be something comparable. Any help would be greatly appreciated. If someone has an idea of the 

Is there any article or webcast for how to set up a SQL Server Clustering in Hyper-V environment?

I have already set up a Windows Server 2008 R2 Enterprise x64 with Hyper-V installed for trying out different features in SQL Server.  I'm interesting in trying out SQL Server Clustering.  I have only set up Windows 7 Enterprise x64, Windows 7 Pro x64,  and Windows XP PRO SP2 x86 VMs.  Can I use this VMs for SQL Server 2005 or 2008 Clustering?  Is there any article or webcast for how to set up a SQL Server Clustering in Hyper-V environment?

asp menu working fine in the dev environment but not on server

Hi guys,        I am sorry to be asking what is probably a really stupid question, but i have a problem with my asp menu, when i run it on my dev machine(thru vs2010) it works perfectly, all the menu's are displayed correctly with the correct child items in the correct order but when i publish it to the server all the menu items become flat and take up the whole page. I am populating the menu using a reentrant function as follows to call the function and add the menus i am using Dim childMenuItems As List(Of MenuItem) = CreateMenuLevel(0, uniquemenulist)childMenuItems.ForEach(Sub(n) NavigationMenu.Items.Add(n)) Public Function CreateMenuLevel(ByVal parentId As Integer, ByVal menulist As List(Of MenuList)) As List(Of MenuItem)        Dim menuItems As New List(Of MenuItem)        For Each menuListItem As MenuList In menulist.Where(Function(n) n.ParentId = parentId)            Dim MenuItem As New MenuItem            If (Not String.IsNullOrEmpty(menuListItem.PagePath)) Then                MenuItem.NavigateUrl = menuListItem.PagePath           

incoming email on WSS 3.0 in a standalone server environment


Hello Everyone, I have a windows SBS 2008 with exchange 2007 and WSS 3.0 2007 all on one server.

My problem is as follows, I have been trying to set up incoming email inside of wss 3.0, but every guide, blog, and wiki says I need to have SMTP installed, I however cannot have this installed with my configuration. I have created a exchange send connector, created a drop folder, and when I try to email a document to a document library, I get a failure in exchange as follows:

Diagnostic information for administrators:


Generating server: SCS01.scs.com

MS SQL Server 2005 and Windows server 2003 Environment




I wish to know how SQL Server 2005 is linked to Windows server 2003 Environment. I have knowledge about oracle databases. But Microsofet products are new to me.

To put it simple purpose of SQL Server 2005 and Windows server 2003. How both are linked ?




SQL Server 2008 R2 and MSDN Licensing


I am creating a VM for the development team of an upcoming project and have a question around licensing.

The MSDN download for SQL Server 2008 R2 now comes pre-pidded.  Does this mean that I can download and install the full server install on the VM using the pre-pidded product key?  All the developers have their own MSDN subscriptions so they would have legitimate licenses.  I just don't want them to have to install SQL on the VM before they start work.

Ideally I will sysprep the images using the new prepared image functionality in R2.

My thought was to download the MSDN iso and then extract it to a folder on the VM.  Then I can run a prepared image install and sysprep the image.  I can then script up the final part of the install to run when the VM is first fired up.  The only issue here is if the license key would have to change.  Hopefully I can confirm that the pre-pidded download will be fine for all developers with a valid MSDN subscription.


Clone production Sharepoint 2010 server to Developmet environment - steps? help?


Greetings all,

I'd really appreciate some thoughts and suggestions about how to make a clone of our Sharepoint 2010 Production environment that we can use for testing and development.

At the moment, we are likely to have two different servers (Production is a much more expensive, powerful server) for the scenarios; so if we make a direct clone, the Windows OS files would be upset.

Would it be enough to simply copy the Windows Shared files into the Dev system (taking all modifications with it) and the db into a cloned db?

If not, what are the things we'll have to consider, and/or has anyone accomplished this yet?

Thanks for your tips and suggestions!


How to take backup of single table in SQL server 2008 and SQL Server Management Studio Environment



I know how to take total database backup in SQL server 2008 and SQL Server Management Studio Environment but i failed to take single table backup in database.

It is possible to take single table backup in Oracle using PL/SQL Developer IDE.

Thanks in Advance..... 

sql server 2005 turned off

Hi my question is in relation to my SQL server being turned off! i have tried to restart it automaticily and manually, but each time i keep getting a 1067 error message. Any help would be greatly appreciated :)

SQL Server 32 bit migrate on Sharepoint 2010 environment


We have a small website hosted in Sharepoint 2007 SP1 and SQL Server 2005( all 32bit environments).

I wanted to migrate this site into Sharepoint 2010 and SQL Server 2008 Express SP1.

I have taken the database backup from the 32bit environment.How to restore them on SQL Server 2008 Express edition on 64bit where Sharepoint 2010 running machine in order to migrate SP2007 to SP2010

Step by step or suggestions are most appreciable :)-

Think More..Do More..

SQL Server 2008 Licensing Question?


I know the same question is being asked many time from you, but I am curious to know the answer to my question.


SQL Server licensing says you don't have to purchase any new license for (Mirroring, Clustering, Log Shipping) as long as it is not up and running beyond 30 days and less or equal processors then the active sql server.

I want to check how the licensing works when the DR site is setup with SQL Transactional Replication, where the target server is just a stand-by but active.

Please Advise. Thanks 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