SQL 64 bit and 32 bit plus instances licensing questions

  1. With user cal licensing of Windows, can we rename the User Name of a user without affecting the license for that user, without paying for another license?

Change of name is not a problem for MS as long as is the same organization, in that case no additional licenses will be required.

 

  1. Can we purchase an additional license of SQL Server Standard 2008 and use that license code for SQL Server Standard 2000?

Yes, you can. However you need to use the apropiate Media CD/DVD from your agreement, available under eOpen web site or MVLS, depending how you acquire your licenses

 

  1. We currently have the trial version of Windows Server 2003 (32 bit) installed on our server, will the license codes work on this without re-installing Windows?

No, it shouldn’t work. You can try but to my understanding you will need to install the product again, I may be wrong.

 

  1. Similarly, will the 64 bit license of SQL Server work on the 32 bit version? The license and product key for 64 bit are specified for that, you can only run the 32 bit version when you are running SQL on a 64 bit windows server

SQL Server now supports the new 64-bit architecture based on the x86 instruction set with 64-bit extensions. With innovative offerings from AMD (AMD64) and Intel (Extended Memory 64 Technology or EM64T), SQL Server 2005 supports both 32-bit and 64-bit versions for a variety of business applications. This offering will run on Windows Server 2003 x64 Editions. (http://www.microsoft.com/sql/editions/64bit/overview.mspx)

 

  1. Can we install multiple instances of SQL Server on the same Server with the same license code or do we need to purchase a license per instance?

Each instance corresponding for example to a virtual machine is considered as a separate server and consequently you need to purchase additional licenses.

I)     Assigning the Required Number of Licenses to the Server.

a)    After you determine the number of software licenses you need for a server, you must assign that number of software licenses to that server.  That server is the licensed server for all of those licenses. You may not assign the same license to more than one server.  A hardware partition or blade is considered to be a separate server.

 

 

However if you buy a per processor license SQL Enterprise edition you can run multiple instances on that same physical server.

For SQL Server 2008 Enterprise Edition:

Running Instances of the Server Software.  If you assign to a server licenses equal to the total number of physical processors on the server

·         you may run, at any one time, any number of instances of the server software in one physical and any number of virtual operating system environments on that server. 

·         you do not need to license virtual processors.

For SQL Server 2008 Workgroup, Standard, and Enterprise Editions:

Fail-over Servers.  For any operating system environment in which you run instances of the server software, you may run up to the same number of passive fail-over instances in a separate operating system environment for temporary support.  The number of processors used in that separate operating system environment must not exceed the number of processors used in the corresponding operating system environment in which the active instances are running.  You may run the passive fail-over instances on a server other than the licensed server.

 

  1. This may be a dumb question but will all of the software listed in the Quote run on an Intel Core 2 Quad Processor Q6600 (64 bit)?

If it si quote for 64 bit yes it will work

 

    1. If so, is only one license of SQL Server required even though the CPU is a Core 2 Quad?

Exactly

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s