Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-02-24 : 22:11:13
|
| Steve writes "Hi,I would be very grateful for clarification of the following.I am considering hosting several web sites on a Windows Small Business Server 2003 Premium, which includes SQL Server 2000 (Standard).I have studied the Microsoft site, and on the SBS Licensing FAQ page at http://www.microsoft.com/WindowsServer2003/sbs/techinfo/overview/licensingfaq.mspx, the following question is posed and answered:Q. Can I use the SQL Server component for Web-based business applications?A. Yes, new with Windows Small Business Server 2003 is the ability for you to use the SQL Server component for an unlimited number of un-authenticated users. As long as you are un-authenticated, you also do not need a Windows Small Business Server 2003 CAL.Can anyone tell me what this means in practise? Let's say I have 5 ASP applications, each accessing a different database in the one instance of SQL that is installed. I will have created a unique login for each database, and each application will use its respective login with password in the connection string.Is that okay do you think? I am reading this that so long as anonymous access is enabled in IIS (via the IUSR_XXX user) for each site, then this is the unauthenticated access of which they speak (rather than SQLs authentication of access to each DB).Many thanks in anticipation. Any other thoughts on hosting multiple web sites on a well-spec'ed SBS server would be welcome.Steve" |
|
|
|
|
|
Licensing - Unauthenticated Users - SBS 2003