Reputation: 17095
Using SQL Server for web applications
As far as I understand, due to license reqirements all web applications, which use MS SQL Server, use SQL Server Express (free) or SQL Server web edition (processor license).
Is it so?
What are other specific features of SQL Server usage for web app?
Upvotes: 0
Views: 266
Answers (3)
Reputation: 33944
SQL server allows you to use CALs only when you have identifiable users. When your connections are initiated from a public website where users don't log in, but browse anonymously, you're required to license SQL Server by processor, not by user.
Upvotes: 1
Reputation: 799
You can use any edition for web development.
You can start with 100% free express edition. Then upgrade to next level. The licensing is very flexible and the most you will need for web development is Standard edition.
Upvotes: 0
Reputation: 180948
Essentially. You use a SQL Server Processor license when you don't want to have to buy Client Access Licenses.
A complete breakdown of the SQL Server Licensing schemes is here:
Upvotes: 2
Related Questions
- Best approach to start a web application using asp.net and sql server
- Separate application server and database server
- Database Connection (SQL Server) for ASP.NET application
- SQL Server or Access Database for ASP.NET web app?
- Best strategy for windows and web application vs DB
- Deploying database for ASP .NET Website
- SQL Server - Database Questions
- Asp.net MVC Hosting - SQL Server
- SQL Server 2005 edition for Web applications
- Alternative to SQL Server for a simple web app