SQL Server 2005 editions and licensing

[outonalimb]

Hi,

I have suddenly become involved with a new intranet system within an organisation. An external party has designed a new web-based intranet that allows designated users to update content, etc. However, I am concerned about this third-party web design company in terms of how they have implemented and specced the system.

They tell us that we need SQL Server 2005 Standard Edition and Windows Server 2003 to run the intranet. The intranet has been designed using HTML and ASP with SQL Server backend driving it.

We have 150 users with the organisation and the content on the intranet will only change a couple of times a week. The intranet will only be used by employees a couple of times a day - there will be no great load on the system.

SQL Server 2005 Standard Edition isn't cheap (neither is Windows Server 2003 Std Edition). Does anyone think this system is overspecced? Could we use the Workgroup Edition of SQL Server 2005?

Another important question is licensing. We have 100 users, does this mean we need 100 SQL Server Client licenses?

Any help or advice would be really welcome,

Regards,

 

[ptheriault]

>>Does anyone think this system is overspecced?
It depends on what functionality you need.

Here are a few links you'll need.

http://www.microsoft.com/sql/howtobuy/default.mspx

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[mrdenny]

In addition to the link that Paul gave here is an FAQ on SQL Server licensing faq962-5153.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[outonalimb]

So exactly how many SQL client licenses would I need to provide our intranet solution? Do I need one licence for every potential intranet user of just ONE or TWO for the webserver/ASP database calls to SQL Server.

Please advise.

 

[mrdenny]

You will need one CAL for each user.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com