Home / server / Questions / 238246
Accepted
John
Asked: 2011-02-22 09:03:04 +0800 CST

SQL Server Licensing [duplicate]

  • 772

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!

sql-server exchange licensing wss

3 Answers

  1. Best Answer

    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.

    • 4

  2. 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

    • 1

  3. 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.

    • 0