Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - sql server 2000
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

sql server 2000

 Post Reply Post Reply
Author
mrdany View Drop Down
Newbie
Newbie


Joined: 02 September 2003
Status: Offline
Points: 11
Post Options Post Options   Thanks (0) Thanks(0)   Quote mrdany Quote  Post ReplyReply Direct Link To This Post Topic: sql server 2000
    Posted: 09 September 2003 at 9:17am

hello

i am just wondering, if i need to install the webwizforums on my own server...

i have a web server (win 2000 advanced server) and an sql server (but i have only license for 25 user access)

i just am wondering if i put my servers online, and lets say 100 users try to access the database at the same time, what will be the result in this case?

usually the connection string that i use to access the sql server is one username and password, so all users will be connecting to the database using the same username and password... in that case all teh web users count as one unique user or what?

i appreciate any clarifications

Thanks

Dany

Back to Top
michael View Drop Down
Senior Member
Senior Member
Avatar

Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670
Post Options Post Options   Thanks (0) Thanks(0)   Quote michael Quote  Post ReplyReply Direct Link To This Post Posted: 09 September 2003 at 9:41am
With SQL 7 you had to buy a so called Internet Connector License. This becasme obsolete with SQL2000 as they intorduced Processor licensing. As web users are close to impossible to track MS says to use Processor licenses for your web enabled SQL Server. So the answer is you basically need a processor license for each CPU in your Server. If you do not do that you theoretically would have to purchase a license for each web user which as you can imagine may add up.
Back to Top
dpyers View Drop Down
Senior Member
Senior Member


Joined: 12 May 2003
Status: Offline
Points: 3937
Post Options Post Options   Thanks (0) Thanks(0)   Quote dpyers Quote  Post ReplyReply Direct Link To This Post Posted: 13 September 2003 at 10:18am
Most of the db companies had to come out with processor based licenses as a single server-side process can access a db on the behalf of thousands of clients. Oracle at one time wanted to charge a dollar for every web user who hit one of their db's until they realized that only a single process would be accessing the db's. Dany's correct in his assumption that his 10 users would be regarded as a single user instance.

Lead me not into temptation... I know the short cut, follow me.
Back to Top
michael View Drop Down
Senior Member
Senior Member
Avatar

Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670
Post Options Post Options   Thanks (0) Thanks(0)   Quote michael Quote  Post ReplyReply Direct Link To This Post Posted: 13 September 2003 at 10:45pm
Um, I think you are wrong, as it is not one process, every user connecting creates a process. Thus I don't mind proven wrong I find MS licensing confusing. Maybe I am misunderstanding the concept but i am sure that you cannot use a 10 user sql server to serve all :countless: web users.
Back to Top
mrdany View Drop Down
Newbie
Newbie


Joined: 02 September 2003
Status: Offline
Points: 11
Post Options Post Options   Thanks (0) Thanks(0)   Quote mrdany Quote  Post ReplyReply Direct Link To This Post Posted: 15 September 2003 at 6:01am

guys!!

correct me if i am wrong, but usually the connection si made per user? or per request?

what i thought as solution is to create a 3-tier application

and all users that will request information from the database, will request the information from the application (server) which will query the database (sql server) and return the desired results to the web application...

in that way it's only one machine that is querying the database...

is that true?

(just to clarify things up, i will be hosting my own web site, so i have 3 servers, one the web server, 2 the server that will capture the requests through an application, and 3 the sql server...)

thanks again, Dany

Back to Top
dpyers View Drop Down
Senior Member
Senior Member


Joined: 12 May 2003
Status: Offline
Points: 3937
Post Options Post Options   Thanks (0) Thanks(0)   Quote dpyers Quote  Post ReplyReply Direct Link To This Post Posted: 15 September 2003 at 11:45am

Actually, I wasn't being clear. It's not many processes. It's many instances of the same process. the process requires the db credentials, not each individual instance of it that is spawned.

The Client - App Server - DB Server - Web Server model is very common. I originally separated the App and DB servers to overcome DB licensing issues bfore they changed the license model. Back then, the DB vendors had this thought that everyone sat at their desk and directly acccessed the DB through a 24x80 screen. Client-Server stuff was a shock. Internet access was another shock.

What did come out of the whole thing was a better security model.

I'd add a DMZ machine configuration you described. the web server can be on the same level as the DMZ, but the app and db servers should have all traffic to/from them routed through the DMZ. Use encryption and non-standard ports in/out of the app and db servers as well.

The Oreilly Firewall book is very good and covers some inexpensive DMZ based solutions. The basic concept is to totally remove your app and dp from web space  Only specific processes with specific credentials coming in on specific ports, using specific protocols can access specific things on the app and db servers.

IIRC, redhat, or some other linux vendors have "DMZ in a box" type solutions. I used BSD, but it requires some knowledge of IP chains and IP spoofing.


Lead me not into temptation... I know the short cut, follow me.
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.