SQL - all users access db using same username - what licence required ?

[Scott]

Hello,

I have an aspx app using 2005 express and need to upgrade to standard
edition to get the features i require.

My initial thinking was a single processor licence for 2005 standard edition
as you get unlimited user connections.

The app is designed so that no matter how many users connect to the website
they always execute with the same username via stored procedures to SELECT /
INSERT data (user authentication is handled by app).

If this is the case do i just need a single user for SQL server standard
edition ?

I will easily have 2 - 10 users connecting per second to INSERT or SELECT
data by running a stored procedure then disconnecting again. At the moment
all users execute using same login passed by the app to the sp that has the
appropriate rights.

Im not sure that spending £3000 on a single cpu licence would be the correct
way forward.

I understand that if you need 25-30 users that a single cpu licence would be
more economic.

Thanks for your time and any help.
Scott

 

[Mary Chipman [MSFT]]

The "how to buy" page has comprehensive information on licensing:
http://www.microsoft.com/sql/howtobuy/default.mspx. There's a FAQ at
http://www.microsoft.com/sql/howtobuy/faq.mspx. You can also google it
to get a third-party take on licensing. HTH,

-mary

 

[Scott]

thank you.