Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

Possible Duplicate:
Can you help me with my software licensing question?

We are looking at moving our fractured code base that uses MySQL in some places and SQL Server in other places. I'm suggesting that for our purposes we don't need anything that MySQL can't do.

The argument is that we have to have SQL Server anyway because we have Exchange and SharePoint. I always thought that SQL Server didn't require a separate license when using Exchange or SharePoint (WSS version).

We are also using TFS.

If there is a server product from Microsoft which requires the use of SQL Server then doesn't it come with some form of licensing for SQL Server?

Can anyone lend some insight to this?

Thanks!

share|improve this question

marked as duplicate by Skyhawk, Shane Madden, Scott Pack, mailq, Mark Henderson Nov 7 '11 at 22:39

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

add comment

3 Answers

up vote 4 down vote accepted

Windows Sharepoint Services can use an embedded version of SQL 2005 ( I believe it is the Express edition, but with the 4GB limit removed), which is likely what you are using here. Obviously if you are using the embedded version, that comes with WSS and so you are not paying to licence it.

Exchange does not use SQL Server, so there is no dependency there.

So from what you have explained so far, there doesn't seem to be a reason why you have to stay with SQL Server (although obviously your WSS will continue to use it's embedded one).

Edit

As you are using TFS you will need some form of SQL server, but it can be the Express edition if you are happy with the 10GB(With 2008 R2 Express, 4GB with 2005) limit. If not you will need to pay for it.

share|improve this answer
    
I believe WSS still has the 4GB limit for the database. –  Chris Feb 21 '11 at 17:41
    
Yes it does, it is just SQL Express with nothing special done to it. –  mrdenny Feb 22 '11 at 0:17
    
@Chris @mrdenny having researched this further, by default WSS 3.0 uses the Windows Internal Database, I have not been able to find a concrete statement from MS, but it does not (from the information I have found)seem have the 4GB limit. –  Sam Feb 22 '11 at 9:50
    
Thanks for the quick response :) –  John Feb 22 '11 at 12:48
    
@Sam - The reason the limit came to mind was I'd done a test installation a couple of weeks ago and remember seeing a message during the installation. Also, this technet article refers to a 4GB limit for SQL express 2008: technet.microsoft.com/en-us/library/cc288005.aspx (Foundation) or this: technet.microsoft.com/en-us/library/cc263202.aspx –  Chris Feb 22 '11 at 13:53
show 2 more comments

Bottom line is that if the version of SQL is a paid for version and is used (i.e. not a standby copy) then you will need to license it. Hope this url answers your questions.

SQL Server 2008 Licensing Frequently Asked Questions

share|improve this answer
    
signatures and taglines are not welcome on Server Fault. If you haven't already, please give our FAQ a read. –  Ben Pilbrow Feb 21 '11 at 19:03
    
Please don't put a sigfile-type ending on answers, or a solicitation to vote up. Your contact info belongs in your profile. –  daveadams Feb 21 '11 at 19:05
    
Ok Chaps sorry didnt know. Removing any I know of. –  retracement Feb 23 '11 at 19:30
add comment

It sounds as if you want to consolidate your MySQL databases into one deployment/licensed SQL Server.

TFS 2010 pre-requisite is SQL Server 2008. In other words, SQL Server is a requirement for the TFS application, and you'd have to be licensed for it. You're free to run all kinds of databases on that server, if you like, as it's yours.

TFS can connect to & work with SQL Server 2008 Express as well. You'd be subject to that 4GB per-database limit, though.

share|improve this answer
    
So TFS does not include a license for SqlServer? If I'm not mistaken, SqlServer Express 2008 R2 has a 10gb limit, not 4gb. According to the MS docs, SqlServer is included: msdn.microsoft.com/en-US/library/ms400745(v=VS.80).aspx –  John Feb 22 '11 at 0:18
add comment

Not the answer you're looking for? Browse other questions tagged or ask your own question.