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 |
paramu
Posting Yak Master
151 Posts |
Posted - 2014-04-04 : 04:38:23
|
I have a small project for educational institutuin online examination. But 500 students has to login and save their answers..Is it possible to have in sql server 2008 for 500 login can access a single database & can save?Thanks for the suggestionsParamu @ PARANTHAMAN |
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2014-04-04 : 04:48:32
|
yes. you can do that KH[spoiler]Time is always against us[/spoiler] |
|
|
paramu
Posting Yak Master
151 Posts |
Posted - 2014-04-04 : 08:36:02
|
Thanks Khtan...But 500 login required or single login for 500 users to access the DB-Server?Thanks for your replyParamu @ PARANTHAMAN |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-04-04 : 16:27:08
|
You can do it either way. I prefer one account for each application and then the application controls the user security via encryption and a table that contains the user information (userid, password, etc).Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
paramu
Posting Yak Master
151 Posts |
Posted - 2014-04-05 : 12:08:51
|
Thanks to tkizer & khtanParamu @ PARANTHAMAN |
|
|
|
|
|