We help IT Professionals succeed at work.

prove that SQL Server 2008 allows multiple instances using only 1 license

llj45
llj45 asked
on
737 Views
Last Modified: 2012-05-10
Hi,
  Thanks in advance for the help!

  I have to prove to an otherwise knowledgeable experienced SQL Sever DBA that SQL Server2008 allows the use of multiple instances under one license in an enterprise or large scale environment.  These two instances would be on the same virtual database server with each instance clearly visible to other.
  Could you point me to the Microsoft web page which clearly provides this information for this large scale environment? or If I am mistaken, where does it say that another license is required.
  I need additional evidence that each license is legal to use for X number of instances and details of the legal use of the license and the instances.
  Otherwise a discussion will simply degenerate into a yes, you can and no, you can't argument.
  Unfortunately, I do not know exactly what version of SQL Server 2008 is being used.  It does involve the use RDP and cals.
  How does the IP address of the instance affect this situation?  I was told that each instance would need a new IP address?  I do not know why.
Thanks, LLJ45
Comment
Watch Question

Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Commented:
no, each instance does not need a new IP address !!

your default instance would be say

YOURSERVER\MSSQLSERVER

a new instance installed you name whatever you want, and will be connected to by

YOURSERVER\NEWINSTANCE
YOURSERVER\NEWINSTANCE2
YOURSERVER\NEWINSTANCE3
etc etc

you can replace the server name with the IP address if you wish also.

Author

Commented:
Hi,
  Thanks.

  Can each instance legally have a different IP address and still use the single license?
  Different IP addresses seem to be the way of doing this kind of work in this situation.  If possible, please show the support for this fact to me online as I will have to document this fact to the person with which I am having this discussion.
LLJ45

Author

Commented:
Hi, Humpdy
  Could you please answer my question concerning instances and IP addresses?  Again, please show the support for this fact to me from an online source.
Many Thanks, LLJ45
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
?

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.